Skip to main content

course

Data Manipulation in SQL

Beginner

4.4+

Updated 01/2025

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

Included withPremium or Teams

SQLData Manipulation4 hours15 videos55 exercises4,700 XP251,953Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

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

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.

Prerequisites

Joining Data in SQL

1

We'll take the CASE

We'll take the CASE

Basic CASE statements

CASE statements comparing column values

CASE statements comparing two column values part 2

In CASE things get more complex

In CASE of rivalry

Filtering your CASE statement

CASE WHEN with aggregate functions

COUNT using CASE WHEN

COUNT and CASE WHEN with multiple conditions

Calculating percent with CASE and AVG

2

Short and Simple Subqueries

WHERE are the Subqueries?

Filtering using scalar subqueries

Filtering using a subquery with a list

Filtering with more complex subquery conditions

Subqueries in FROM

Joining Subqueries in FROM

Building on Subqueries in FROM

Subqueries in SELECT

Add a subquery to the SELECT clause

Subqueries in Select for Calculations

Subqueries everywhere! And best practices!

ALL the subqueries EVERYWHERE

Add a subquery in FROM

Add a subquery in SELECT

3

Correlated Queries, Nested Queries, and Common Table Expressions

Correlated subqueries

Basic Correlated Subqueries

Correlated subquery with multiple conditions

Nested subqueries

Nested simple subqueries

Nest a subquery in FROM

Common Table Expressions

Clean up with CTEs

Organizing with CTEs

CTEs with nested subqueries

Deciding on techniques to use

Get team names with a subquery

Get team names with correlated subqueries

Get team names with CTEs

Which technique to use?

4

Window Functions

The match is OVER

What's OVER here?

Flip OVER your results

OVER with a PARTITION

PARTITION BY a column

PARTITION BY multiple columns

Sliding windows

Slide to the left

Slide to the right

Bringing it all together

Setting up the home team CTE

Setting up the away team CTE

Putting the CTEs together

Add a window function

Data Manipulation in SQL

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.4

from 203 reviews

70%

14%

12%

3%

1%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Ronaldo B.

9 days

Thank you

Jackie R.

25 days

If you don't code daily and have a strong mastery of basic syntax, you're going to have a hard time. Thank goodness for XP, lol! I needed a lot of hints, but keep in mind that I only have to code about once every few weeks, and even then I don't have to start from scratch. ;) Also, I use SSMS which is just different enough for an infrequent coder to make ridiculous errors. Really good course though and I'd probably take it again if my job responsibilities increased to the point where I needed the knowledge in regular practice.

Camilo R.

about 1 month

Excelente

Aneury M.

about 1 month

Good chapter, I really learned a lot.

Ashwani S.

about 1 month

the course has great content

"Thank you"

Ronaldo B.

"Excelente"

Camilo R.

"Good chapter, I really learned a lot."

Aneury M.

FAQs

Join over 15 million learners and start Data Manipulation in SQL today!

Create Your Free Account

Google LinkedIn Facebook

or

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