Explore advanced SQL concepts through a comprehensive tutorial series covering inner and outer joins, union operators, case statements, having clauses, data manipulation, aliasing, and partition by functions. Gain practical insights into real-world use cases and enhance your database querying skills as you progress beyond basic SQL techniques.
Overview
Syllabus
Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases.
Intermediate SQL Tutorial | Unions | Union Operator.
Intermediate SQL Tutorial | Case Statement | Use Cases.
Intermediate SQL Tutorial | Having Clause.
Intermediate SQL Tutorial | Updating/Deleting Data.
Intermediate SQL Tutorial | Aliasing.
Intermediate SQL Tutorial | Partition By.
Taught by
Alex the Analyst
