Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.
The diagram below shows how data is structured in the Parch & Posey database.
- Basic SQL
- SQL Joins
- SQL Aggregations (In Progress)
- SQL Subqueries & Temporary Tables
- SQL Data Cleaning
- [Advanced] SQL Window Functions
- [Advanced] SQL Advanced JOINs & Performance Tuning
- Congratulations!
- What's Next for NanoDegree