How to Transform Tables with SQL
Offered By: Codecademy
Course Description
Overview
Practice more SQL in this course that covers how to manipulate and transform data.
### 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.
### 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.
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
Related Courses
Excel 2010Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera