The content of this intensive training is derived from the exam "DP-300: Administering Microsoft Azure SQL Solutions".
Module 1: Introduction to Azure database administration
This module looks at the role of a database administrator in the world of Azure SQL. It also provides some basic information that is relevant to the overall content. This includes an overview of the different SQL Server-based options (SQL Server in a VM, SQL Managed Instance and Azure SQL Database).
Lessons
Module 2: Planning and implementing data platform resources
This module introduces methods for provisioning data platform resources in Azure SQL. You will learn about the options for upgrading and migrating existing SQL databases to Azure. You will learn how to set up Azure resources to host SQL Server on a virtual machine, SQL Managed Instance, and SQL database. You will learn how to determine which options are best based on specific requirements, including High Availability and Disaster Recovery (HADR) requirements. You will learn to calculate resource requirements and understand hybrid approaches.
Lessons
Exercise: Deploying SQL Server on an Azure virtual machine
Exercise: Deploying an Azure SQL database
Module 3: Implementation of a secure environment for a database service
This module examines the practices for backing up your SQL Server database as well as an Azure SQL database. This includes an overview of the different SQL Server-based options as well as the different Azure options for securing Azure SQL Database. participants will learn why security is important when working with databases and explain the authentication options for Azure SQL Database.
Lessons
Exercise: Authorizing access to Azure SQL Database with Azure Active Directory
Exercise: Configuring a server-based firewall rule via the Azure portal
Exercise: Enable Microsoft Defender for SQL and data classification
Module 4: Monitoring and optimizing operating resources
In this module, you will learn about resource optimization for your databases created with either IaaS or PaaS services. The module also covers server and hardware resource monitoring. It will familiarize you with the different tools available for monitoring performance and creating a baseline. You will learn how to interpret performance metrics for the most important resources. You will also learn how to troubleshoot database performance issues with Azure SQL Insights.
Lessons
Exercise: Isolate performance problems through monitoring
Exercise: Recognizing and solving fragmentation problems
Module 5: Optimization of query performance
Query execution plans are perhaps the most important aspect of database performance. Improving poor plans is certainly an area where a small amount of effort can yield large improvements. While hardware issues can limit query performance, improving the hardware usually results in performance gains in the 10-20% range at most. More commonly, database administrators encounter unoptimized queries, outdated or missing statistics, missing indexes, or poor database designs that cause the database engine to do more work than necessary to deliver results for a given query. Improving plans can sometimes lead to performance improvements in the range of 100-200% or even more, meaning that a query can run twice or three times as fast after improving a plan with better indexes or statistics! In this module, you will learn how to analyze the performance of individual queries and identify where improvements can be made.
Lessons
Exercise: Identifying and eliminating blockage problems
Exercise: Recognizing problems in database design
Exercise: Isolate problem areas in poorly performing queries in an SQL database
Module 6: Automating database tasks
A common goal of database administrators in many environments is to automate as many of their repetitive tasks as possible. This can be as simple as using scripts to automate a backup process or as complex as building a fully automated alerting system. This module provides details on automating tasks to simplify the DBA's work. Methods include scheduling tasks for regular maintenance as well as using Elastic Jobs and Azure Automation Runbooks.
Lessons
Exercise: Deploy Azure SQL database with an Azure Resource Manager template
Exercise: Creating a CPU status warning for an SQL server
Exercise: Deploy an automation runbook to automatically recreate indexes
Module 7: Planning and implementing a high availability and disaster recovery solution
Data must be available when the company needs it. This means that the solutions where the data is hosted need to be designed with availability and recoverability in mind. Let's say you work for a company that sells widgets both in-store and online. Your main application uses a highly transactional database for orders. What would happen if the server or platform hosting the transactional database was unavailable or inaccessible for some reason? What impact would this have on the business? With the right solution, the database could be brought back online in a reasonable timeframe and with minimal effort, allowing business operations to continue with little to no impact. This module and associated lab covers the configuration, testing and management of a High Availability and Disaster Recovery (HADR) solution in Azure for both Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS) deployments. This module covers not only the basic requirements, but also the various options available for HADR.
Lessons
Exercise: Configuring georeplication for Azure SQL Database
Exercise: Saving to URL and restoring URL
This intensive training prepares you for:
Exam: " DP-300: Administering Microsoft Azure SQL Solutions " for the
certification: " Microsoft Certified: Azure Database Administrator Associate "
This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.
The target audience for this course is data professionals who manage data and databases and want to learn about managing the data platform technologies available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what data platform technologies are available with Azure and how to work with these technologies through applications. Successful Azure database administrators start this role with professional database administration experience and technical knowledge of cloud technologies.
This is especially true in the following cases:
You should at least be familiar with the information in the following course before attending this course:
Form of learning
Learning form
No filter results
This training is conducted in cooperation with the authorized training organization Digicomp Academy AG.
For the purpose of conducting the training, participants' data will be transmitted to them and processed there under their own responsibility.
Please take note of the corresponding privacy policy.