Course: From Reports to Insights with SQL

Take your SQL skills to the next level.

This third course in our SQL course skill path is all about taking your SQL query skills and applying them to new and more complex real-world scenarios. You've got the fundamentals down — now it's time to dig deeper with topics like aggregate functions and summary statistics.

DURATION
2 Hours
LESSONS
7
DIFFICULTY
Intermediate
ENROLLED
341,010
Start learning for free
No credit card required.
By creating an account you agree to accept our terms of use and privacy policy.


Do what you couldn't do before.


Ace your interviews. You'll be coding from the get-go and you can take this experience directly into your next technical SQL interview.


Get premium learning content. Our in-house team of senior data experts developed our SQL courses based on real-world applications. You can take what you learn from this content directly into your current (or future) data job.


Learn one step at a time. This step-by-step learning path will teach you everything you need to know at your own pace.


Course Structure: From Reports to Insights with SQL

Continue your learning journey with SQL!

Aggregate Functions with SQL

Learn how to use aggregate functions in SQL.

Summary Statistics with SQL

Learn to combine aggregate functions with the WHERE clause, combine aggregate and scalar functions, and combine aggregate functions and arithmetic operators.

Group Summary Statistics with SQL

Learn about GROUP BY, when to use it, and how it can be combined with aggregate functions.

Multiple Group Summary Statistics

Learn how to group database rows based on several criteria, and how to filter aggregate rows.


It's not just what you learn,
but how you learn it.

Dataquest is recommended by 97% of students for learning data skills.

Retain

Learn by writing and validating code, not by watching videos.

Reinforce

Challenge yourself with dozens of SQL practice problems.

Reference

Revisit what you've learned anytime you need a refresher.

Join over 1 million data learners!

Rated 4.85/5 on Switchup + Voted Best Bootcamp Winner of 2021

David Rodrigues @davidorodrigues

I left datacamp for @dataquestio. 10x better I wish I had started Dataquest 2 years ago.

1

3

6

Lysdel Tellez @LysdelTellez

It’s great! So many options; R, SQL, Python. And they take you on guided projects where you understand the reasoning behind the code and are able to apply it to future projects.

2

5

14

Cesar Jr @ceeezthedata

I've been learning data science with Dataquest — and it's a game changer! No boring videos or fill-in-the-blank exercises. Try it for yourself!

2

5

14

ChukwuSom @legally_6lack 

Studying with @dataquestio has been the best decision I have made this year.

13

2

24

Ijeoma Benson @ijeybenson

If you want to get into a career in data, choose DQ. The education they offer would stretch you and prepare you for real life work.

33

12

86

Matthew Madden @mattmadden

I've found @dataquestio super helpful in levelling up my data skills. #100daysofcode #DataScience 

12

7

17

We Learn Better Together

When you join Dataquest, you join a community of committed learners.


Get fast help with your technical questions 


Share your projects and get supportive feedback


Chat one-on-one with developing data experts


Get career tips from career moderators


Start learning SQL today!

Looking for something else? Browse our career paths.

Start learning for free
No credit card required.
By creating an account you agree to accept our terms of use and privacy policy.