Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Atlas CopCo - Decode 2.0 - SQL
Class Recordings
Session 01: 13 May 2024 (Introduction to SQL) (63:47)
Session 02: 14 May 2024 (Excel Case Study Assessment) (81:01)
Session 03: 15 May 2024 (Connect Excel to Cloud Database Server and Query Data) (74:27)
Session 04: 16 May 2024 (Crud Operation) (63:24)
Session 05: 17 May 2024 (CRUD Operation) (68:27)
Session 06: 18 May 2024 (CRUI & DDL Statements) (130:18)
Session 07: 20 May 2024 (Math Operators) (69:37)
Session 08: 21 May 2024 (Practice Session) (63:06)
Session 09: 22 May 2024 (Date Function) (69:38)
Session 10: 23 May 2024 (Aggregate Function, Group by clause) (59:00)
Session 11: 24 May 2024 (Limits) (62:22)
Session 12: 27 May 2024 (Joining Multiple Tables, Left Anti-Joins) (61:27)
Session 13: 28 May 2024 (75:22)
Session 14: 16 Sept 2024 - Adv SQL (69:05)
Session 15: 17 Sept 2024 - Adv SQL (77:36)
Session 16: 18 Sept 2024 - Adv SQL (40:20)
Class Files
Session 07: 20 May 2024
Session 12: 27 May 2024
Session 15: 17 Sept 2024 (All Joins - SupplyChainDb - Exercise File
Session 17: 19 Sept 2024 - Adv SQL
Case Study
Case Study 1 - Zomato
Case Study 1 - Zomato - Solution
Assessments
Weekly Quiz: Basics of SQL
Weekly Quiz: Date Function and Aggregate Function
Data Set
Data Import Wizard_ Supply Chain DB
Assignments
SQL Assignment - 1
SQL Assignment - 2 - 22 May 2024
SQL Assignment - 3 - 25 May 2024
SQL Assignment - 4 - 27 May 2024
Notes
SQL Basics
Operators and Functions
Joins
Outer Join - Notes and Scripts
Union and Union All | Full Outer Joins
Database Normalization Refresher
Final Assessment
Final Assessment
Session 12: 27 May 2024 (Joining Multiple Tables, Left Anti-Joins)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock