Loading...

Course Description

Many different business applications rely on SQL as a backend process to communicate with and manipulate databases, which provides the information and statistics required for related business operations.

In this course, you will practice integrating and analyzing data from multiple tables. You will discover how to fully utilize the structure of relational databases and apply that knowledge to understand how highly complex business questions are answered. Along the way, you will identify how to systematically approach queries using an assortment of new clauses, thereby expanding your problem-solving capacity and ability to deliver varied outputs of your own choosing.

The following courses are required to be completed before taking this course:

  • Exploring Data

Faculty Author

Shawn Mankad

Benefits to the Learner

  • Build a query using JOIN statements and understand the schema of databases
  • Create summary statistics of joined data to map business objectives to a desired result
  • Use SELF JOINs and subqueries to answer complex questions
  • Write a query using set operations to extract information from multiple entities

Target Audience

  • Business analysts
  • Professionals who work with databases or data warehouses
  • Managers using data insights to make business decisions
  • Marketing analysts
  • Product analysts

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
May 22, 2024 to Jun 04, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Type
2 week
Dates
Jul 31, 2024 to Aug 13, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Type
2 week
Dates
Oct 09, 2024 to Oct 22, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Type
2 week
Dates
Dec 18, 2024 to Dec 31, 2024
Total Number of Hours
24.0
Course Fee(s)
Contract Fee $0.00
Section Notes

IMPORTANT COURSE INFORMATION

  • During this program, you will need to download SQLite from the course onto your computer. Once the course has become available, you can find installation instructions in the section labeled “Course Resources” in your module list. Please be prepared to install SQLite as indicated in the context of the first course.
  • Please note that the content in our “Data Management in SQL” course curriculum was developed to be completed in sequential order, as course concepts build throughout the program. With this in mind, please be sure you are scheduled to complete or have completed “Exploring the Data” prior to “Integrating Data From Multiple Tables,” “Integrating Data From Multiple Tables” prior to “Extracting Insights From the Data,” and so on.
Required fields are indicated by .