Loading...

Course Description

Databases are a requirement for virtually all organizations as a way of storing information digitally, with SQL employed as the main programming language to communicate with and manipulate those databases.

In this course, you will discover how datasets can be explored and manipulated using SQL. You will go from exploring what SQL is and writing your first query to understanding how to produce categorically targeted summary statistics from a large database. Along the way, you will explore a large dataset, filter and group data based on categorical and conditional preferences, and order that data, thereby yielding valuable insights and exemplifying best practices to bring back to your role.

Faculty Author

Vishal Guar

Benefits to the Learner

  • Extract basic information from raw data using simple SQL syntax
  • Filter relevant data to begin exploring business questions
  • Create summary statistics using pivot tables to prepare for deeper analysis

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 08, 2024 to May 21, 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 17, 2024 to Jul 30, 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
Sep 25, 2024 to Oct 08, 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 04, 2024 to Dec 17, 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 .