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 About SQL Server - Learn and Understand Database Structures
- Learn About SQL Server - 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 Security
- Introduction
- Learning Microsoft SQL Server Level Security
- SQL Server Security: Restarting SQL Server
- SQL Server Security: Creating Logins
- SQL Server Security: Database Level Security
- SQL Server Security: Database User Account Types
- SQL Server Security: Cross Server Authorization
- SQL Server Security: Partially Contained Databases
- SQL Server Security: Dynamic Data Masking
- SQL Server Security: DDM Example - 1
- SQL Server Security: DDM Example - 2
Microsoft SQL Server Roles
- Introduction
- SQL Server Roles: Fixed Server Roles
- SQL Server Roles: Fixed Database Roles
- SQL Server Roles: User-Defined Roles
- SQL Server Roles: Grant, Revoke, And Deny
- SQL Server Roles: Schema Level Permissions
SQL Server - Encryption
- Introduction
- Learn and Understand SQL Server Encryption
- SQL Server Encryption: Dark Side Of Encryption
- SQL Server Encryption: Asymmetric Vs. Symmetric
- SQL Server Encryption: Encryption Options
- SQL Server Encryption: Encrypting Backups - 1
- SQL Server Encryption: Encrypting Backups - 2
- SQL Server Encryption: Transparent Data Encryption
- SQL Server Encryption: Implementing TDE
- SQL Server Encryption: Always Encrypted
- SQL Server Encryption: Implementing Always Encrypted
SQL Server - Index Management
- Introduction
- SQL Server - Learn and Understand Index Management
- Index Management - Identifying Fragmentation
- Index Management - Repairing Fragmentation
- Index Management - Database Engine Tuning Advisor - 1
- Index Management - Database Engine Tuning Advisor - 2
MS SQL Server - Backup & Restore
- Introduction
- MS SQL Server - Backup: Backup Types
- MS SQL Server - Backup: Understanding Recovery Models
- MS SQL Server - Backup: Copy-Only Backups
- MS SQL Server - Backup: Backup Terminology
- MS SQL Server - Backup: System Database Backups
- MS SQL Server - Backup: Transaction Log Basics
- MS SQL Server - Backup: Transaction Log Backups
- MS SQL Server - Backup: Tail-Log Backups
- MS SQL Server - Restore: Restoring Databases
- MS SQL Server - Restore: Restoring With SSMS
- MS SQL Server - Restore: Recovering The Master DB
- MS SQL Server - Restore: Point In Time Recovery
- MS SQL Server - Restore: Understanding Log Shipping
Monitoring Microsoft SQL Server
- Introduction
- Monitoring Microsoft SQL Server: Performance & Monitoring
- Monitoring Microsoft SQL Server: Session Identification
- Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 1
- Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 2
- Monitoring Microsoft SQL Server: Understanding UCPs
- Monitoring Microsoft SQL Server: Data Collector
- Monitoring Microsoft SQL Server: Data Collector Configuration
- Monitoring Microsoft SQL Server: Query Store
- Monitoring Microsoft SQL Server: Understanding Extended Events
- Monitoring Microsoft SQL Server: Creating An Extended Event - 1
- Monitoring Microsoft SQL Server: Creating An Extended Event - 2
- Monitoring Microsoft SQL Server: Editing An Extended Event
Course Summary
- Summary
Course Material & Source Code
- Course Material & Source Code
- Thank You
