Administering a SQL Database Infrastructure Expert Live with Encore
Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Overview/Description
SQL Server 2016 is a scalable database platform with advanced security and analytics, Business Intelligence, and hybrid cloud features. This course covers the tasks and tools involved in administering a SQL Server 2016 database infrastructure and also the objectives for exam 70-764: Administering a SQL Database Infrastructure. This exam is part of the MCSA: SQL 2016 Database Administration certification.
- Prerequisites
- Candidates should have one to two years of experience using SQL Server, any version.
- Certification
- Microsoft SQL Server 2016 MCSA/MCP
- Exams
- 70-764: Administering a SQL Database Infrastructure
- Outline
- Administering a SQL Database Infrastructure
- Encryption, Data Access, Permissions, and Auditing
- Backing Up and Restoring Databases
- Managing Database Integrity
- Monitoring Database Activity, Queries, and SQL Server Instances
- Managing Indexes and Statistics
- High Availability and Disaster Recovery
- Backing Up and Restoring Databases
Target Audience
Database administrators and database professionals.
Expected Duration (hours)
32.0
Lesson Objectives
Administering a SQL Database Infrastructure Expert Live with Encore
LLMS0072