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:
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs) class.
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
Lab : Using the Azure Portal and SQL Server Management Studio
After completing this module, students will:
Plan and Implement Data Platform Resources
Lessons
Lab : Deploying Azure SQL Database
Implement a Secure Environment
Lessons
Lab : Implement a Secure Environment
Monitor and Optimize Operational Resources
Lessons
Lab : Monitor and Optimize Resources
Optimize Query Performance
Lessons
Lab : Query Performance Troubleshooting
Automation of Tasks
Lessons
Lab : Automating Tasks
Plan and Implement a High Availability and Disaster Recovery Environment
Lessons
Lab : Plan and Implement a High Availability and Disaster Recovery Environment
Azure Data Foundations
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
After completing this module, students will be able to:
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
After completing this module, students will be able to:
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
After completing this module, students will be able to:
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
After completing this module, students will be able to:
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs) class.
None
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs) class.
Course Comments
$4,495 Price includes: Airfare, Lodging, Transportation, Instructor Led Class, Official Courseware, Labs and Exams
What's Included
No Upcoming Public Classes
There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs) class.