Welcome
- Course Introduction
Getting Started With This Course
- Introduction
- Getting Started - Overview: MS SQL Server
- Getting Started - The Certifications
- Getting Started - Microsoft SQL Server Examples
Learn About SQL Server
- Introduction
- Learn About SQL Server - Learn About Editions
- Learn About SQL Server - SQL Server Databases
- Learn and Understand Database Structures
- Learn About SQL Server - Transact-SQL
Learn About MS SQL Server 2016
- Introduction
- MS SQL Server 2016: Learn How To Install SQL Server 2016
- MS SQL Server 2016: Learn How To Install SQL Server Management Studio
- MS SQL Server 2016: Attaching The Sample Database
- MS SQL Server 2016: Verifying The Installation
Microsoft SQL Server 2016: Table Design & Implementation
- Introduction
- SQL Server 2016: Database Options
- SQL Server 2016: Database Options - Learn and Understand Tables
- SQL Server 2016: SQL Server Data Types
- SQL Server 2016: Choosing A Data Type
- SQL Server 2016: Database Options - Learn about Normalization
- SQL Server 2016: Database Options - Learn and Understand Relationships
- SQL Server 2016: Schemas
- SQL Server 2016: Table Design Basics
- SQL Server 2016: Creating Tables Using T-SQL
- SQL Server 2016: Creating Tables Graphically
- SQL Server - Using Identity Columns - 1
- SQL Server - Using Identity Columns - 2
- SQL Server - Altering Tables - 1
- SQL Server - Altering Tables - 2
SQL Server 2016 - Advanced Table Design
- Introduction
- Table Design: Constraints
- Table Design: Primary and Foreign Keys
- Table Design: Adding Constraints - 1
- Table Design: Adding Constraints - 2
- Table Design: Understanding Filegroups
- Table Design: Table Partitions
- Table Design: Temporal Tables
- Table Design: Working With Temporal Tables - 1
- Table Design: Working With Temporal Tables - 2
- Table Design: In-Memory Tables - 1
- Table Design: In-Memory Tables - 2
- Table Design: Generating Scripts
SQL Server 2016: Indexes
- Introduction
- SQL Server Indexes - Clustered Or Nonclustered - 1
- SQL Server Indexes - Clustered Or Nonclustered - 2
- SQL Server Indexes - Covered Indexes
- SQL Server Indexes - Creating Indexes
- SQL Server Indexes - Columnstore Indexes
- SQL Server Indexes - Managing Indexes
- SQL Server Indexes - Rebuilding and Reorganizing
SQL Server 2016: Views
- Introduction
- SQL Server 2016 - Creating A View
- SQL Server 2016 - Updateable Views
- SQL Server 2016 - Indexed Views
SQL Server 2016: Transactions
- Introduction
- SQL Server 2016 - Understanding Transactions
- SQL Server 2016 - Transaction Log
- SQL Server 2016 - Using Explicit Transactions
- SQL Server 2016 - Savepoints - 1
- SQL Server 2016 - Savepoints - 2
SQL Server 2016: Stored Procedures
- Introduction
- SQL Server 2016 - Creating Stored Procedures
- SQL Server 2016 - Using Input Parameters
- SQL Server 2016 - Using Output Parameters
- SQL Server 2016 - Table-Valued Parameters - 1
- SQL Server 2016 - Table-Valued Parameters - 2
- SQL Server 2016 - Return Status - 1
- SQL Server 2016 - Return Status - 2
- SQL Server 2016 - Natively Compiled Stored Procs
SQL Server 2016: Triggers
- Introduction
- SQL Server 2016 - Instead Of Triggers
- SQL Server 2016 - After Triggers
- SQL Server 2016 - Inserted & Deleted Tables
SQL Server 2016: User-Defined Functions
- Introduction
- SQL Server 2016 - Scalar Functions
- SQL Server 2016 - Table-Valued Functions
Course Summary
- Summary
Course Material & Source Code
- Course Material & Source Code
- Thank You
