Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL for Data Science & Data Analytics
Course Introduction & Setup
Welcome to SQL For Data Science & Analytics! (2:56)
Join The SQL For Data Science & Analytics Slack Community!
Share Your Journey
What Is SQL And How Does It Work? (11:16)
3 Ways To Code SQL On The Course! (1:25)
Getting Setup With SQL Workbench/J - Check Your Java Version (4:54)
Getting Setup With SQL Workbench/J - Installation (14:12)
Getting Setup With SQL Workbench/J - Take A Look Around (7:35)
The DSI In-Browser SQL Editor (4:47)
The Journey Into Data Science & Analytics
SQL for Data Science & Analytics
The SELECT statement (PRACTICAL) (9:55)
The SELECT Statement (Test Yourself)
Applying selection conditions using the WHERE statement (PRACTICAL) (8:52)
The WHERE Statement (Test Yourself)
Aggregation functions and the GROUP BY statement (PRACTICAL) (10:08)
Aggregation functions and the GROUP BY statement (Test Yourself)
Conditional rules using CASE WHEN (PRACTICAL) (9:17)
Conditional rules using CASE WHEN (Test Yourself)
The use of WINDOW functions (PRACTICAL) (12:29)
The use of WINDOW functions (Test Yourself)
Joining tables using JOIN (PRACTICAL) (19:52)
Joining tables using JOIN (Test Yourself)
Stacking data using UNION and UNION ALL (PRACTICAL) (4:48)
Executing multiple queries using TEMP TABLES and CTE (10:08)
Executing multiple queries using TEMP TABLES and CTE (Test Yourself)
Bonus SQL Tips & Tricks!
Tips & Tricks 01 - Sub-Queries (Practical) (4:30)
Tips & Tricks 02 - Using Lag & Lead (Practical) (7:01)
Tips & Tricks 03 - Rounding Numeric Data (Practical) (2:10)
Tips & Tricks 04 - Selecting Random Samples (Practical) (1:50)
Tips & Tricks 05 - Working With Dates (Practical) (3:32)
Tips & Tricks 06 - Working with Text (Practical) (4:48)
Test Yourself With 3x Real World SQL Tests!
Introduction To The Real-World SQL Tests (1:45)
Real World SQL Test 01 - Questions
Real World SQL Test 01 - Video Solutions (13:47)
Real World SQL Test 02 - Questions
Real World SQL Test 02 - Video Solutions (15:53)
Real World SQL Test 03 - Questions
Real World SQL Test 03 - Video Solutions (16:24)
Bonus Challenges From Your Favourite SQL Content Creators [Coming Soon]
Content Creator SQL Challenge 01: Dave Langer
Content Creator SQL Challenge 02: Chris Perry
Content Creator SQL Challenge 03: [Coming Soon]
Content Creator SQL Challenge 04: [Coming Soon]
Content Creator SQL Challenge 05: [Coming Soon]
Content Creator SQL Challenge 06: [Coming Soon]
Content Creator SQL Challenge 07: [Coming Soon]
Content Creator SQL Challenge 08: [Coming Soon]
Content Creator SQL Challenge 09: [Coming Soon]
Content Creator SQL Challenge 10: [Coming Soon]
Downloadable Learning Resources
The only SQL Joins Cheatsheet you'll ever need (image)
Downloadable PDF: 10 Common SQL Theory Questions (With Answers)
Downloadable PDF: What To Expect In SQL Tests
Downloadable PDF: Order Of Execution
Final Notes & Certificate
Where To From Here?
Get Your Certificate + Share Your New Skills!
Real World SQL Test 03 - Video Solutions
Complete and Continue