Data and Analytics - Category Banner

Microsoft DP-300T00 - Administering Microsoft Azure SQL Solutions

  • Length 4 days
  • Price  $3685 inc GST
Course overview
View dates &
book now

Why study this course

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

Request Course Information


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 Solutions Partner - Cloud - Training Services Logo

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:


Microsoft - Training Solutions Partner - Microsoft Certified Trainers - MCT Superstars Award FY24


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.


Request Course Information

Select and book a course

July
October
January
April
July
October
February
May

Can't find a date you like?

Contact sales


Offers

BOGOF 2025: Maximise Value with Microsoft Certifications and Applied Skills
Upskill yourself and your team with our Buy One Get One Free (BOGOF) deals for Microsoft Certification. Book and sit an approved Advanced Role Based course and get a complementary Applied Skills one free. Read the full details below.