Course ODX20764C: Administering a SQL Database Infrastructure (180 Day)

Learn online

On-demand training

Learn more

Find a Microsoft Learning PartnerFind an on-demand training partner
Anytime accessYes
Anywhere access to recorded instructorYes
Microsoft official training contentYes
In-depth trainingYes
Hands-on labs Yes
SATV redemption Yes
Ask instructor questions in personNo
Attend live class in personNo
Attend live class remotelyNo
Time commitment Self-paced
(3 month access)
About this course
Technology:SQL Server
Level:Advanced
This Revision:C
Length:2 days
Language(s):English

First published:

21 June 2018
Overview
About this course
This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.
Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At course completion

After completing this course, students will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.