Skip to main content

Intermediate SQL

4.7+
303 reviews
Beginner

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
4 Hours14 Videos50 Exercises93,910 Learners

Create Your Free Account

GoogleLinkedInFacebook

or

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

Loved by learners at thousands of companies


Course Description

SQL is the most popular language for turning raw data stored in a database into actionable insights. Using a database of films made around the world, this course covers:

✓ How to filter and compare data
✓ How to use aggregate functions to summarize data
✓ How to sort and group your data
✓ How to present your data cleanly using tools such as rounding and aliasing

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

In the following tracks

Data Analyst in SQLData EngineerData Scientist Professional with PythonData Scientist Professional with RSQL Fundamentals

Collaborators

Izzy Weber
Amy Peterson
James Chapman

Prerequisites

Introduction to SQL
Jasmin Ludolf HeadshotJasmin Ludolf

Data Science Content Developer, DataCamp

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

Don’t just take our word for it

*4.7
from 303 reviews
80%
17%
2%
0%
1%
Sort by
  • Maximo R.
    about 14 hours

    N/A

  • Paul J.
    about 15 hours

    Easy to understand

  • Eve S.
    about 16 hours

    It's easy to notice that course is planned very well. Tips system is nice and sandbox works nicely

  • Chia M.
    3 days

    Great practice and guidance to get the concept right.

  • Veronika K.
    5 days

    The course was great, nice explanations and everything. Maybe leave a little bit more time at the end of slides (but one can pause it, so no big deal). It is great that you have the subtitles and also all the presentations are written down and right next to the presentations. That is very helpful for all of us not native English speakers. What annoyed me though were the budgets in all different currencies. Doing (a little bit of) data analysis when budgets are in diff. currencies doesn´t make sense.

  • Loading ...

"N/A"

Maximo R.

"Easy to understand"

Paul J.

"It's easy to notice that course is planned very well. Tips system is nice and sandbox works nicely"

Eve S.

FAQs

Join over 11 million learners and start Intermediate SQL today!

Create Your Free Account

GoogleLinkedInFacebook

or

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