Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.

Table Transformation

While working with databases, we often need to transform data from one format to achieve a desired result. In SQL, this is often called data transformation or table transformation.

We'll begin learning about table transformation through subqueries. Subqueries, sometimes referred to as inner queries or nested queries, are used to transform table data by nesting one query within another query.

In this lesson, we'll look at aviation data and transform it with SQL using subqueries. If you're new to SQL, we recommend you do this course first.

Report a Bug
If you see a bug or any other issue with this page, please report it here.