Skip to main content
HomeSQL

Data Manipulation in SQL

4.4+
190 reviews
Beginner

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.

Start Course for Free
4 hours15 videos55 exercises243,384 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.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

So you've learned how to aggregate and join data from tables in your database—now what? How do you manipulate, transform, and make the most sense of your data? This intermediate-level course will teach you several key functions necessary to wrangle, filter, and categorize information in a relational database, expand your SQL toolkit, and answer complex questions. You will learn the robust use of CASE statements, subqueries, and window functions—all while discovering some interesting facts about soccer using the European Soccer Database.
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.

In the following Tracks

Certification Available

SQL Fundamentals

Go To Track
Certification Available

Associate Data Analyst in SQL

Go To Track
  1. 1

    We'll take the CASE

    Free

    In this chapter, you will learn how to use the CASE WHEN statement to create categorical variables, aggregate data into a single column with multiple filtering conditions, and calculate counts and percentages.

    Play Chapter Now
    We'll take the CASE
    50 xp
    Basic CASE statements
    100 xp
    CASE statements comparing column values
    100 xp
    CASE statements comparing two column values part 2
    100 xp
    In CASE things get more complex
    50 xp
    In CASE of rivalry
    100 xp
    Filtering your CASE statement
    100 xp
    CASE WHEN with aggregate functions
    50 xp
    COUNT using CASE WHEN
    100 xp
    COUNT and CASE WHEN with multiple conditions
    100 xp
    Calculating percent with CASE and AVG
    100 xp
  2. 2

    Short and Simple Subqueries

    In this chapter, you will learn about subqueries in the SELECT, FROM, and WHERE clauses. You will gain an understanding of when subqueries are necessary to construct your dataset and where to best include them in your queries.

    Play Chapter Now
    WHERE are the Subqueries?
    50 xp
    Filtering using scalar subqueries
    100 xp
    Filtering using a subquery with a list
    100 xp
    Filtering with more complex subquery conditions
    100 xp
    Subqueries in FROM
    50 xp
    Joining Subqueries in FROM
    100 xp
    Building on Subqueries in FROM
    100 xp
    Subqueries in SELECT
    50 xp
    Add a subquery to the SELECT clause
    100 xp
    Subqueries in Select for Calculations
    100 xp
    Subqueries everywhere! And best practices!
    50 xp
    ALL the subqueries EVERYWHERE
    100 xp
    Add a subquery in FROM
    100 xp
    Add a subquery in SELECT
    100 xp
  3. 3

    Correlated Queries, Nested Queries, and Common Table Expressions

    In this chapter, you will learn how to use nested and correlated subqueries to extract more complex data from a relational database. You will also learn about common table expressions and how to best construct queries using multiple common table expressions.

    Play Chapter Now
    Correlated subqueries
    50 xp
    Basic Correlated Subqueries
    100 xp
    Correlated subquery with multiple conditions
    100 xp
    Nested subqueries
    50 xp
    Nested simple subqueries
    100 xp
    Nest a subquery in FROM
    100 xp
    Common Table Expressions
    50 xp
    Clean up with CTEs
    100 xp
    Organizing with CTEs
    100 xp
    CTEs with nested subqueries
    100 xp
    Deciding on techniques to use
    50 xp
    Get team names with a subquery
    100 xp
    Get team names with correlated subqueries
    100 xp
    Get team names with CTEs
    100 xp
    Which technique to use?
    50 xp
  4. 4

    Window Functions

    You will learn about window functions and how to pass aggregate functions along a dataset. You will also learn how to calculate running totals and partitioned averages.

    Play Chapter Now
    It's OVER
    50 xp
    The match is OVER
    100 xp
    What's OVER here?
    100 xp
    Flip OVER your results
    100 xp
    OVER with a PARTITION
    50 xp
    PARTITION BY a column
    100 xp
    PARTITION BY multiple columns
    100 xp
    Sliding windows
    50 xp
    Slide to the left
    100 xp
    Slide to the right
    100 xp
    Bringing it all together
    50 xp
    Setting up the home team CTE
    100 xp
    Setting up the away team CTE
    100 xp
    Putting the CTEs together
    100 xp
    Add a window function
    100 xp
For Business

Training 2 or more people?

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

In the following Tracks

Certification Available

SQL Fundamentals

Go To Track
Certification Available

Associate Data Analyst in SQL

Go To Track

collaborators

Collaborator's avatar
Sumedh Panchadhar
Collaborator's avatar
Hillary Green-Lerman

prerequisites

Joining Data in SQL
Mona Khalil HeadshotMona Khalil

Data Scientist, Greenhouse Software

See More

Don’t just take our word for it

*4.4
from 190 reviews
71%
13%
12%
3%
1%
Sort by
  • Tatiana U.
    16 days

    It's a little bit tricky for me because by the time I learned this course, I haven't been studying other course with similar material. So, I can't compare and evaluate correctly. I suppose. Maybe, one day I can say "no, this course is not good", but now I know only this course, so this course is the best for me.

  • Chau B.
    27 days

    Great contents. Clear instruction!

  • Rick H.
    27 days

    Thorough and well-explained. It helped me understand advanced (and important) SQL query functions. The coding practice portions are so helpful.

  • Cei Y.
    about 2 months

    Clear succinct explanations. Topic coverage was at the right level of depth. Exercises tested knowledge at the right level of complexity. The presenter had excellent communication skills and easy-to-understand delivery. Highly recommended.

  • Lilian W.
    2 months

    It was a well-engaging course.

"It's a little bit tricky for me because by the time I learned this course, I haven't been studying other course with similar material. So, I can't compare and evaluate correctly. I suppose. Maybe, one day I can say "no, this course is not good", but now I know only this course, so this course is the best for me."

Tatiana U.

"Great contents. Clear instruction!"

Chau B.

"Thorough and well-explained. It helped me understand advanced (and important) SQL query functions. The coding practice portions are so helpful."

Rick H.

FAQs

Join over 15 million learners and start Data Manipulation in 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.