70-764: Administering a SQL Server 2016 Database Infrastructure

In this instructor-led, online training course, students will learn how to use Configuration Manager and its associated site systems to efficiently manage network resources, day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. Students will also be taught how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports.

Exam Number: 70-764

Microsoft Course Demo

 

Skills Learned

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

Who Should Attend This Course

This instructor led, online training course is for those who administer and maintain SQL Server databases.

Prerequisites

We recommend that students have:

  • 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

Course Outline

*Course Outline is subject to change

  • SQL Server Security
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Recovery Models and Backup Strategies
  • Backing Up SQL Server Databases
  • Restoring SQL Server 2016 Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data

Like What You See? Let’s Get Started Training.

Call 480-850-9200 or submit below to get pricing for you or your team.