Accelerated SQL Server 2016 Basics
The fastest, most gentle introduction you'll find on SQL Server 2016.
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