What you’ll learn
After completing this course, students will be able to:
Plan and implement data platform resources
Implement a secure environment
Monitor, configure, and optimise database resources
Configure and manage automation of tasks
Plan and configure a high availability and disaster recovery (HA/DR) environment
Microsoft Azure at Lumify Work
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
Who is the course for?
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.
Course subjects
Plan and implement data platform resources
Prepare to maintain SQL databases on Azure
Deploy IaaS solutions with Azure SQL
Deploy PaaS solutions with Azure SQL
Migrate SQL workloads to Azure SQL Databases
Migrate SQL workloads to Azure Managed Instances
Implement a secure environment for a database service
Configure database authentication and authorisation
Protect data in-transit and at rest
Implement compliance controls for sensitive data
Monitor and optimise operational resources in Azure SQL
Describe performance monitoring
Configure SQL Server resources for optimal performance
Configure databases for optimal performance
Optimise query performance in Azure SQL
Explore query performance optimisation
Explore performance-based database design
Evaluate performance improvements
Automate database tasks for Azure SQL
Automate database deployment
Create and manage SQL Agent jobs
Manage Azure PaaS tasks using automation
Plan and implement a high availability and disaster recovery environment
Describe High Availability and Disaster Recovery Strategies
Explore IaaS and PaaS solutions for high availability and disaster recovery
Back up and restore databases
Prerequisites
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 have the below training or equivalent knowledge before attending the course:
FREE E-BOOK: The New Era of Cloud Computing
We've created this e-book to assist you on your cloud journey, from defining the optimal cloud infrastructure and choosing a cloud platform, to security in the cloud and the core challenges in moving to the cloud.
Terms & Conditions
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.