Writing Advanced SQL Queries

Lesson
Materials

As part of this section we will understand how to write queries using some of the advanced features.

  • Overview of Views

  • Overview of Sub Queries

  • CTAS - Create Table As Select

  • Advanced DML Operations

  • Merging or Upserting Data

  • Pivoting Rows into Columns

  • Overview of Analytic Functions

  • Analytic Functions – Aggregations

  • Cumulative Aggregations

  • Analytic Functions – Windowing

  • Analytic Functions – Ranking

  • Getting Top 5 Daily Products

  • Exercises - Analytic Functions