SQL Summary
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.
2 Hours
4
Beginner
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.
Your SQL questions, answered:
Course Structure: Summarizing Data in 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.