Skip to main content
HomeSQLIntermediate SQL

Intermediate SQL

4.7+
692 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 exercises
262,823 learnersTrophyStatement of Accomplishment

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

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Certification Available

SQL Fundamentals

Go To Track
Certification Available

Data Scientist in Python

Go To Track
Certification Available

Data Scientist in R

Go To Track
  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
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Certification Available

SQL Fundamentals

Go To Track
Certification Available

Data Scientist in Python

Go To Track
Certification Available

Data Scientist in R

Go To Track

In other tracks

Associate Data Analyst in SQLAssociate Data Engineer in SQL

datasets

Films CSVPeople CSVReviews CSVRoles CSV

collaborators

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

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 692 reviews
81%
14%
4%
1%
1%
Sort by
  • Ramasubramanian S.
    2 days

    Actually this course had an plenty of concepts to learn.

  • Jaeha K.
    4 days

    This is the best lecture in Datacamp. Other lectures in Datacamp tend to list down all the information without clear instructions, with many jumps, examples hard to follow unless you already know Computer Science. However, this lecture is very easy to follow and shows very good examples.

  • Alan P.
    4 days

    What's incredible about this course is the practice it offers, you learn a lot by applying knowledge!

  • Olivia C.
    5 days

    Engaging and Informative for a first-time learner

  • Teofilo R.
    5 days

    Lo unico que sigue en ingles una parte

"Actually this course had an plenty of concepts to learn."

Ramasubramanian S.

"This is the best lecture in Datacamp. Other lectures in Datacamp tend to list down all the information without clear instructions, with many jumps, examples hard to follow unless you already know Computer Science. However, this lecture is very easy to follow and shows very good examples."

Jaeha K.

"What's incredible about this course is the practice it offers, you learn a lot by applying knowledge!"

Alan P.

FAQs

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