Description
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 includes a brief introduction to Azure data foundations.
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.
The Microsoft Certified Azure Database Administrator boot camp is taught using Microsoft Official Courseware –
DP-900T00: Microsoft Azure Data Fundamentals
DP-300T00: Administering Relational Databases on Microsoft Azure
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
Topics Covered in this Official Boot Camp:
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 responsibilities 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
Describe 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