SQL for Data Analysis: Intermediate

Course Description

Take your SQL skills to the next level by learning advanced query techniques, reusable objects, and performance optimization. In this course, you’ll learn Subqueries & Derived Tables (Simple subqueries in WHERE, Correlated subqueries, Derived tables, EXISTS vs IN), Views (Creating and using views, Updating data through views, Indexed views), Stored Procedures & Functions Creating stored procedures (Parameters in stored procedures, Scalar functions, Table-valued functions), Transactions & Error Handling (BEGIN TRANSACTION, COMMIT, ROLLBACK, TRY…CATCH blocks, Error handling best practices), Performance & Indexing (Understanding indexes, Clustered vs Non-clustered, Execution plans, Indexing best practices), Advanced Joins & Set Operations (Self-joins, UNION, UNION ALL, INTERSECT, EXCEPT, APPLY operator (CROSS APPLY, OUTER APPLY)), CTEs (Common Table Expressions) & Window Functions (Introduction to CTEs, Recursive CTEs, ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD for time-based analysis) 📌 Learning Outcomes: •Build complex queries using subqueries, CTEs, and window functions. •Create and manage views, stored procedures, and user-defined functions. •Implement transactions and handle errors. •Apply indexes to improve query performance. •Understand and use set operations (UNION, INTERSECT, EXCEPT). 🎯Goal: Move beyond querying to designing efficient, reusable, and secure database solutions that support analytics, reporting, and applications. 📂 3 Practical Projects ⏱ Duration: 14 Hours