- Installation & Setup Pro
- Where to Write SQL Code Pro
- Installing MySQL (Mac) Pro
- Installing MySQL Workbench (Mac) Pro
- Installing MySQL (PC) Pro
- Installing MySQL Workbench (PC) Pro
- Getting Started with MySQL Workbench Pro
- Loading Data for This Course Pro
- DEMO: Loading Data in MySQL Pro
- DEMO: Loading Data in Other RDBMSs Pro
- Section Introduction Pro
- Working with Multiple Tables Pro
- Basic Joins Pro
- Basic Join Types Pro
- ASSIGNMENT: Basic Joins Pro
- SOLUTION: Basic Joins Pro
- Joining on Multiple Columns Pro
- Joining Multiple Tables Pro
- Self Joins Pro
- ASSIGNMENT: Self Joins Pro
- SOLUTION: Self Joins Pro
- Cross Joins Pro
- UNION vs UNION ALL Pro
- Key Takeaways Pro
- QUIZ: Multi-Table Analysis Pro
- Section Introduction Pro
- Subquery Basics Pro
- Subqueries in the SELECT Clause Pro
- ASSIGNMENT: Subqueries in the SELECT Clause Pro
- SOLUTION: Subqueries in the SELECT Clause Pro
- Subqueries in the FROM Clause Pro
- Multiple Subqueries Pro
- ASSIGNMENT: Subqueries in the FROM Clause Pro
- SOLUTION: Subqueries in the FROM Clause Pro
- Subqueries in the WHERE & HAVING Clauses Pro
- ANY vs ALL Pro
- EXISTS and Correlated Subqueries Pro
- ASSIGNMENT: Subqueries in the WHERE Clause Pro
- SOLUTION: Subqueries in the WHERE Clause Pro
- Common Table Expressions Pro
- Subqueries vs CTEs Pro
- Referencing a CTE Multiple Times Pro
- ASSIGNMENT: CTEs Pro
- SOLUTION: CTEs Pro
- Multiple CTEs Pro
- ASSIGNMENT: Multiple CTEs Pro
- SOLUTION: Multiple CTEs Pro
- Recursive CTEs Pro
- Subqueries vs CTEs vs Temp Tables vs Views Pro
- Key Takeaways Pro
- QUIZ: Subqueries & CTEs Pro
- Section Introduction Pro
- Window Function Basics Pro
- Breaking Down a Window Function Pro
- ASSIGNMENT: Window Functions Pro
- SOLUTION: Window Functions Pro
- Functions for Window Functions Pro
- ROW_NUMBER, RANK & DENSE_RANK Pro
- ASSIGNMENT: Row Numbering Pro
- SOLUTION: Row Numbering Pro
- FIRST_VALUE, LAST_VALUE & NTH_VALUE Pro
- ASSIGNMENT: Value Within a Window Pro
- SOLUTION: Value Within a Window Pro
- LEAD & LAG Pro
- ASSIGNMENT: Value Relative to a Row Pro
- SOLUTION: Value Relative to a Row Pro
- NTILE Pro
- ASSIGNMENT: Statistical Functions Pro
- SOLUTION: Statistical Functions Pro
- PREVIEW: Moving Average Calculations Pro
- Key Takeaways Pro
- QUIZ: Window Functions Pro
- Section Introduction Pro
- Function Basics Pro
- Numeric Functions Pro
- CAST & CONVERT Pro
- ASSIGNMENT: Numeric Functions Pro
- SOLUTION: Numeric Functions Pro
- DateTime Functions Pro
- ASSIGNMENT: DateTime Functions Pro
- SOLUTION: DateTime Functions Pro
- String Functions Pro
- ASSIGNMENT: String Functions Pro
- SOLUTION: String Functions Pro
- Pattern Matching Pro
- DEMO: Pattern Matching Pro
- ASSIGNMENT: Pattern Matching Pro
- SOLUTION: Pattern Matching Pro
- NULL Functions Pro
- ASSIGNMENT: NULL Functions Pro
- SOLUTION: NULL Functions Pro
- Key Takeaways Pro
- QUIZ: Functions By Data Type Pro
- Section Introduction Pro
- Duplicate Values Pro
- ASSIGNMENT: Duplicate Values Pro
- SOLUTION: Duplicate Values Pro
- Min / Max Value Filtering Pro
- ASSIGNMENT: Min / Max Value Filtering Pro
- SOLUTION: Min / Max Value Filtering Pro
- Pivoting Pro
- ASSIGNMENT: Pivoting Pro
- SOLUTION: Pivoting Pro
- Rolling Calculations Pro
- DEMO: Rolling Calculations Pro
- ASSIGNMENT: Rolling Calculations Pro
- SOLUTION: Rolling Calculations Pro
- DEMO: Imputing NULL Values Pro
- Key Takeaways Pro
- QUIZ: Data Analysis Applications Pro
- Final Project Overview Pro
- ASSIGNMENT: School Analysis Pro
- SOLUTION: School Analysis Pro
- ASSIGNMENT: Salary Analysis Pro
- SOLUTION: Salary Analysis Pro
- ASSIGNMENT: Player Career Analysis Pro
- SOLUTION: Player Career Analysis Pro
- ASSIGNMENT: Player Comparison Analysis Pro
- SOLUTION: Player Comparison Analysis Pro
- ASSIGNMENT: Upload the Project to Showcase Pro