Advanced SQL
29 lessons on subqueries, result sets, CTEs, window functions and an original reporting project. Practice on a consistent retail dataset in SQLite. SQL Server syntax is explicitly identified as a comparison, with runnable alternatives rather than a claim that the lab supports T-SQL. Also covers views, indexes and validated staging in the lab, with reference-only SQL Server permissions.