• Blog
  • Reviews
  • Contact Us
  • Locations
1-844-BOOTCAMP
or 1-941-218-0007
Certification Camps
  • HOME
  • BOOTCAMPS
  • CERTIFICATIONS
    • Microsoft 365
      • MCA Microsoft 365 Teams Administrator
      • MCA Microsoft 365 Security Administrator
      • MCA Modern Desktop Administrator (Windows 10)
      • MCA Microsoft 365 Teamwork Administrator
      • MCA Microsoft 365 Messaging Administrator
    • SQL Server
      • MCA Microsoft Data Analyst (Power BI) Associate
      • MCA Microsoft Azure Database Administrator
      • MCA Microsoft Azure Data Engineer
      • MCSA SQL 2016 Database Administration
      • MCSA SQL 2016 Database Development
    • Windows Server
      • MCSA Windows Server 2016
    • Microsoft Azure
      • MCA Azure Administrator
      • MCA Azure Developer
      • MCE Azure Solutions Architect
      • MCE Microsoft Azure DevOps
    • Windows Client
      • MCA Microsoft 365 Modern Desktop Administrator
    • Microsoft 365 Messaging Server
      • MCA Microsoft 365 Messaging Administrator
    • Microsoft 365 Enterprise
      • MCE Microsoft 365 Enterprise Administrator
    • Microsoft 365 Teamwork
      • MCA Microsoft 365 Teamwork Administrator
    • System Center
      • MCS System Center Configuration Manager v1702 (SCCM)
    • Azure Developer
      • MCA Azure Developer
      • MCE Microsoft Azure DevOps
    • Information Security
      • EC-Council Certified Ethical Hacker (CEH)
    • CompTia
      • Comptia Cloud+
      • CompTia A+ Essentials
      • CompTia Network +
      • CompTia Security +
  • SCHEDULE
  • Role Based Certifications
  • Pay an Invoice
Home > Bootcamps > MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days
ADMINISTRATOR BOOTCAMP

MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days

Certifications:

  • MCA Microsoft Azure Database Administrator
Length: 5 days
Request More Information
$3,495 REMOTE CLASSROOM LIVE
Price includes: Books, Test Vouchers What does this price include?

This Bootcamp is available in the following formats. Select format to view pricing.

Classroom Live
Remote Classroom Live
azure training

Exams Included & Administered During Camp:

DP-300: Administering Relational Databases on Microsoft Azure

DP-900: Microsoft Azure Data Fundamentals

 

Microsoft Gold Learning Partner

Schedule:

  • 05.24.2021 - 05.28.2021
    Register Get Quote
  • 06.07.2021 - 06.11.2021
    Register Get Quote
  • 07.12.2021 - 07.16.2021
    Register Get Quote
  • 08.02.2021 - 08.06.2021
    Register Get Quote
  • 08.30.2021 - 09.03.2021
    Register Get Quote
  • 09.13.2021 - 09.17.2021
    Register Get Quote
  • 10.04.2021 - 10.08.2021
    Register Get Quote
  • 11.01.2021 - 11.05.2021
    Register Get Quote
  • 12.06.2021 - 12.10.2021
    Register Get Quote

What's Included

  • Airfare To/From Sarasota or TampaAirfare To/From Sarasota or Tampa
  • 4 Microsoft Test Vouchers2 Microsoft Test Vouchers
  • Microsoft Training Books2 Microsoft Official Courses
  • 12 Nights of Lodging5 Nights of Lodging
  • 2 Retake Vouchers (If needed)1 Retake Voucher (per exam, if needed)
  • 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
* Please contact us for pricing without lodging and transportation.
  • Course Description
  • Azure Database Admin Cert Overview
  • Microsoft Azure Certifications
  • Microsoft Gold Learning Partner
  • Facilities

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.

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 AdministratorPlan and Implement Data Platform ResourcesImplement a Secure EnvironmentMonitor and Optimize Operational ResourcesOptimize Query PerformanceAutomation of TasksPlan and Implement a High Availability and Disaster Recovery EnvironmentAzure Data FoundationsExplore core data conceptsExplore relational data in AzureExplore non-relational data in AzureExplore modern data warehouse analytics in Azure
The Role of the Azure Database Administrator

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

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

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

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

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

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

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

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

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

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

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

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 a state of the art training center with spacious classrooms, no sound transference between rooms, large individual desk, Herman Miller Aeron chairs & great common areas.

CLASSROOM SERVERS & LABS - Students work on a dedicated Dell 8700 / 8900 with an Intel i7 (6th generation), 32GB memory with 512GB SSD drives.  Most labs are administered with Microsoft Data Center Hosted Labs Environments - providing the very best in performance and reliability.

CAMPUS INTERNET - The campus is connected with a 300Mbs Verizon Fios Business Connection which provides complete internet (including VPN) access for students.

COMMON AREA - Unlike any training facility ever - break room with Mame Arcade, high end "kitchen" with snacks, drinks (Starbucks Coffee, 100% juices, sodas, etc) and breathtaking terrace.

LODGING - We use the Marriott Fairfield Inn & Suites Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast (Verizon) internet access.

NEARBY AMENITIES - 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, Quiznos, Chili's and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.

About

  • About Us
  • Reviews
  • Contact Us
  • Blog

Bootcamps

  • SQL Server
  • Microsoft 365 Enterprise
  • Windows Server
  • Microsoft Azure
  • Office 365
  • Windows 10
  • Exchange Server
  • Sharepoint Server
  • System Center
  • Microsoft Azure Developer
  • Information Security
  • CompTia
  • Cisco

Certifications

  • SQL Server
  • Microsoft 365
  • Windows Server
  • Windows Client
  • Microsoft 365 Messaging Server
  • Microsoft 365 Enterprise
  • Microsoft 365 Teamwork
  • System Center
  • Microsoft Azure
  • Azure Developer
  • Microsoft Technology Associate
  • Information Security
  • CompTia
  • Cisco

Registration

  • More Info
  • Register for a Bootcamp
  • Pay Invoice

Technical Training

  • SQL Server
  • Microsoft 365
  • Microsoft Azure
  • Windows Server
  • Windows Client
  • Exchange Server
  • Office 365
  • Sharepoint
  • System Center
  • Visual Studio

Copyright © 2021 Certification Camps. All rights reserved.

  • Terms & Conditions
  • Privacy Policy