Skip to main content
HomeSQLData Manipulation in SQL

Data Manipulation in SQL

4.4+
166 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 Exercises
218,628 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

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

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

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

Associate Data Analyst in SQL

Go To Track

Collaborators

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

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 166 reviews
70%
13%
12%
4%
1%
Sort by
  • Hector S.
    5 days

    I really enjoyed how Mona took us step by step from CASE WHEN statement all the way to CTEs and running totals/averages.

  • Muhammad A.
    13 days

    This is a good course for improving SQL skills. I can clearly see that DataCamp's quality is improving consistently. I would like to suggest that DataCamp should introduce some advancd level couses for the advanced learners to sharp the skills to make suitable to the job market.

  • Olamide I.
    14 days

    Very explanatory.

  • Adnan J.
    25 days

    Its fantastic. However , I would like you guys to have a look at Udacity website. Their presentation is a lot better . I feel data Camp is little too verbose while explaining the lectures. I like the Udacity's presentation better. Having said that I am also a fan of Data Camp.

  • Lucas N.
    about 2 months

    Nice course to do some important queries.

"I really enjoyed how Mona took us step by step from CASE WHEN statement all the way to CTEs and running totals/averages."

Hector S.

"This is a good course for improving SQL skills. I can clearly see that DataCamp's quality is improving consistently. I would like to suggest that DataCamp should introduce some advancd level couses for the advanced learners to sharp the skills to make suitable to the job market."

Muhammad A.

"Very explanatory."

Olamide I.

FAQs

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