The Advanced SQL Server Masterclass For Data Analysis

Take your SQL skills - and your career - to the next level

Created by: Travis Cuzick
Data Solutions Engineer

What Will I Learn?

• Installing SQL Server and SQL Server Management Studio
• Window Functions
• Correlated Subqueries
• Advanced filtering with EXISTS and NOT EXISTS
• Flattening data with PIVOT
• Generating data series with Recursive CTEs
• Leveraging CTEs and temporary tables to break complex processes into manageable steps
• Defining and manipulating tables with DDL and DML commands
• Designing lookup tables to simplify redundant analysis
• SQL optimization techniques, including indexes
• Procedural programming techniques like variables and IF statements
• Defining your own SQL functions
• Creating stored procedures for flexible, repeatable analysis
• Supercharge your SQL knowledge with procedural programming techniques like variables and IF statements
• Writing code that writes code, with Dynamic SQL

Requirements

• Access to a Windows 10 operating system (SQL Server only runs on Windows); there are known compatibility issues between Windows 11 and SQL Server 2019, so I STRONGLY recommend Windows 10 for this course. If you only have access to a Windows 11 machine, you can install SQL Server 2022 instead.
• Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup.
• A working knowledge of SQL fundamentals - including SELECT statements, applying criteria, table joins, and aggregate queries - is necessary for success in this course.
• Specific knowledge of SQL Server is helpful, but not required.

Target audience

• Data Analysts or BI Professionals wanting to “make the leap” to Senior Analyst/Developer
• Data Scientists who aspire to stand out from their peers by going beyond the basics in SQL
• Job seekers who want to turbocharge their resumes with advanced SQL skills
• Students seeking a comprehensive but practical pathway to SQL mastery
• Anyone who wants to take their SQL data analysis skills to the next level