Advanced SQL & Database Engineering

Master window functions, recursive CTEs, query tuning, partitioning, stored procedures, JSON operations, and database security at scale.

Advanced5 Weeks10 LessonsNuniversity
Start

Course Content

  1. 01ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE()
  2. 02LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), NTH_VALUE()
  3. 03PIVOT, UNPIVOT, and Crosstab Queries
  4. 04Recursive CTEs
  5. 05Advanced Query Tuning
  6. 06Table Partitioning and Sharding
  7. 07Stored Procedures and Triggers
  8. 08JSON and JSONB Operations
  9. 09User Roles, Permissions, and Security
  10. 10Backup, Recovery, and High Availability

Lessons: 10 · 5 Weeks