IL - MOC 20764: Administering a SQL Database Infrastructure
Instructor-Led Training
Intermediate
5 Days
Onsite or Virtual
Course Overview
In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist you in preparing for the 70-764: Administering a SQL Database Infrastructure exam.
Objectives
  • Authenticate and authorize users.
  • Assign server and database roles.
  • Authorize users to access resource.
  • Protect data with encryption and auditing.
  • Recovery models and backup strategies.
  • Back up SQL Server databases.
  • Restore SQL Server databases.
  • Automate database management.
  • Configure security for the SQL Server agent.
  • Manage alerts and notifications.
  • Manage SQL Server using PowerShell.
  • Trace access to SQL Server.
  • Monitor a SQL Server infrastructure.
  • Troubleshoot a SQL Server infrastructure.
  • Import and export data.
Pre-Requisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  • Onsite at your location
  • Virtual Training
Dedicated Training
Contact Us Today

Dedicated instructor-led training is designed for group training and is delivered by the experts at Opsgility. Delivery availability is anywhere in the world at your location or using advanced virtual training software.

Benefits
  • Standard or Customized Curriculum
  • Globally Available for Delivery
  • Holistic Learning Plans are Available
  • Industry Recognized Subject Matter Experts