Course Details

Previous Page


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


Target Audience
Database administrators and database professionals.

Expected Duration (hours)
32.0

Lesson Objectives

Administering a SQL Database Infrastructure Expert Live with Encore

  • Configure encryption
  • Configure data access and permissions
  • Configure auditing
  • Develop a backup strategy
  • Restore databases
  • Manage database integrity
  • Monitor database activity
  • Monitor queries
  • Manage indexes
  • Manage statistics
  • Monitor SQL Server instances
  • Implement log shipping
  • Implement AlwaysOn Availability Groups
  • Implement failover cluster instances
  • Course Number:
    LLMS0072