Mastering Advanced SQL

Are you comfortable writing basic SQL queries but want to take your SQL skills to the next level?

This course is designed for students who already understand the fundamentals of SQL and want to learn the advanced concepts that are commonly used by data analysts, data scientists, business intelligence developers and SQL developers in real world projects.

Instead of spending hours learning rarely used features this course focuses on the techniques that professionals use every day to write efficient readable and powerful SQL queries.

Throughout the course you will learn advanced querying techniques using practical examples and hands on demonstrations in Microsoft SQL Server.

You will learn how SQL actually processes a query and understand some of the most common mistakes developers make. You will explore conditional logic using CASE expressions and learn how to write scalar subqueries correlated subqueries and Common Table Expressions to simplify complex SQL problems.

The course also includes an in-depth section on window functions where you will learn ranking functions aggregate window functions window frames LAG LEAD FIRST VALUE LAST VALUE NTILE and PERCENT RANK through easy-to-understand examples.

Finally, you will apply everything you have learned by working on a real-world SQL capstone project where you will import data clean it explore the dataset and answer business questions using advanced SQL techniques.