Foundation
  • Welcome
  • Learning Plan
  • Learning Outline
  • Pre Assessment
  • Vocabulary List
  • Installing SQL Server Developer Edition
  • Installing SQL Server Management Studio
  • Installing Training Database - SQLTrainingOnlineSimpleDB
  • Installing Training Database - AdventureWorks
Module #1: Introduction to Databases
  • Lesson #1: Overview of Databases
  • Lesson #2: SQL – How to Talk to Databases
  • Lesson #3: Client-Server Relationships Part 1
  • Lesson #4: Client-Server Relationships Part 2
Module #2: Management Studio
  • Lesson #5: Introduction Management Studio Part 1
  • Lesson #6: Introduction Management Studio Part 2
  • Lesson #7: Database Objects Part 1
  • Lesson #8: Database Objects Part 2
  • Lesson #9: Tables Part 1
  • Lesson #10: Tables Part 2
  • Lesson #11: Creating Stuff Part 1
  • Lesson #12: Creating Stuff Part 2
  • Lesson #13: Creating Stuff with Scripts Part 1
  • Lesson #14: Creating Stuff with Scripts Part 2
Module #3: Writing SQL
  • Lesson #15: CRUD Part 1
  • Lesson #16: CRUD Part 2
  • Lesson #17: Beginning Select Statements
  • Lesson #18: Where Clause Part 1
  • Lesson #19: Where Clause Part 2
  • Lesson #20: Sorting
  • Lesson #21: Column List Part 1
  • Lesson #22: Column List Part 2
  • Lesson #23: Group By
  • Lesson #24: Having Clause
  • Lesson #25: Joining Part 1
  • Lesson #26: Joining Part 2
Module #4: Advanced Objects
  • Lesson #27: Views Part 1
  • Lesson #28: Views Part 2
  • Lesson #29: Scripting with Variables Part 1
  • Lesson #30: Scripting with Variables Part 2
  • Lesson #31: Stored Procedures Part 1
  • Lesson #32: Stored Procedures Part 2
  • Lesson #33: Functions Part 1
  • Lesson #34: Functions Part 2
Module #5: Advanced Database Concepts
  • Lesson #35: Security Part 1
  • Lesson #36: Security Part 2
  • Lesson #37: Security Part 3
  • Lesson #38: Backups Part 1
  • Lesson #39: Backups Part 2
  • Lesson #40: Indexes Part 1
  • Lesson #41: Indexes Part 2
  • Lesson #42: Indexes Part 3
Bonuses
  • Bonus #1: SQL and SQL Server Reporting Services
  • Bonus #2: SQL and Microsoft Excel
  • Bonus #3: SQL and Power Pivot
  • Bonus #4: SQL and Microsoft Access
  • Bonus #5: SQL Import and Export