Skip to main content

course

Intermediate SQL

Beginner

4.7+

Updated 12/2024

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 for FreePremium or Teams

SQLData Manipulation4 hours14 videos50 exercises3,950 XP293,450Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

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.7

from 752 reviews

82%

13%

4%

1%

1%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Adrian B.

1 day

It was really practical and intuitive. I've learned more from this than I've learned from other courses.

Herman S.

2 days

Covered keywords well

Gürkan E.

2 days

Learning content was great and it was easy to follow. Being able to do the pratice right after the theoretical information has eased the procces. I am highly motivated to continue learning on DataCamp!

Miguel S.

6 days

It’s been a great course. I’m going to practice more in order to memorise better GROUP BY and ORDER BY. It’s well explained.

Christina R.

8 days

This course was by far one of the best online courses I’ve taken. . ever. From the thorough explanations to the videos and practice queries. It was neurodivergent friendly and boosted my confidence in learning SQL.

"It was really practical and intuitive. I've learned more from this than I've learned from other courses."

Adrian B.

"Covered keywords well"

Herman S.

"Learning content was great and it was easy to follow. Being able to do the pratice right after the theoretical information has eased the procces. I am highly motivated to continue learning on DataCamp!"

Gürkan E.

FAQs

Join over 15 million learners and start Intermediate SQL today!

Create Your Free Account

Google LinkedIn Facebook

or

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