Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Codecademy

How to Transform Tables with SQL

via Codecademy

Go to class Write review
Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More → Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
This course lets you get more sophisticated with what you can do with data. Even if you are not doing data analysis yourself, understanding what is possible is essential in today's data-driven world.

Syllabus

  • Subqueries: Use subqueries to transform data tables by nesting one query within a query.
    • Lesson: Subqueries
  • Set Operations: Use set operations to query data from multiple tables.
    • Lesson: Set Operations
  • Conditional Aggregates: Learn about conditional aggregates, a way to use aggregate functions based on a given set of conditions.
    • Lesson: Conditional Aggregates
  • Date, Number, and String Functions: Use built-in date, number, and string functions to transform table data.
    • Lesson: Date, Number, and String Functions

Taught by

Kenny Lin

Reviews

3.9 rating at Codecademy based on 455 ratings

Start your review of How to Transform Tables with SQL

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.