Microsoft DP-300T00 - Administering Microsoft Azure SQL Solutions
Length 4 days
Price
NZD 3250 exc 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.
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 is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.
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:
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.
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
Personalise your schedule with Lumify USchedule
Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.
Microsoft Azure Developer & DOI DevOps Foundation Bundle
This bundle brings together two globally recognised and sought after courses to set you apart from the rest and give you the edge you need to advance your career.