MCA Microsoft Azure Database Administrator Training & Certification Boot Camp – 5 Days
Select Delivery Format
Exams Included & Administered During Camp:
DP-300: Administering Relational Databases on Microsoft Azure
DP-900: Microsoft Azure Data Fundamentals
What's Included
Airfare To/From Sarasota or Tampa- 2 Microsoft Test Vouchers
- 2 Microsoft Official Courses
- 5 Nights of Lodging
- 1 Retake Voucher (per exam, if needed)
- Microsoft Study Labs & Simulations
- Ground Transportation
- Onsite Pearson Vue Test Center
- Instructor Led Classroom Training
Airfare To/From Sarasota or Tampa
2 Microsoft Test Vouchers
2 Microsoft Official Courses
5 Nights of Lodging
1 Retake Voucher (per exam, if needed)
Microsoft Study Labs & Simulations
Ground Transportation
Onsite Pearson Vue Test Center
Instructor Led Classroom TrainingThe 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.
The focus and objectives of this camp include
Plan and implement data platform resources
Implement a secure environment
Monitor and optimize operational resources
Optimize query performance
Perform automation of tasks
Plan and implement a High Availability and Disaster Recovery (HADR) environment
Perform administration by using T-SQL
Topics Covered in this Official Boot Camp
Azure Database Administrator
Lessons
- 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
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
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.