After completing the course, you will…
-
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
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
Deal Score+1
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.