MCSE Data Management and Analytics Bootcamp

About This Bootcamp

Length: 9 days

This boot camp will cover designing and implementing cloud data platform solutions with the Microsoft Data Platform by using SQL Server on-premises, hybrid and cloud data platform solutions. It describes how to design and implement and optimize workloads in hybrid scenarios with both on-premises and Microsoft Azure cloud-based solutions, and how to implement high availability and disaster recovery solutions.

The primary goal of this boot camp is to help each student pass the exams required to earn the MCSE Data Management and Analytics 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):

Exam:

70-764 – Administering a SQL Database Infrastructure

70-765 – Provisioning SQL Databases

70-473 – Designing and Implementing Cloud Data Platform Solutions

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)
  • Position Microsoft Cloud Data Platform Solutions
  • Design and implement solutions on Azure using SQL Server
  • Design and implement solutions on Azure using SQL Database
  • Design and implement security, access and auditing for cloud data platform solutions
  • Design highly scalable mission critical solutions using the Microsoft Data Platform
  • Design and implement cloud data platform solutions.

Who should take this bootcamp.

The MCSE Data Management and Analytics certification is for IT professionals either looking to expand upon and document their existing skills in Microsoft Database and Cloud technology or to document their existing skill sets. This boot camp is intended for students seeking to earn the MCSE Data Management and Analytics certification and who need an expert instructor to guide them throughout the training and exam preparation process.

MCSE Data Management and Analytics 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