The Advanced SQL Server Masterclass For Data Analysis
Take your SQL skills - and your career - to the next level
4.64 (5116 reviews)
53,540
students
8 hours
content
Feb 2025
last update
$99.99
regular price
What you will 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
Screenshots
Related Topics
4069268
udemy ID
5/22/2021
course created date
5/31/2021
course indexed date
Bot
course submited by