Welcome
- Introduction
Getting Started With This Course
- Introduction
- Getting Started: MS SQL Server 2016 - Transact-SQL
- Getting Started: The Certifications
- Getting Started: Microsoft SQL Server Examples
Learn About Databases
- Introduction
- Learning SQL Server Databases - Database Structure & Purpose
- Learning SQL Server Databases - Database Terminology
- Learning SQL Server Databases - Data Types
- Learning SQL Server Databases - Statement Types
Learn About MS SQL Server 2016
- Introduction
- MS SQL Server 2016: Learn About Microsoft SQL Server 2016
- 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: Microsoft SQL Server 2016 - Attaching The Sample Database
Microsoft SQL Server 2016 - Basic Select Statements
- Introduction
- Select Statements - Using The Where Clause
- Select Statements - Column Aliasing
- Select Statements - Using Distinct
- Select Statements - Ordering Results
- Select Statements - T-SQL Concatenation
- Select Statements - Multipart Naming
Microsoft SQL Server 2016 - Advanced Select Statements
- Introduction
- Select Statements - Union
- Select Statements - Intersect and Except
- Select Statements - Paging Results
- Select Statements - Understanding Case Expressions - 1
- Select Statements - Understanding Case Expressions - 2
- Select Statements - Using Pivot - 1
- Select Statements - Using Pivot - 2
Microsoft SQL Server 2016 - Querying Multiple Tables
- Introduction
- SQL Server 2016 - Table Relationships
- SQL Server 2016 - Using The Join Statement
- SQL Server 2016 - Table Aliasing
- SQL Server 2016 - Join Types
- SQL Server 2016 - Join Types Examples
Microsoft SQL Server 2016 - Grouping Data
- Introduction
- Grouping Data - Understanding Group By
- Grouping Data - Understanding Having
- Grouping Data - Understanding Grouping Sets
- Grouping Data - The Graphical Query Tool
Microsoft SQL Server 2016 - Modifying Data
- Introduction
- Modifying - Insert Demo
- Modifying - Insert Select
- Modifying - Select Into
- Modifying - Updating Data
- Modifying - Update Demo
- Modifying - Deleting Data
- Modifying - Delete Demo
Microsoft SQL Server 2016 - Programming Objects Using T-SQL
- Introduction
- Programming Objects - Stored Procedure Demo
- Programming Objects - Using Input Parameters
- Programming Objects - Using Output Parameters
- Programming Objects - Understanding Table Variables
- Programming Objects - Understanding CTEs - 1
- Programming Objects - Understanding CTEs - 2
- Programming Objects - Understanding Masking
- Programming Objects - Masking Demo
Microsoft SQL Server 2016 - User-Defined Functions
- Introduction
- SQL Server 2016 - Scalar Functions
- SQL Server 2016 - Table-Valued Functions
Learn and Understand Subqueries
- Introduction
- SQL Server Subqueries - Scalar Subqueries
- SQL Server Subqueries - Multi-Valued Subqueries
- SQL Server Subqueries - Correlated Subqueries
Course Summary
- Summary
Course Material & Source Code
- Course Material & Source Code
- AdventureWorks2012 Database
- Thank You
