Administering SQL Database Infrastructure

This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Exam 70-764 Administering a SQL Database Infrastructure

This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Course Content

Configure data access and auditing (20–25%)

  • Configure encryption
  • Configure data access and permissions
  • Configure auditing

Manage backup and restore of databases (20–25%)

  • Develop a backup strategy
  • Restore databases
  • Manage database integrity

Manage and monitor SQL Server instances (35–40%)

  • Monitor database activity
  • Monitor queries
  • Manage indexes
  • Manage statistics
  • Monitor SQL Server instances

Manage high availability and disaster recovery (20–25%)

  • Implement log shipping
  • Implement AlwaysOn Availability Groups

Implement failover cluster instances

Fill Form

Training Type:CoorporatePrivate

JOIN AN UPCOMING CLASS FOR THIS COURSE