What you’ll learn
After completing this course, students will be able to:
Plan, deploy and configure Azure SQL offerings
Monitor database performance and tune a database and queries for optimum performance
Plan and configure a High Availability Solution
Microsoft Azure at Lumify Work
Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.
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
Prepare to maintain SQL databases on Azure
Deploy IaaS solutions with Azure SQL
Deploy PaaS solutions with Azure SQL
Evaluate strategies for migrating to Azure SQL
Migrate SQL workloads to Azure SQL Databases
Migrate SQL workloads to Azure Managed Instances
Configure database authentication and authorisation
Protect data in-transit and at rest
Implement compliance controls for sensitive data
Describe performance monitoring
Configure SQL Server resources for optimal performance
Configure databases for optimal performance
Explore query performance optimisation
Evaluate performance improvements
Explore performance-based design
Automate deployment of database resources
Create and manage SQL Agent jobs
Manage Azure PaaS tasks using automation
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.