Introduction and Setup
  • Lecture 1: Introduction to Databases
  • Installing / Setting up Environment / SQL Management Studio
Introduction to Querying
  • Creating your First SQL Table
  • Installing Sample Database (Adventure Works) and Querying
Deep Dive into Querying
  • Lets Start Writing some SQL code
  • Deep Dive into SQL Querying
SQL Joins
  • SQL Joins (1/2)
  • SQL Joins (2/2)
Dates / Aggregation and String Functions
  • TSQL Date Functions
  • TSQL Aggregation and String Functions
  • Lecture 11: Conclusion