Advanced SQL Tutorial Introduction

We are going to go deeper into the SQL abyss in the advanced SQL tutorial, and start to cover material that typical SQL tutorials don't teach.

We'll cover higher-level concepts such as:

• how to write clean, maintainable SQL
• what's happening inside a database when a SQL query runs
• how to pivot & unpivot data in SQL (similar to Excel)

Most importantly, we'll put it all together to solve a real Instacart SQL Data Analytics case study, where we'll write long SQL queries to solve an open-ended business problem.

So without further ado, the first lesson in the advanced SQL tutorial: CTEs vs. Subqueries.