Introduction and Getting Started
  • Course Introduction
  • What if I'm on Mac?
  • Downloading Microsoft SQL Server
  • Installing Microsoft SQL Server
  • Installing AdventureWorks Database
  • Connecting to a Remote Adventureworks Database
Level 1 Introduction to SQL
  • Before We Begin
  • A Quick Introduction to SQL Server Management Studio
  • Let's write some SQL!
  • Using the ORDER BY Clause
  • Grouping and Aggregating Data
  • Using JOIN to return data from 2 or more tables
  • Using UNION to return data from 2 or more tables
Level 2 - Sub-queries, Views and Modifying Data
  • Sub-queries
  • Conditional Processing using CASE
  • Pivoting Data
  • Using VIEWs
  • Modifying Data - the INSERT statement
  • Modifying Data - the UPDATE statement
  • Modifying Data - the DELETE statement
Level 3 - Stored Procedures, Functions, Triggers and Cursors
  • Stored Procedures
  • Functions
  • Triggers
  • Cursors
Course Wrap-Up
  • What we Covered
Bonus Section
  • Bonus 1 - Dynamic SQL
  • Bonus Lecture 2 - Using PIVOT
  • Bonus Lecture 3 - Using PIVOT with dynamic SQL
  • Additional Video for Remotely Connecting.