Course Overview
Administering Relational Databases on Microsoft Azure DP-300T00 course is a training course offered by Microsoft at CounselTrain Technologies that provides learners with the knowledge and skills required to administer a Microsoft SQL Server database on the Microsoft Azure cloud platform.
In this course, students will learn how to provision and configure a SQL Server on Azure Virtual Machines (VMs), how to configure Azure SQL Database, how to configure security for Azure SQL Database and Azure VMs, how to monitor and optimize the performance of SQL Server on Azure, and how to implement high availability and disaster recovery solutions for SQL Server on Azure. This course is intended for individuals who are database administrators or have experience working with SQL Server and want to learn how to administer a SQL Server
Learning Options
Target audiences
- The target audience for DP-300T00: Administering Microsoft Azure SQL Solutions training is IT professionals with experience in SQL Server administration on-premises or in Azure VM, data professionals, application developers, and database administrators who have some experience working with Azure services
- Those coming to the training should have experience troubleshooting and resolving issues related to performance changes, versioning, and security
- Business strategists, project managers, and C-level executives looking to gain a better understanding of how managing and administering cloud-based SQL solutions can improve organizational performance and efficiency would also benefit from this training
Schedule Dates
Curriculum
-
Module 1: The Role of the Azure Database Administrator
-
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
- 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
-
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
- 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
-
Module 4: Monitor and Optimize Operational Resources
- Baselines and Performance Monitoring
- Major Causes of Performance Issues
- Configuring Resources for Optimal Performance
- User Database Configuration
- Performance-related Maintenance Tasks
- Performance-related Maintenance Tasks
- Isolate CPU Problems
- Use Query Store observe blocking problems
- Detect and correct fragmentation issues
-
Module 5: Optimize Query Performance
- 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
-
Module 6: Automation of Tasks
- 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
-
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
- 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
The key learning objectives of the Administering Relational Databases on Microsoft Azure DP-300T00 course are:
Understand the benefits of using Microsoft Azure for hosting SQL Server databases.
Provision and configure Azure Virtual Machines for hosting SQL Server.
Deploy and configure SQL Server on Azure Virtual Machines.
Understand the differences between Azure SQL Database and SQL Server on Azure Virtual Machines, and be able to choose the appropriate deployment option for a given scenario.
Create and configure Azure SQL Databases.
Understand how to secure Azure SQL Database and Azure Virtual Machines.
Monitor and optimize the performance of SQL Server on Azure using various tools and techniques.
Understand the various high availability and disaster recovery solutions that can be implemented for SQL Server on Azure.
Implement high availability and disaster recovery solutions for SQL Server on Azure.
Understand how to migrate an on-premises SQL Server database to Azure.
Understand the benefits of using Microsoft Azure for hosting SQL Server databases.
Provision and configure Azure Virtual Machines for hosting SQL Server.
Deploy and configure SQL Server on Azure Virtual Machines.
Understand the differences between Azure SQL Database and SQL Server on Azure Virtual Machines, and be able to choose the appropriate deployment option for a given scenario.
Create and configure Azure SQL Databases.
Understand how to secure Azure SQL Database and Azure Virtual Machines.
Monitor and optimize the performance of SQL Server on Azure using various tools and techniques.
Understand the various high availability and disaster recovery solutions that can be implemented for SQL Server on Azure.
Implement high availability and disaster recovery solutions for SQL Server on Azure.
Understand how to migrate an on-premises SQL Server database to Azure.
The Administering Relational Databases on Microsoft Azure DP-300T00 course is a 5-day instructor-led training course. The course includes lectures, hands-on labs, and exercises to reinforce the concepts and skills covered in each module. At the end of the course, learners will have the skills and knowledge required to administer a SQL Server database on the Microsoft Azure cloud platform.
The value of a course depends on the course content and the learner's career goals. However, in general, taking courses can bring several benefits to learners' careers, such as:
Skill development
Career Advancement
Networking opportunities
Professional Credibility
Overall, taking courses can help learners stay competitive in their field and increase their chances of success in their careers.
Skill development
Career Advancement
Networking opportunities
Professional Credibility
Overall, taking courses can help learners stay competitive in their field and increase their chances of success in their careers.
The course teaches learners how to migrate on-premises SQL Server databases to Azure, which can be a crucial skill for organizations looking to move their infrastructure to the cloud. The course includes hands-on labs that allow learners to practice deploying and managing SQL Server on Azure, giving them practical experience that they can apply to real-world scenarios. By learning how to manage SQL Server on Azure, learners can enhance their skills and become more marketable in the job market. This course is a prerequisite for the Microsoft Certified: Azure Database Administrator Associate certification, so attending this course is a good way to prepare for the certification exam.