Course

You'll learn how to:

Start this course today

Build hands-on data skills with interactive exercises and projects.

Sign up

About this course

In our Intermediate SQL for Data Analysis course, you’ll extend on the SQL skills you learned in the SQL Fundamentals course. By the end of this course, you’ll feel confident in your ability to answer business questions using SQL.

In our hands-on, interactive lessons, you’ll learn concepts such as the different types of joins and how to combine joins with subqueries to answer business questions. You will also learn how to write queries using three or more tables, how to perform recursive joins and pattern matching, and how to control what the data will look like with CASE statements.

As you progress further, you’ll learn how to build and organize complex queries to make them more readable with the WITH clause, and how to use set operations such as UNION, UNION ALL, EXCEPT, and INTERSECT to combine tables. You’ll also learn relational database concepts such as normalizing a table, designing and creating a database, and more.

Because our focus is always on real-world application, you’ll learn how to frame business questions as advanced SQL queries and how to write analysis to communicate the results of your work. When you’ve finished the final guided project, you have a great showcase of your SQL skills to present to potential future employers.

By the end of this course, you’ll be able to:

  • Query data across multiple tables.
  • Answer business questions using SQL.
  • Understand table relations and how to create and modify databases.

Lessons in this course

Loading lessons....

Thousands of learners have changed their careers with Dataquest

97%

Learners who recommend
Dataquest for career advancement

4.9 stars

Dataquest rating on
G2Crowd and SwitchUp

$30k

Average salary boost
for learners who complete a path

Join a community of 1M+ data learners on Dataquest

1

Sign up for a free account

Get access to hundreds of free lessons.

2

Choose a course or path

Start anywhere, from beginner topics to advanced concepts.

3

Learn with hands-on exercises

Learn with real data and build your experience.

Apply your skills

Create projects, build your portfolio, and build your career.

Sign up today

or