Skip to main content

course

Data Manipulation in SQL

Beginner

4.5+

Updated 12/2024

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 for FreePremium or Teams

SQLData Manipulation4 hours15 videos55 exercises4,700 XP247,333Statement 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.5

from 196 reviews

71%

13%

12%

3%

1%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Aneury M.

1 day

Good chapter, I really learned a lot.

Ashwani S.

6 days

the course has great content

Michael K.

9 days

Great course to learn very useful SQL techniques.

BALLA C.

12 days

it was great experience, initially I was having a doubt I catch this up or not in the final outcome i was, all thanks to the designer of the course.

Kabanda D.

26 days

its very and and well explained

"Good chapter, I really learned a lot."

Aneury M.

"the course has great content"

Ashwani S.

"Great course to learn very useful SQL techniques."

Michael K.

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.