651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs) Classroom Live Sarasota, FL May 24, 2021

Price: $4,495

This course runs for a duration of 5 Days.

The class will run daily from 8:00 AM ET to 6:00 PM ET.

Class Location: Sarasota - Sarasota, FL.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

The Azure Database Administrator 5 Day Boot Camp covers topics to implement and manages the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services (in addition to essential Azure Database Foundation topics).  This camp covers TWO Microsoft courses, TWO Microsoft exams for TWO Microsoft certifications at our training facility in Florida or Online.

The NEW Microsoft Azure Database Administrator Training & Certification 5 Day Boot Camp prepares students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database options. This camp is intended for data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure.  This camp also included a brief introduction to Azure data foundations.

The Microsoft Azure Database Administrator Boot Camp is taught using Microsoft Official Courseware

DP-300T00: Administering Relational Databases on Microsoft Azure
DP-900T00: Microsoft Azure Data Fundamentals

While attending this 5 day instructor led live camp - students will take two exams (DP-300 / DP-900) to achieve the Microsoft Certified Associate Database Administrator certification.  This hands on, instructor led live camp focuses on the real world responsibilities of an Azure Database Administrator covering the information needed for the certification exams which are administered while attending.

$4,495 Price includes: Airfare, Lodging, Transportation, Instructor Led Class, Official Courseware, Labs and Exams
$3,495 Price includes: Live Virtual Training with Offical Coureware, Labs and Exam Vouchers

Skills Gained:

  • Describe core data concepts in Azure
  • Explain concepts of relational data in Azure
  • Explain concepts of non-relational data in Azure
  • Identify components of a modern data warehouse in Azure
  • Plan, deploy and configure Azure SQL offerings
  • Monitor database performance and tune a database and queries for optimum performance
  • Plan and configure a High Availability Solution

Course Overview

The Role of the Azure Database Administrator

This module explores the role of a database administrator in the world of Azure. It also provides some foundational information relevant to the overall content. This includes a review of the various SQL Server-based options (SQL Server in a VM, Managed Instances, and Azure SQL Database.) Students will learn why compatibility level is a crucial concept when working with SQL databases in Azure. Students are also introduced to other database platforms available on Azure in addition to those based on SQL Server, in particular PostgreSQL and MySQLLessons

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features

Lab : Using the Azure Portal and SQL Server Management Studio

  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup

After completing this module, students will:

  • Understand the role of Azure Database Administrator as it fits in with other data platform roles
  • Be able to describe the key differences between the SQL Server-based database op
  • Be able to describe the difference between versions and compatibility levels
  • Know how to enable and disable preview features

Plan and Implement Data Platform Resources

Lessons

  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open Source Database Solutions on Azure

Lab : Deploying Azure SQL Database

  • Deploy a VM using an ARM template
  • Configure resources needed prior to creating a database
  • Deploy an Azure SQL Database
  • Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
  • Deploy PostgreSQL or MySQL using a client tool to validate connectivity

Implement a Secure Environment

Lessons

  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data

Lab : Implement a Secure Environment

  • Configure a server-based firewall rule using the Azure Portal
  • Authorize Access to Azure SQL Database with Azure Active Directory
  • Enable Advanced Data Security and Data Classification
  • Manage access to database objects

Monitor and Optimize Operational Resources

Lessons

  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks

Lab : Monitor and Optimize Resources

  • Isolate CPU Problems
  • Use Query Store observe blocking problems
  • Detect and correct fragmentation issues

Optimize Query Performance

Lessons

  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements

Lab : Query Performance Troubleshooting

  • Identify issues with database design AdventureWorks2017
  • Isolate problem areas in poorly performing queries in AdventureWorks2017
  • Use Query Store to detect and handle regression in AdventureWorks2017
  • Use query hints to impact performance in AdventureWorks2017

Automation of Tasks

Lessons

  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods

Lab : Automating Tasks

  • Deploy an Azure template from a Quickstart template on GitHub
  • Configure notifications based on performance metrics
  • Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database

Plan and Implement a High Availability and Disaster Recovery Environment

Lessons

  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery

Lab : Plan and Implement a High Availability and Disaster Recovery Environment

  • Create an Always On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL

 

Azure Data Foundations

  • Describe core data concepts
  • Describe how to work with relational data on Azure
  • Describe how to work with non-relational data on Azure
  • Describe an analytics workload on Azure

Explore core data concepts

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.

Lessons

  • Explore core data concepts
  • Explore roles and responsiblities in the world of data
  • Describe concepts of relational data
  • Explore concepts of non-relational data
  • Explore concepts of data analytics

After completing this module, students will be able to:

  • Show foundational knowledge of cloud data services within Azure
  • Identify and describe core data concepts such as relational, non-relational, big data, and analytics
  • Explain how this technology is implemented with Azure

Explore relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Azure.

Lessons

  • Explore relational data services in Azure
  • Explore provisioning and deploying relational database services in Azure
  • Query relational data in Azure

After completing this module, students will be able to:

  • Describe relational data services on Azure
  • Explain provisioning and deploying relational databases on Azure
  • Query relational data through cloud data solutions in Azure

Explore non-relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore non-relational data services, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.

Lessons

  • Explore non-relational data services in Azure
  • Explore provisioning and deploying non-relational data services on Azure
  • Manage non-relational data stores in Azure

After completing this module, students will be able to:

  • Describe non-relational data services on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Decribe non-relational data stores on Azure

Explore modern data warehouse analytics in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

Lessons

  • Examine components of a modern data warehouse
  • Explore data ingestion in Azure
  • Explore data storage and processing in Azure
  • Get started building with Power BI

After completing this module, students will be able to:

  • Describe processing options available for building data analytics solutions in Azure
  • Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • Explain what Microsoft Power BI is, including its building blocks and how they work together

Prerequisites

None

Course Comments

$4,495 Price includes: Airfare, Lodging, Transportation, Instructor Led Class, Official Courseware, Labs and Exams

What's Included

  • 4 Microsoft Test Vouchers2 Microsoft Test Vouchers
  • Microsoft Training Books2 Microsoft Official Courses
  • Microsoft Study Labs & SimulationsMicrosoft Study Labs & Simulations
  • Ground TransportationGround Transportation
  • Onsite Prometric Testing CenterOnsite Pearson Vue Test Center
  • Instructor Led Classroom TrainingInstructor Led Classroom Training

Other Available Dates for this Course

Virtual Classroom Live
April 08, 2024

$3,995.00
5 Days    8:30 AM ET - 4:30 PM ET
view class details and enroll
Virtual Classroom Live
May 13, 2024

$3,995.00
5 Days    8:30 AM ET - 4:30 PM ET
view class details and enroll
Virtual Classroom Live
June 17, 2024

$3,995.00
5 Days    8:30 AM ET - 4:30 PM ET
view class details and enroll