Skip to main content

Course

Intermediate SQL

Beginner

4.8+

Updated 05/2025

Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!

Start Course for Free

Included withPremium or Teams

SQLData Manipulation4 hours14 videos50 Exercises3,950 XP349,199Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

SQL is widely recognized as the most popular language for turning raw data stored in a database into actionable insights. This course uses a films database to teach how to navigate and extract insights from the data using SQL.

Discover Filtering with SQL

You'll discover techniques for filtering and comparing data, enabling you to extract specific information to gain insights and answer questions about the data.

Get Acquainted with Aggregation

Next, you'll get a taste of aggregate functions, essential for summarizing data effectively and gaining valuable insights from large datasets. You'll also combine this with sorting and grouping data, adding another layer of meaning to your insights and analysis.

Write Clean Queries

Finally, you'll be shown some tips and best practices for presenting your data and queries neatly. Throughout the course, you'll have hands-on practice queries to solidify your understanding of the concepts. By the end of the course, you'll have everything you need to know to analyze data using your own SQL code today!

Prerequisites

Introduction to SQL

1

Selecting Data

Querying a database

Learning to COUNT()

Practice with COUNT()

SELECT DISTINCT

Query execution

Order of execution

Debugging errors

SQL best practices

Non-standard fields

2

Filtering Records

Filtering numbers

Filtering results

Using WHERE with numbers

Using WHERE with text

Multiple criteria

Using BETWEEN

Filtering text

LIKE and NOT LIKE

Combining filtering and selecting

NULL values

What does NULL mean?

Practice with NULLs

3

Aggregate Functions

Summarizing data

Aggregate functions and data types

Practice with aggregate functions

Summarizing subsets

Combining aggregate functions with WHERE

Using ROUND()

ROUND() with a negative parameter

Aliasing and arithmetic

Using arithmetic

Aliasing with functions

Rounding results

4

Sorting and Grouping

Sorting results

Sorting text

Sorting single fields

Sorting multiple fields

Grouping data

GROUP BY single fields

GROUP BY multiple fields

Answering business questions

Filtering grouped data

Filter with HAVING

HAVING and sorting

All together now

Congratulations!

Intermediate SQL

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.8

from 7,818 reviews

89%

10%

1%

0%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Yoshio

18 minutes

Amna

29 minutes

This course gave me a deep knowledge about AGGERAGATE FUNCTIONS,ORDER BY ,GROUP BY,HAVING,WHERE AND LIMIT CLAUSE. I've gained a solid understanding of the concepts and truly appreciate the clear explanations and interactive exercises. It has boosted my confidence and skills in this area.

Andreas

about 1 hour

Mourey James

about 1 hour

Ramon

about 2 hours

This Intermediate SQL was well organized and paced. I paused as necessary to take notes some of the complex materials. Overall, a really good cource!

Kim

about 1 hour

Thought is was difficult, I would have liked some more practise exercises.

Yoshio

"This course gave me a deep knowledge about AGGERAGATE FUNCTIONS,ORDER BY ,GROUP BY,HAVING,WHERE AND LIMIT CLAUSE. I've gained a solid understanding of the concepts and truly appreciate the clear explanations and interactive exercises. It has boosted my confidence and skills in this area."

Amna

Andreas

FAQs

Join over 16 million learners and start Intermediate SQL today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.