MCSA SQL Server 2016 Database Administration Bootcamp

About This Bootcamp

Length: 6 days

The Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration certification shows that you have the primary set of SQL Server skills that are relevant across multiple solution areas in a business environment.

The primary goal of this course is to help each student pass the exams required to earn their MCSA SQL 2016 Database Administration certification. To do this, your knowledgeable instructor will blend hands-on labs with lecture and practice exams to prepare you to pass each exam. The practice exams identify knowledge gaps that the instructor will fill with customized, hands-on labs and tailored lectures. 

Required Exams

To earn the certification, students must pass the following exam(s):

70-764 : Administering a SQL Database Infrastructure

70-765 : Provisioning SQL Databases

Course Objectives

After completing this course, students will have the knowledge 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
  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)

Who should take this bootcamp.

The MCSA SQL 2016 Database Administration certification is for IT professionals either looking to get their first job in Microsoft Database technology or to document their existing skill sets. This boot camp is intended for students seeking to earn the MCSA SQL 2016 Database Administration certification and who need an expert instructor to guide them throughout the training and exam preparation process.

MCSA SQL Server 2016 Database Administration Bootcamp
Select a Date:
Choose a Location:
Enter the text in the image


Please fill out the form below to contact a training consultant directly or call 888-862-3784

Full Name

Company

Location

Email

Phone

Message

Enter the text in the image