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
Thousands of learners have changed their careers with Dataquest
Learners who recommend
Dataquest for career advancement
Dataquest rating on
G2Crowd and SwitchUp
Average salary boost
for learners who complete a path
Join a community of 1M+ data learners on Dataquest
Sign up for a free account
Get access to hundreds of free lessons.
Choose a course or path
Start anywhere, from beginner topics to advanced concepts.
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.