Take your SQL skills - and your career - to the next level
InstructorTravis CuzickThe curriculum provides significant coverage of programmatic SQL, including variables, control flow with IF statements, and the creation of stored procedures and table-valued functions.
Instruction follows a pattern of video lectures followed by dedicated article-based exercises to reinforce specific analytical techniques like window functions and subqueries.
Editorial course preview
These 2 complementary views highlight concrete, legible examples from the course presentation.
This slide outlines the advanced SQL programming curriculum, covering essential topics such as window functions, subqueries, query optimization techniques, and stored procedures.
This course outline slide details advanced SQL programming topics including window functions, subqueries, query optimization, stored procedures, and procedural techniques like variables.
The environment setup focuses on SQL Server 2019; although the course was updated in June 2026, this update does not guarantee that the setup has been modernized for more recent versions like SSMS 2022. One signal from a pre-update review suggests a potential mismatch for those using newer software.
One signal from a pre-update review suggests that the provided exercises may lack the difficulty required to fully test advanced command mastery.
The curriculum aligns with the goal of moving from basic to advanced SQL for analysts and data scientists.
