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
Let's Take A Look At Our Data! (10:46)
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)
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!
Bonus Weekly Challenges (Keep Your SQL Skills Sharp!)
Weekly SQL Challenge 01
Weekly SQL Challenge 02
Weekly SQL Challenge 03
Weekly SQL Challenge 04 (From Dave Langer)
Weekly SQL Challenge 05
Weekly SQL Challenge 06
Weekly SQL Challenge 07 (From Chris Perry)
Weekly SQL Challenge 08
Weekly SQL Challenge 09
Weekly SQL Challenge 10
Weekly SQL Challenge 11
Weekly SQL Challenge 12
Let's Take A Look At Our Data!
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock