AZ-204T00 Developing Solutions for Microsoft Azure

This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

Course Details

Price:

$2,995.00

Days:

Location:

Virtual

Course Overview

To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces.

Module 1: The Role of the Azure Database Administrator

Azure data platform roles and responsibilities
Overview of Azure database options (SQL Server VM, Managed Instance, Azure SQL Database)
Understanding SQL Server compatibility levels
Azure preview features and additional platforms (PostgreSQL, MySQL)
Lab: Provision a SQL Server VM and restore a backup using Azure Portal and SSMS

Module 2: Plan and Implement Data Platform Resources

Deploying SQL Server using IaaS and PaaS
Hosting PostgreSQL and MySQL on Azure
High availability and disaster recovery (HADR) considerations
Lab: Deploy Azure SQL Database, PostgreSQL, or MySQL; validate connectivity

Module 3: Implement a Secure Environment

Configure authentication and authorization
Implement data protection (at rest and in transit)
Enforce compliance controls
Lab: Set firewall rules, integrate with Azure AD, enable classification and manage object access

Module 4: Monitor and Optimize Operational Resources

Performance monitoring tools and baselining
Diagnosing performance issues
Configuring resources for peak efficiency
Performing performance-related maintenance
Lab: Detect CPU bottlenecks, identify blocking, and fix fragmentation

Module 5: Optimize Query Performance

Analyze and interpret SQL Server query execution plans
Implement performance-driven database design
Evaluate and tune performance improvements
Lab: Use Query Store, isolate slow queries, apply query hints, and redesign schema issues

Module 6: Automation of Tasks

Automate database tasks and scheduled operations
Use Azure automation tools, extended events, and elastic jobs
Lab: Use GitHub ARM templates, set up metric-based alerts, deploy Runbooks

Module 7: Plan and Implement a High Availability and Disaster Recovery Environment

Design HADR for IaaS and PaaS solutions
Understand RTO/RPO requirements
Configure and test failover and disaster recovery plans
Lab: Set up and validate HADR strategies in Azure environments

Class Dates & Times


02/02/2026 - 02/06/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
04/06/2026 - 04/10/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
06/08/2026 - 06/12/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00
12/01/2025 - 12/05/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $2,995.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →