The Advanced SQL Server Masterclass For Data Analysis

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

What you’ll 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

A working knowledge of SQL fundamentals – including SELECT statements, applying criteria, table joins, and aggregate queries – is necessary for success in this course
Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup
Access to a Windows operating system (SQL Server only runs on Windows)
Specific knowledge of SQL Server is helpful, but not required

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