0
  • No products in the cart.
Cart Total:$0.00

Microsoft 70-764 : Administering a SQL Database Infrastructure 2016

The Microsoft 70-764 SQL Server 2016 Administration course prepares student for the Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server. This Microsoft 70-764 SQL Server 2016 Administration course is for students intended for IT professionals responsible for installing, configuring and maintaining a Microsoft SQL Server environment. Students preparing for the 70-764 exam will typically will have at least 2 years of experience working with SQL Server. Microsoft recommends having experience setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. You will be able to engage these topics on multiple platforms, including SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.

$49.99

SKU: IT-ms-70-764 Categories: , , , , ,
Description

About our training program

The Microsoft 70-764 SQL Server 2016 Administration course prepares students for the Microsoft Certification Exam 70-764. By the end of this course, students will be able to administer a Microsoft SQL 2016 server.

This Microsoft 70-764 SQL Server 2016 Administration course is for students intended for IT professionals responsible for installing, configuring and maintaining a Microsoft SQL Server environment. Students preparing for the 70-764 exam will typically will have at least 2 years of experience working with SQL Server.

What will you learn:

This course includes 22 hours of training and 106 videos. In this Microsoft 70-764 SQL Server course, students will learn essential skills on how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting and end with creating an Availability Group, manage failover, configure read-only routing and create distributed availability groups. Other topics covered throughout the course include the following that students will learn:

  • Configure data access and auditing
  • Manage backup and restore of databases
  • Manage and monitor SQL Server instances
  • Manage high availability and disaster recovery
  • Database systems and Monitoring database activity
  • Database administrators
  • Database designs

Course Outline

Microsoft 70-764 SQL 2016 – Administering a SQL Database Infrastructure Course Content

Download Course Outline

Introduction

Exam Objectives and Lab Setup

Restoring AdventureWorks 2016 Database Lab Part 1

Restoring AdventureWorks 2016 Database Lab Part 2

Restoring AdventureWorks 2016 Database Lab Part 3

Configure Encryption

Cell-Level Encryption Part 1

Cell-Level Encryption Part 2

Cell-Level Encryption Lab Part 1

Cell-Level Encryption Lab Part 2

Transparent Data Encryption

Transparent Data Encryption Lab

Always Encrypted

Always Encrypted Lab

Backup Encryption

Backup Encryption Lab

Connection Encryption

Encryption Troubleshooting

Create and Maintain Users

Create and Maintain Users Lab Part 1

Create and Maintain Users Lab Part 2

Configure and Maintain Custom Roles

Configure and Maintain Custom Roles Lab

Manage Database Object Permissions Part 1

Manage Database Object Permissions Part 2

Manage Database Object Permissions Lab Part 1

Manage Database Object Permissions Lab Part 2

Configure User Options for Azure SQL Database

Configure Row-Level Security

Configure Dynamic Data Masking

Configure Dynamic Data Masking Lab

Manage a SQL Server Audit

Manage a SQL Server Audit Lab

Query the SQL Server Audit Log

Manage an Azure SQL Server Audit

Backup Types Part 1

Backup Types Part 2

Manage, Backup, and Restore Databases Lab Part 1

Manage, Backup, and Restore Databases Lab Part 2

Backup Very Large Databases Part 1

Backup Very Large Databases Part 2

Backup Very Large Databases Part 3

Backup Very Large Databases Part 4

4.9 Managing Very Large Databases Lab Part 1

4.10 Managing Very Large Databases Lab Part 2

4.11 Managing Very Large Databases Lab Part 3

Configure Alerting for Failed Backups

Configure Alerting for Failed Backups Lab Part 1

Configure Alerting for Failed Backups Lab Part 2

Back up Databases to Azure

Manage Transaction Log Backups

Configure Database Recovery Models

Set Database Recovery Model Lab

Configure Backup Automation

Configure Backup Automation Lab

Perform Piecemeal Restores

Restore Databases Lab Part 1

Restore Databases Lab Part 2

Restore Databases Lab Part 3

Perform Page Recovery

Perform Point-in-Time Recovery

Perform Point-in-Time Recovery Lab

Restore File Groups

Develop a Plan to Automate and Test Restores

Implement Database Consistency Checks

Implement Database Consistency Checks Lab

Identify Database Corruption

Recover From Database Corruption

Monitor Current Sessions

Monitor Current Sessions Lab

Identify Sessions that Cause Blocking Activity

Identify Sessions that Consume tempdb Resources

Configure the Data Collector

Manage the Query Store

Manage the Query Store Lab

Configure Extended Events and Trace Events

Identify Problematic Execution Plans

Identify and Repair Index Fragmentation

Identify and Create Missing Indexes

Identify and Drop Underutilized Indexes

Manage Existing Columnstore Indexes Part 1

Manage Existing Columnstore Indexes Part 2

Partitioned Tables

Create and Manage Operators

Create and Manage SQL Agent Alerts

Configure Policy-Based Management

Configure Policy-Based Management Lab

Identify Available Space on Data Volumes

Identify the Cause of- Manage Performance Degradation

Identify the Cause of- Manage Performance Degradation Lab Part 1

Identify the Cause of- Manage Performance Degradation Lab Part 2

Configure and Monitor Log Shipping

Configure and Monitor Log Shipping Lab Part 1

Configure and Monitor Log Shipping Lab Part 2

Windows Server Failover Cluster

Manage Shared Disks

Configure Cluster Shared Volumes

Configuring WSFC Lab

Database Mirroring

Create an Availability Group

Manage Failover

Configure Read-Only Routing

Create Distributed Availability Groups

Configuring Always On Availability Group Lab Part 1

Configuring Always On Availability Group Lab Part 2

Conclusion

Your Training Instructor

Chrys Thorsen
Education and Technology Expert

Related Products

$49.99

Course features:

21 Hrs 14 Min

106 VIDEOS

1 Year Access

Available on Web