DP-300T00: Administering Microsoft Azure SQL Solutions DP-300T00

This course provides students with the knowledge and skills to create 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.

Difficulty Level: Intermediate

Product: Azure

Role: Database Administrator

DP-300T00: Administering Microsoft Azure SQL Solutions DP-300T00

Virtual Instructor Led Online Schedule

Virtual Instructor Led Online Schedule

Duration

4 Days

Price

$2,495.00

Interested in group training?

Course Schedule

This green checkmark in the Upcoming Schedule below indicates that this session is Guaranteed to Run.
Start Date - End Date Time

Interested in Private Training?

Course Outline

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.

  • Prepare to maintain SQL Server-based databases on Azure
  • Deploy IaaS solutions with Azure SQL
  • Deploy PaaS solutions with Azure SQL
  • Migrate SQL Server workloads to Azure SQL Database
  • Migrate SQL Server workloads to Azure SQL Managed Instance
  • Configure database authentication and authorization
  • 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 optimization
  • Explore performance-based database design
  • Evaluate performance improvements
  • Automate database deployment
  • 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

Virtual Instructor Led Online Schedule

Duration

4 Days

Price

$2,495.00

Interested in group training?