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