Skip to main content
HomeSQL

course

Data Manipulation in SQL

Beginner
4.4+
203 reviews
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

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.

Prerequisites

Joining Data in SQL
1

We'll take the CASE

Start Chapter
2

Short and Simple Subqueries

Start Chapter
3

Correlated Queries, Nested Queries, and Common Table Expressions

Start Chapter
4

Window Functions

Start Chapter
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

Enroll now

Don’t just take our word for it

*4.4
from 203 reviews
70%
14%
12%
3%
1%
  • 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

GoogleLinkedInFacebook

or

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