Skip to main content
René Jensen avatar

René Jensen has completed

Intermediate SQL

Start course For Free
4 hr
3,950 XP
Statement of Accomplishment Badge

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!
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Selecting Data

    Free

    In this first chapter, you’ll learn how to query a films database and select the data needed to answer questions about the movies and actors. You'll also understand how SQL code is executed and formatted.

    Play Chapter Now
    Querying a database
    50 xp
    Learning to COUNT()
    50 xp
    Practice with COUNT()
    100 xp
    SELECT DISTINCT
    100 xp
    Query execution
    50 xp
    Order of execution
    100 xp
    Debugging errors
    100 xp
    SQL style
    50 xp
    SQL best practices
    100 xp
    Formatting
    100 xp
    Non-standard fields
    50 xp
  2. 2

    Filtering Records

    Learn about how you can filter numerical and textual data with SQL. Filtering is an important use for this language. You’ll learn how to use new keywords and operators to help you narrow down your query to get results that meet your desired criteria and gain a better understanding of NULL values and how to handle them.

    Play Chapter Now
    Filtering numbers
    50 xp
    Filtering results
    50 xp
    Using WHERE with numbers
    100 xp
    Using WHERE with text
    100 xp
    Multiple criteria
    50 xp
    Using AND
    100 xp
    Using OR
    100 xp
    Using BETWEEN
    100 xp
    Filtering text
    50 xp
    LIKE and NOT LIKE
    100 xp
    WHERE IN
    100 xp
    Combining filtering and selecting
    100 xp
    NULL values
    50 xp
    What does NULL mean?
    50 xp
    Practice with NULLs
    100 xp
  3. 3

    Aggregate Functions

    SQL allows you to zoom in and out to better understand an entire dataset, its subsets, and its individual records. You'll learn to summarize data using aggregate functions and perform basic arithmetic calculations inside queries to gain insights into what makes a successful film.

    Play Chapter Now
    Summarizing data
    50 xp
    Aggregate functions and data types
    100 xp
    Practice with aggregate functions
    100 xp
    Summarizing subsets
    50 xp
    Combining aggregate functions with WHERE
    100 xp
    Using ROUND()
    100 xp
    ROUND() with a negative parameter
    100 xp
    Aliasing and arithmetic
    50 xp
    Using arithmetic
    50 xp
    Aliasing with functions
    100 xp
    Rounding results
    100 xp
  4. 4

    Sorting and Grouping

    This final chapter teaches you how to sort and group data. These skills will take your analyses to a new level by helping you uncover critical business insights and identify trends and performance. You'll get hands-on experience to determine which films performed the best and how movie durations and budgets changed over time.

    Play Chapter Now
    Sorting results
    50 xp
    Sorting text
    50 xp
    Sorting single fields
    100 xp
    Sorting multiple fields
    100 xp
    Grouping data
    50 xp
    GROUP BY single fields
    100 xp
    GROUP BY multiple fields
    100 xp
    Answering business questions
    50 xp
    Filtering grouped data
    50 xp
    Filter with HAVING
    100 xp
    HAVING and sorting
    100 xp
    All together now
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In other tracks

Data AnalystData ScientistData ScientistSQL Fundamentals

datasets

Films CSVPeople CSVReviews CSVRoles CSVCourse Glossary: Intermediate SQL

collaborators

Collaborator's avatar
Amy Peterson
Collaborator's avatar
James Chapman
Collaborator's avatar
Izzy Weber

prerequisites

Introduction to SQL
Yassin Zain Alabdeen HeadshotYassin Zain Alabdeen

Staff Engineer, DataCamp

Yassin is a Staff Engineer at DataCamp, where he focuses on AI-powered learning experiences. He was a member of the technical founding team at Optima, an AI-native learning platform acquired by DataCamp in 2025. Previously, Yassin spent four years at Talabat (part of Delivery Hero), where he led the effort to build the company's in-house fraud prevention solution. He holds a Bachelor's degree in Computer Engineering from Middle East Technical University (METU) and a Master's degree in Data Science from Heriot-Watt University.
See More
Yusuf Saber HeadshotYusuf Saber

Chief AI Officer, DataCamp

Yusuf is the Chief AI Officer at DataCamp, where he leads the company’s AI strategy and product innovation. He founded Optima, an AI-native learning platform that was acquired by DataCamp in 2025. Previously, Yusuf led data and AI teams at Careem (acquired by Uber) and Talabat (part of Delivery Hero), where he built scalable machine learning systems. He holds a Master’s degree in Machine Learning from ETH Zurich (Swiss Federal Institute of Technology).
See More
Jasmin Ludolf HeadshotJasmin Ludolf

Senior Data Science and AI Content Developer, DataCamp

Jasmin is a Senior Content Developer at DataCamp. After ten years as a global marketing manager in the music industry, she changed careers to follow her curiosity for data. Her passion is value exchange and making data science and AI accessible to all.
See More

Join over 18 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.