Implement Scalable Database Solutions Using Azure SQL (DP-300T00)

HQ6Z0S

Course ID

HQ6Z0S

Duration

4 days

Format

ILT/VILT


Overview

This course provides you with the knowledge and skills to create a SQL server database infrastructure for cloud, on-premises, and hybrid relational databases and to work with the Microsoft PaaS relational database offerings. Additionally, it is useful for anyone who develops applications that deliver content from SQL-based relational databases.

Course ID

HQ6Z0S

Duration

4 days

Format

ILT/VILT


  • Audience

    This course is ideal for professionals who manage data and databases and 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.

  • Objectives

    After completing this course, you should be able to:

    • Plan and implement data platform resources
    • Implement a secure environment for a database service
    • Monitor and optimize operational resources in Azure SQL
    • Optimize query performance in Azure SQL
    • Automate database tasks for Azure SQL
    • Plan and implement a high availability and disaster recovery environment
  • Certifications and related exams

    This course prepares you for Microsoft Certified: Azure Database Administrator Associate certification exam.


Divider
  • Course outline

Module 1: Plan and Implement Data Platform Resources


  • 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

Module 2: Implement a Secure Environment for a Database Service


  • Configure database authentication and authorization
  • Protect data in-transit and at rest
  • Implement compliance controls for sensitive data

Module 3: Monitor and Optimize Operational Resources in Azure SQL


  • Describe performance monitoring
  • Configure SQL Server resources for optimal performance
  • Configure databases for optimal performance

Module 4: Optimize Query Performance in Azure SQL


  • Explore query performance optimization
  • Explore performance-based database design
  • Evaluate performance improvements

Module 5: Automate Database Tasks for Azure SQL


  • Automate database deployment
  • Create and manage SQL Agent jobs
  • Manage Azure PaaS tasks using automation

Module 6: 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

5 reasons to choose HPE as your training partner

  1. Learn HPE and in-demand IT industry technologies from expert instructors.
  2. Build career-advancing power skills.
  3. Enjoy personalized learning journeys aligned to your company’s needs.
  4. Choose how you learn: in-person , virtually , or online —anytime, anywhere.
  5. Sharpen your skills with access to real environments in virtual labs .

Explore our simplified purchase options, including HPE Education Learning Credits .

Recommended for you