SQL for Aspiring Data Scientists (Online Course)

DAY #1 | INTRODUCTION + SETTING UP YOUR SQL ENVIRONMENT 9 Lessons

VAULT #1 | ACCESS TO MY “PRACTICE-SQL” DATA SERVER 1 Lesson

VAULT #2 | MORE FREE DATA36 LEARNING MATERIALS 1 Lesson

VAULT #3 | 20 JOB INTERVIEW-LIKE SQL EXERCISES (FOR JUNIOR DATA POSITIONS) 1 Lesson

DAY #2 | MODULE #2 | Practice data selection! 8 Lessons

DAY #2 | MODULE #2.1 | The SQL WHERE clause with Multiple Filters 16 Lessons

DAY #3 | MODULE #2.2 | The SQL WHERE clause with Multiple Filters and the ORDER BY clause 12 Lessons

DAY #3 | MODULE #3.1 | Practicing SQL Functions (COUNT, SUM, AVG, MIN, MAX) 13 Lessons

DAY #4 | MODULE #3.2 | Practicing SQL Functions (COUNT, SUM, AVG, MIN, MAX) and the GROUP BY clause 17 Lessons

DAY #5 | MODULE #4 | JOIN-ing SQL tables 16 Lessons

DAY #6 | MODULE #5 | SQL Subqueries and the HAVING clause 10 Lessons

DAY #7 | MODULE #6 | Extra Exercises (Case Study) 13 Lessons

VAULT #3 | 20 JOB INTERVIEW-LIKE SQL EXERCISES (FOR JUNIOR DATA POSITIONS) 31 Lessons