T-SQL in 30 Days

Track contents

1. 01 · Before you start
   1. Course guide25 min
   2. Day 0: One-time setup1 hr 15 min
2. 02 · Week 1: Advanced querying foundations
   1. Day 1: Advanced SELECT & filtering2 hrs 45 min
   2. Day 2: Aggregate functions & GROUP BY2 hrs 30 min
   3. Day 3: Subqueries & derived tables2 hrs 30 min
   4. Day 4: Common table expressions2 hrs 30 min
   5. Day 5: Window functions, part 12 hrs 30 min
   6. Day 6: Window functions, part 22 hrs 45 min
   7. Day 7: Week 1 review & integration2 hrs 30 min
3. 03 · Week 2: Joins, set operations and advanced retrieval
   1. Day 8: Advanced JOIN techniques2 hrs 45 min
   2. Day 9: Set operations2 hrs 15 min
   3. Day 10: APPLY operator2 hrs 30 min
   4. Day 11: PIVOT & UNPIVOT2 hrs 45 min
   5. Day 12: Temporal tables & time-based queries3 hrs
   6. Day 13: String functions & pattern matching2 hrs 30 min
   7. Day 14: Week 2 review & complex queries2 hrs 30 min
4. 04 · Week 3: Data modification and programmability
   1. Day 15: Advanced INSERT, UPDATE, DELETE2 hrs 45 min
   2. Day 16: Transactions & concurrency3 hrs
   3. Day 17: Stored procedures2 hrs 45 min
   4. Day 18: User-defined functions2 hrs 30 min
   5. Day 19: Triggers2 hrs 30 min
   6. Day 20: Error handling & debugging2 hrs 30 min
   7. Day 21: Week 3 review & integration3 hrs
5. 05 · Week 4: Performance and expert topics
   1. Day 22: Query execution plans3 hrs
   2. Day 23: Indexing strategies3 hrs
   3. Day 24: Query optimisation techniques3 hrs
   4. Day 25: Partitioning2 hrs 45 min
   5. Day 26: Advanced T-SQL features2 hrs 30 min
   6. Day 27: JSON & XML in T-SQL2 hrs 45 min
   7. Day 28: Dynamic SQL & metaprogramming2 hrs 45 min
   8. Day 29: Real-world scenarios, part 13 hrs
   9. Day 30: Real-world scenarios, part 2 & final assessment3 hrs