Course curriculum

  • 1
    Course Content
    • Download Code for Course
    • Lesson 1 - Course Introduction
    • Lesson 2 - Installing SQL Server 2016 Express Edition
    • Lesson 3 - Creating and Connecting to an Azure SQL Server and Database
    • Lesson 4 - Quick Tour of SQL Server Management Studio
    • Lesson 5 - Creating a Database
    • Lesson 6 - Creating a Table and Columns
    • Lesson 7 - Quick Introduction to Data Types
    • Lesson 8 - Understanding Rows and Primary Key Constraints
    • Lesson 9 - Inserting Row Data into Tables
    • Lesson 10 - Creating Related Tables with Foreign Key Constraints
    • Lesson 11 - Editing Tables and Rows Using SSMS Tools
    • Lesson 12 - Challenge: Creating the Other Tables, Columns and Rows
    • Lesson 13 - Solution: Creating the Other Tables, Columns and Rows
    • Lesson 14 - Working with Database Scripts
    • Lesson 15 - Filtering with the WHERE Clause
    • Lesson 16 - Challenge: Selecting with the WHERE Clause
    • Lesson 17 - Solution: Selecting with the WHERE Clause
    • Lesson 18 - Updating and Deleting Rows
    • Lesson 19 - Deleting Tables and Databases
    • Lesson 20 - Selecting from Multiple Tables with an INNER JOIN
    • Lesson 21 - Using Column and Table Aliases
    • Lesson 22 - Ordering Rows
    • Lesson 23 - Creating a Database Diagram
    • Lesson 24 - Challenge: Papa Bob's Pizza Database
    • Lesson 25 - Solution: Papa Bob's Pizza Database
    • Lesson 26 - Where to Go From Here