SQL: Table Transformation

Practice more SQL in this course that covers how to manipulate and transform data.

Start[missing "en.views.course_landing_page.sql-table-transformation.course_illustration" translation]

Why Learn About Table Transformation With SQL?

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.

Course Outcomes

In this course created in partnership with Looker, you'll learn more about manipulating data stored in relational databases using SQL. You will become familiar with subqueries, set operations, conditional aggregates, and more.

Built in partnership with

partner

What you'll learn

  1. 1

    Subqueries

    Use subqueries to transform data tables by nesting one query within a query.

  2. 2

    Set Operations

    Use set operations to query data from multiple tables.

  3. 3

    Conditional Aggregates

    Learn about conditional aggregates, a way to use aggregate functions based on a given set of conditions.

  4. 4

    Date, Number, and String Functions

    Use built-in date, number, and string functions to transform table data.

  5. View Syllabus
testimonial
I know from first-hand experience that you can go in knowing zero, nothing, and just get a grasp on everything as you go and start building right away.
— Madelyn, Pinterest