SQL Functions

SQL Aggregate functions

SQL Window functions

SQL Joins

SQL Null Values

SQL Datetime Formats

SQL Case Statements

SQL ‘BETWEEN’

SQL ‘REGEX’

SQL Entity Relationships

SQL Temp Tables

SQL Sub-Queries

SQL (CTEs) Common Table Expression

SQL VIEWS

SQL CORRELATED Sub-Queries

SQL LAG: Rolling Calculations

SQL Pivot Tables