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
- Requirements
- 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
Who this course is for:
- 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