70-764 SQL Server 2016 Database Administration (DBA)

Course Curriculum

Chapter 1: The Course Guide Explanation

Lecture 1: Welcome

Lecture 2: Course structure

Chapter 2: Module 0 : Preparing The Enviroment

Lecture 1: Setup The domain

Lecture 2: Installing The SQL Server 2016

Lecture 3: Recourse Needed

Chapter 3: Module 1 : SQL Server Security

Lecture 1: Lesson 1 : Authenticating Connections to SQL Server

Lecture 2: Lesson 1 [LAB] : Authenticating Logins

Lecture 3: Lesson 2 : Authorizing Logins to Connect to Databases

Lecture 4: Lesson 2 [LAB] : Authorizing Logins and User Tokens

Lecture 5: Lesson 3 : Partially Contained Databases

Lecture 6: Lesson 3 [LAB] : Creating a Partially Contained Database

Chapter 4: Module 2 : Assigning Server and Database Roles

Lecture 1: Lesson 1 : Working with Server Roles

Lecture 2: Lesson 1 [LAB] : Assigning Fixed and User-Defined Server Roles

Lecture 3: Lesson 2: Working with Fixed Database Roles

Lecture 4: Lesson 2 [LAB] : Managing Database Roles and Users

Lecture 5: Lesson 3 : User-Defined Database Roles

Lecture 6: Lesson 3 [LAB] : User-Defined Database Roles

Chapter 5: Module 3 : Authorizing Users to Access Resources

Lecture 1: Lesson 1 Authorizing User Access to Objects

Lecture 2: Lesson 1 [LAB] : Authorizing User Access to Objects

Lecture 3: Lesson 2 Authorizing Users to Execute Code

Lecture 4: Lesson 2 [LAB] Authorizing Users to Execute Code

Lecture 5: Lesson 3 Configuring Permissions at the Schema Level

Lecture 6: Lesson 3 [LAB] Configuring Permissions at the Schema Level

Chapter 6: Module 4 Protecting Data with Encryption and Auditing

Lecture 1: Lesson 1 Options for Auditing Data Access in SQL Server

Lecture 2: Lesson 1 [LAB] : Auditing with Temporal Tables

Lecture 3: Lesson 2 Implementing SQL Server Audit

Lecture 4: Lesson 2 [LAB] Using SQL Server Audit

Lecture 5: Lesson 3 Managing SQL Server Audit

Lecture 6: Lesson 3[LAB] Managing SQL Server Audit

Lecture 7: Lesson 3.1 [LAB] Viewing the Output of SQL Server Audit

Lecture 8: Lesson 4 Protecting Data with Encryption

Lecture 9: Always Encrypted ,TDE,restoring Encrypted Bcakup [LAB]

Lecture 10: Dynamic Data Masking [Lab]

Lecture 11: Cell Encryption [LAB]

Chapter 7: Module 5 Recovery Models and Backup Strategies

Lecture 1: Lesson 1 Understanding Backup Strategies

Lecture 2: Lesson 2 SQL Server Transaction Logs

Lecture 3: Lesson 3 Planning Backup Strategies

Lecture 4: Module 5 [LAB]

Chapter 8: Module 6 Backing Up SQL Server Databases

Lecture 1: Lesson 1 Backing Up Databases and Transaction Logs

Lecture 2: Lesson 2 Managing Database Backups

Lecture 3: Lesson 2 [LAB] Verifying Backups

Lecture 4: Lesson 3 Advanced Database Options

Chapter 9: Module 7 Restoring SQL Server Databases

Lecture 1: Lesson 1 Understanding the Restore Process

Lecture 2: Lesson 2 Restoring Databases

Lecture 3: Lesson 3 Advanced Restore Scenarios

Lecture 4: Lesson 4 Point-in-time Recovery

Lecture 5: Module 7 [LAB]

Chapter 10: Module 8 Automating SQL Server Management

Lecture 1: Lesson 1 Automating SQL Server Management

Lecture 2: Lesson 2 Working with SQL Server Agent

Lecture 3: Lesson 3 Managing SQL Server Agent Jobs

Lecture 4: Module 8 [LAB]

Chapter 11: Module 9 Configuring Security for SQL Server Agent

Lecture 1: Configuring Security for SQL Server Agent

Lecture 2: Module 9 [LAB]

Chapter 12: Module 10 Monitoring SQL Server with Alerts and Notifications

Lecture 1: Lesson 1 Monitoring SQL Server Errors

Lecture 2: Lesson 2 Configuring Database Mail

Lecture 3: Module 10 [LAB] part 1 Configure Database Mail

Lecture 4: Module 10 [LAB] part 2 Alert and Notification

Chapter 13: Module 11 Introduction to Managing SQL Server Using PowerShell

Lecture 1: Lesson 1 Getting Started with Windows PowerShell

Lecture 2: Lesson 2 Configure SQL Server Using PowerShell

Lecture 3: Lesson 3 Administer and Maintain SQL Server with PowerShell

Lecture 4: Module 11 [LAB]

Chapter 14: Module 12 Tracing Access to SQL Server with Extended Events

Lecture 1: Lesson 1 Extended Events Core Concepts

Lecture 2: Lesson 1 [LAB] : Creating an Extended Events Session

Lecture 3: Lesson 2 Working with Extended Events

Lecture 4: Lesson 2 [LAB] Tracking Session-Level Waits

Chapter 15: Module 13 Monitoring SQL Server

Lecture 1: Lesson 1 Monitoring Activity Part 1

Lecture 2: Lesson 1 Part 2

Lecture 3: Lesson 1 Part 3

Lecture 4: Lesson 1 [LAB]

Lecture 5: Lesson 2 Capturing and Managing Performance Data

Lecture 6: Lesson 3 Analyzing Collected Performance Data

Lecture 7: Lesson 2,3 [LAB]

Chapter 16: Module 14 Troubleshooting SQL Server

Lecture 1: Lesson 1 A Troubleshooting Methodology for SQL Server

Lecture 2: Lesson 2 Resolving Service-Related Issues

Lecture 3: Lesson 3 Resolving Connectivity and Login Issues

Lecture 4: Module 14 [LAB]

Chapter 17: Module 15 Importing and Exporting Data

Lecture 1: Lesson 1 Export and Import

Lecture 2: Lesson 1 [LAB] Export and Import