Administering Relational Databases on Microsoft Azure (DP-300)
Do you want to be a Microsoft Azure DBA?
If you’re new to database administration, you are likely to have more flavours of SQL Server to manage than ever before. Your experienced teammates may have grown up looking after on-premises SQL Servers and may be multiple versions of it, but if you are starting now will likely still have to considerÂ
- Out of date and out of support versions of SQL Server
- SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
- SQL Server 2012 – SQL Server 2019 on-premisesÂ
- Azure SQL Database
- Managed Instances
- IaaS VMs
There is a lot to consider. So if you want to learn about all of these different flavours of SQL Server and how to work in a combination of on-premises SQL Server, Or hybrid environments where you have infrastructure both on-premises and in Azure cloud, or you might just be working on the data platform in Azure. You need a training course that helps you learn all three.
Step up Microsoft new training course Administering Relational Databases on Microsoft Azure (DP-300). It is a four-day course that will help understand the role of a DBA in the new Azure cloud world. Providing you 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 offerings.Â
Who should attend
The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.
Key Information
Duration:Â 4 days
Cost: £1500 (plus VAT)
Job role:Â Database Administrator
Preparation for the exam:Â DP-300
Certification:Â Microsoft Certified: Azure Database Administrator Associate
tings.
What you will learn
During the course you will learn to
- 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
settings.
Talk to us for free today
Module 1: The Role of the Azure Database Administrator
- Azure Data Platform Roles
- Azure Database Platforms and Options
- SQL Server Compatibility Levels
- Azure Preview Features
Module 2: Plan and Implement Data Platform Resources
- Deploying SQL Server using IaaS
- Deploying SQL Server using PaaS
- Deploying Open Source Database Solutions on Azure
Module 3: Implement a Secure Environment
- Configure Database Authentication
- Configure Database Authorization
- Implement Security for Data at Rest
- Implement Security for Data in Transit
- Implement Compliance Controls for Sensitive Data
Module 4: Monitor and Optimize Operational Resourcestor
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
- Configuring Resources for Optimal Performance
- User Database Configuration
- Performance-related Maintenance Tasks
Module 5: Optimize Query Performance
- Understanding SQL Server Query Plans
- Explore Performance-based Database Design
- Evaluate Performance Improvements
Module 6: Automation of Tasks
- Setting up Automatic Deployment
- Defining Scheduled Tasks
- Configuring Extended Events
- Managing Azure PaaS resources Using Automated Methods
Course Schedule
September
Date: 15th September
Venue: Online (Zoom)
Module 7: Plan and Implement a High Availability and Disaster Recovery Environment
- High Availability and Disaster Recovery Strategies
- IaaS Platform and Database Tools for HADR
- PaaS Platform and Database Tools for HADR
- Database Backup and Recovery
Course Schedule
September
Date: 15th September
Venue: Online (Zoom)