MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days (2 Courses, 2 Exams, 2 Certs)
Training Schedule and Pricing
Our training model blends knowledge and certification prep into one solution. You can interact face-to-face with vendor-certified trainers at our training facilities or attend the same instructor-led live camp online.
-
Sep302024Delivery Format:CLASSROOM LIVEDate:09.30.2024 - 10.04.2024Location:SARASOTAPrice Includes:Instructor Led Class, Official Courseware, Labs and Exams$3,9955 days
-
Oct282024Delivery Format:CLASSROOM LIVEDate:10.28.2024 - 11.01.2024Location:SARASOTAPrice Includes:Instructor Led Class, Official Courseware, Labs and Exams$3,9955 days
-
Nov112024Delivery Format:CLASSROOM LIVEDate:11.11.2024 - 11.15.2024Location:SARASOTAPrice Includes:Instructor Led Class, Official Courseware, Labs and Exams$3,9955 days
Exams Included & Administered During Camp:
DP-300: Administering Microsoft Azure SQL Solutions
DP-900: Microsoft Azure Data Fundamentals
What's Included
2 Microsoft Test Vouchers
2 Microsoft Official Courses
1 Retake Voucher (per exam, if needed)
Microsoft Study Labs & Simulations
Onsite Pearson Vue Test Center
Instructor Led Classroom Training
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-900T00: Microsoft Azure Data Fundamentals
DP-300T00: Administering Microsoft Azure SQL Solutions
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.
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 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
Microsoft Job Role-based Azure Certifications
Microsoft has aligned Azure certifications and training to job roles - focusing on Admin, Dev or Architect.
Each certification requires 2 exams and no certification has any prerequisite certification requirements.
Certification Camps has developed a comprehensive training / delivery format which focuses on learning beyond the core content accessible to any Microsoft training provider. Our program incorporates interactive demonstrations with explanations which go beyond the content of the book. Additional content, videos, labs & demonstrations are provided to expand on advanced topics - providing additional insight and perspective. Certification Camps training is not the typical book & PowerPoint presentation found at any local training center.
As a Microsoft Certified Partner with Gold Learning Competency - we adhere to the strict guidelines, standards and requirements to use Microsoft's exclusive curriculum. More over - our standards go beyond the "minimum requirements" set forth by Microsoft Learning.
We leverage our partnership benefits of courseware customization to build end to end technology training solutions. Students gain practical skills which can be implemented immediately.
At most training centers - learning starts on the first day of class and ends on the last day. Our boot camp training program is designed to offer resources before, during and after.
CERTIFICATION CAMPS FACILITIES
CAMPUS - Certification Camps built out a stand alone training center (not a hotel conference room) with spacious classrooms, new desk, Herman Miller Aeron chairs & comfortable common areas. Each student has a dedicated desk with two monitors. Each classroom has a maximum of two rows - so everyone is able to be engaged without the "back row" feeling. 
CLASSROOM EQUIPMENT - Students work on a dedicated Dell Client Desktop with 32GB memory with 512GB SSD drives - All Labs are executed the extremely fast Microsoft Data Center Hosted Lab Environment .
CAMPUS INTERNET - The campus is connected with a 1Gbps (1,000 Mbps) Verizon Fios Business Connection which provides complete internet (including VPN) access for students.
COMMON AREA - Amenties including snacks, drinks (Coffee, 100% juices, sodas, etc) all complimentary.
LODGING - We use the Hyatt Place Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast internet access.
NEAR BY - Many shops, restaurants and grocery options are available within walking distance. Additionally - the hotel provided scheduled shuttle services. Restaurants like Cheesecake Factory, California Pizza Kitchen, Panera Bread, Bone Fish Grill, Ruby Tuesday's, Five Guys, Chipotle, Chili's and over 20 additional choices in the immediate area.
