MCSE Data Management and Analytics Bootcamp | Course Outline | ATG Learning

Course Outline

MCSE Data Management and Analytics Bootcamp

MS521 | Day | 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. 

Upcoming Dates:

  • Oct 12, 2020 - Oct 20, 2020
  • Nov 09, 2020 - Nov 17, 2020
  • Dec 07, 2020 - Dec 15, 2020

Who should take this course

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.

Course Objectives

After completing this course, students will have the knowledge to:

Course Outline

Module 1: Authenticating and Authorizing Users

This module covers SQL Server security models, logins, and users.

Lessons

 

Module 2: Assigning Server and Database Roles

This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.

Lessons

 

Module 3: Authorizing Users to Access Resources

This module covers permissions and the assignment of permissions.

Lessons

 

Module 4: Protecting Data with Encryption and Auditing

This module covers SQL Server Audit.

Lessons

 

Module 5: SQL Server Recovery Models

This module describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.

Lessons

 

Module 6: Backup of SQL Server Databases

This module describes SQL Server Backup and the backup types

Lessons

 

Module 7: Restoring SQL Server Databases

This module describes the restoration of databases.

Lessons

 

Module 8: Automating SQL Server Management

This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.

Lessons

 

Module 9: Configuring Security for SQL Server Agent

This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.

Lessons

 

Module 10: Monitoring SQL Server with Alerts and Notifications

This module covers the configuration of database mail, alerts and notifications.

Lessons

 

Module 11: Introduction to Managing SQL Server by using PowerShell

This module introduces PowerShell for SQL Server.

Lessons

 

Module 12: Tracing Access to SQL Server

This module describes how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking.

Lessons

 

Module 13: Monitoring SQL Server

This module explains how to use Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.

Lessons

 

Module 14: Troubleshooting SQL Server

This module explains the SQL Server troubleshooting methodology and discusses the most common issues that can arise when working with SQL Server systems.

Lessons

 

Module 15: Importing and Exporting Data

This module covers the use of the import/export wizards and explains how they relate to SSIS. The module also introduces BCP and BULK INSERT.

Lessons

 

Module 16: SQL Server 2016 Components

Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.

Lessons

 

Module 17: Installing SQL Server 2016

This modules describes the process to install SQL Server 2016.

Lessons

 

Module 18: Upgrading SQL Server to SQL Server 2016

This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.

Lessons

 

Module 19: Deploying SQL Server on Microsoft Azure

This module describes the options available to run SQL Server on Azure.

Lessons

 

Module 20: Working with Databases

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

 

Module 21: Database Storage Options

At the end of this module you will be able to describe the database storage options.

Lessons

 

Module 22: Performing Database Maintenance

This module covers database maintenance.

Lessons

 

Module 23: Microsoft Cloud Data Platform Overview

This module provides an overview of the Microsoft Data Platform Solutions in Hybrid and Cloud based scenarios. The module provides an overview of offerings and capabilities.

Lessons

 

Module 24: Implement SQL Server on Azure VM

This module with a hands-on-lab describes the core capabilities of running SQL Server in a virtual machine environment (IAAS) on Azure.

Lessons

 

Module 25: Implement SQL Database

This module with a hands-on-lab describes the core capabilities of implementing data platform solutions using SQL Database on Azure. The module provides details in service tiers and offerings.

Lessons

 

Module 26: SQL Database High Availability and disaster recovery

This module with a hands-on lab describes high availability and disaster recovery scenarios with SQL Database.

Lessons

 

Module 27: Hybrid HA/DR scenarios with SQL Server

This module with a hands-on lab exercise describes the design of high available, scalable data platform solutions on-premises, in the cloud and in hybrid cloud scenarios using SQL Server on premises and with Azure VMs.

Lessons

 

Module 28: Design and Implement Security

This module with a hands-on-lab describes the security features and capabilities in SQL Server in Azure VMs and SQL Database including firewalls and auditing.

Lessons

 

Module 29: Monitor and manage implementations on Azure

This module with a hands-on-lab focuses on management and deployment, monitoring for performance of SQL Database and SQL Server in Azure VMs.

Lessons

 

Module 30: Design and implement database solutions for SQL Server and SQL Database

This module covers design and architecture scenarios for implementation of database solutions using the Microsoft Cloud Data Platform. This module introduces key scenarios to discuss with classroom attendees in order to build out the right architecture and infrastructure based on architecture and business requirements.

Lessons