As a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:
- SQL Server on-premises
- Azure SQL services
You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.
As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.
You’re responsible for the following concerning database solutions:
- Management
- Availability
- Security
- Performance monitoring and optimization
You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.
As a candidate for this certification, you should have knowledge of and experience with:
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines (Windows and Linux)
- Plan and implement data platform resources
- Implement a secure environment
- Monitor, configure, and optimize database resources
- Configure and manage automation of tasks
- Plan and configure a high availability and disaster recovery (HA/DR) environment
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.
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies. Specifically:
- Working with, maintaining, and developing with SQL Server
- Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following courses before attending the course:
- Lesson: Understand the role of Azure Database Administrator as it fits in with other data platform roles
- Lesson: Describe the key differences between the SQL Server-based database options in Azure
- Lesson: Describe the main features available on Azure SQL offerings
- Lesson: Deploy resources using manual methods
- Lesson: Recommend an appropriate database offering based on requirements
- Lesson: Configure Azure SQL resources
- Lesson: Evaluate and implement a strategy for moving a database to Azure SQL
- Instructor-led labs: Provision a SQL Server on an Azure Virtual Machine
- Instructor-led labs: Provision an Azure SQL Database
- Lesson: Understand the differences between Windows, SQL Server, and Microsoft Entra authentication
- Lesson: Describe and configure both data-at-rest encryption solutions as well as data-in-transit encryption solutions
- Lesson: Implement a data sensitivity solution
- Instructor-led labs: Authorize Access to Azure SQL Database with Microsoft Entra ID
- Instructor-led labs: Configure a server-based firewall rule using the Azure portal
- Instructor-led labs: Enable Microsoft Defender for SQL and Data Classification
- Lesson: Monitor activity and compare to a baseline
- Lesson: Explore maintenance tasks related to performance
- Lesson: Identify major causes of performance problems
- Lesson: Configure databases and resources for optimal performance
- Instructor-led labs: Isolate performance problems through monitoring
- Instructor-led labs: Detect and correct fragmentation issues
- Lesson: Analyze query plans and identify problem areas
- Lesson: Evaluate potential query improvements
- Lesson: Review table and index design
- Lesson: Determine whether query or design changes have had a positive effect
- Instructor-led labs: Identify and resolve blocking issues
- Instructor-led labs: Identify database design issues
- Instructor-led labs: Isolate problem areas in poorly performing queries in a SQL Database
- Lesson: Automate deployments
- Lesson: Create Scheduled Tasks in SQL Server
- Lesson: Create notifications for failures and performance alerts
- Lesson: Configure automation for PaaS Services
- Instructor-led labs: Deploy an Azure SQL Database using an Azure Resource Manager template
- Instructor-led labs: Create a CPU status alert for an SQL Server
- Instructor-led labs: Deploy an Automation runbook to automatically rebuild indexes
- Lesson: The difference between recovery time and recovery point objectives
- Lesson: The available HADR options
- Lesson: The considerations for planning and configuring HADR solutions including how backup and restore fits in
- Lesson: The factors that comprise a HADR strategy
- Instructor-led labs: Configure geo-replication for Azure SQL Database
- Instructor-led labs: Backup to URL and Restore from URL
Yes, this course helps prepare for exam DP-300 to earn the Microsoft Certified: Azure Database Administrator Associate Certification.
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.
A. Please reach out to info@industechservices.com after your course to obtain your exam voucher.
