SQL for Data Analysis

In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.

In this lesson, you will learn how to combine data from multiple tables together.

In this lesson, you will learn how to aggregate data using SQL functions like SUM, AVG, and COUNT. Additionally, CASE, HAVING, and DATE functions provide you an incredible problem solving toolkit.

In this lesson, you will be learning to answer much more complex business questions using nested querying methods - also known as subqueries.

Cleaning data is an important part of the data analysis process. You will be learning how to perform data cleaning using SQL in this lesson.

Compare one row to another without doing any joins using one of the most powerful concepts in SQL data analysis: window functions.

Learn advanced joins and how to make queries that run quickly across giant datasets. Most of the examples in the lesson involve edge cases, some of which come up in interviews.

Congratulations on your graduation from this program! Please join us in celebrating your accomplishments.