DP-300: Administering Relational Databases on Microsoft Azure
In this course you will learn how to plan and implement data platform resources, implement a secure environment and monitor and optimize operational resources. This course will also cover how to optimize query performance, perform automation of tasks and plan and implement a High Availability and Disaster Recovery (HADR) Environment. This course will help you to prepare to pass the Microsoft certification exam DP-300 Administering Relational Databases on Microsoft Azure.
- Duration: 4 days
- Level: 300
Who this course is designed for
- Database Administrators
What You Will Learn
- 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
- Azure Fundamentals
- Azure Data Fundamentals
Module 01 - Deploy Resources by Using Manual Methods
In this module you will learn how to deploy database offerings on selected platforms, configure customized deployment templates and apply patches and updates for hybrid and IaaS deployment.
Module 02 - Recommend an Appropriate Database Offering Based on Specific Requirements
In this module you will learn how to evaluate requirements for the deployment, evaluate the functional benefits/impact of possible database offerings, evaluate the scalability of the possible database offering, evaluate the HA/DR of the possible database offering and evaluate the security aspects of the possible database offering.
Module 03 - Configure Resources for Scale and Performance
In this module you will learn how to configure Azure SQL database/elastic pools for scale and performance, Azure SQL managed instances for scale and performance and SQL Server in Azure VMs for scale and performance. You will also learn how to calculate resource requirements and evaluate database partitioning techniques, such as database sharding.
Module 04 - Evaluate a strategy for moving to Azure
In this module you will learn how to evaluate requirements for the migration, offline or online migration strategies, requirements for the upgrade and offline or online upgrade strategies.
Module 05 - Implement a Migration or Upgrade Strategy for Moving to Azure
In this module you will learn how to implement an online migration strategy, an offline migration strategy, an online upgrade strategy and an offline upgrade strategy.
Module 06 - Configure Database Authentication by Using Platform and Database Tools
In this module you will learn how to configure Azure AD authentication, create users from Azure AD identities and configure security principals.
Module 07 - Configure Database Authorization by Using Platform and Database Tools
In this module you will learn how to configure database and object-level permissions using graphical tools and apply principle of least privilege for all securables.
Module 08 - Implement Security for Data At Rest
In this module you will learn how to implement Transparent Data Encryption (TDE), implement object-level encryption, implement Dynamic Data Masking and implement Azure Key Vault and disk encryption for Azure VMs.
Module 09 - Implement Security for Data In Transit
This module will cover how to configure SQL DB and database-level firewall rules, implement Always Encrypted and configure Azure Data Gateway.
Module 10 - Implement Compliance Controls for Sensitive Data
In this module you will learn how to apply a data classification strategy, configure server and database audits, implement data change tracking and perform vulnerability assessments.
Module 11 - Monitor Activity and Performance
In this module you will learn how to prepare an operational performance baseline, determine sources for performance metrics and interpret performance metrics. This module will also cover how to assess database performance by using Azure SQL Database Intelligent Performance as well as configure and monitor activity and performance at the infrastructure, server, service, and database levels.
Module 12 - Implement Performance-Related Maintenance Tasks
In this module you will learn how to implement index and statistics maintenance tasks, configure database auto-tuning, automate database maintenance tasks and manage storage capacity.
Module 13 - Identify Performance-Related Issues
In this module you will learn how to configure Query Store to collect performance data, identify sessions that cause blocking, assess growth/fragmentation of databases and logs and assess performance-related database configuration parameters.
Module 14 - Configure Resources for Optimal Performance
In this module you will learn how to configure storage and infrastructure resources, configure server and service account settings for performance and configure Resource Governor for performance.
Module 15 - Configure a User Database for Optimal Performance
In this module you will learn how to implement database-scoped configuration, configure compute resources for scaling and configure Intelligent Query Processing (IQP).
Module 16 - Review Query PlansIn this module you will learn how to determine the appropriate type of execution plan, identify problem areas in execution plans and extract query plans from the Query Store.
Module 17 - Evaluate Performance Improvements
In this module you will learn how to determine the appropriate Dynamic Management Views (DMVs) to gather query performance information, identify performance issues using DMVs and identify and implement index changes for queries. This module will also cover how to recommend query construct modifications based on resource usage and assess the use of hints for query performance.
Module 18 - Review Database Table and Index Design
In this module you will learn how to identify data quality issues with duplication of data, identify normal form of database, assess index design for performance and validate data types defined for columns. You will also learn how to recommend table and index storage including filegroups, evaluate table partitioning strategy and evaluate the use of compression for tables and indexes.
Module 19 - Create Scheduled Tasks
In this module you will learn how to manage schedules for regular maintenance jobs, configure multi-server automation and configure notifications for task success/failure/non-completion.
Module 20 - Evaluate and Implement an Alert and Notification Strategy
In this module you will learn how to create event notifications based on metrics, create event notifications for Azure resources, create alerts for server configuration changes and create tasks that respond to event notifications.
Module 21 - Manage and Automate Tasks in Azure
In this module you will learn how to perform automated deployment methods for resources, automate Backups, automate performance tuning and patching and implement policies by using automated evaluation modes.
Module 22 - Recommend an HADR Strategy for a Data Platform Solution
In this module you will learn how to recommend HADR strategy based on RPO/RTO requirements, evaluate HADR for hybrid deployments, evaluate Azure-specific HADR solutions, and identify resources for HADR solutions.
Module 23 - Test an HADR Strategy by Using Platform, OS and Database Tools
In this module you will learn how to test HA by using failover and test DR by using failover or restore.
Module 24 - Perform Backup and Restore a Database by Using Database Tools
In this module you will learn how to perform a database backup with options, perform a database restore with options, perform a database restore to a point in time and configure long-term backup retention.
Module 25 - Configure DR by Using Platform and Database Tools
In this module you will learn how to configure replication and configure Azure Site Recovery for a database offering.
Module 26 - Configure HA Using Platform, OS and Database Tools
In this module you will learn how to create an Availability Group, integrate a database into an Availability Group, configure quorum options for a Windows Server Failover Cluster and configure an Availability Group listener.
Module 27 - Examine System Health
In this module you will learn how to evaluate database and server health using DMVs and perform database consistency checks by using DBCC.
Module 28 - Monitor Database Configuration by Using T-SQL
In this module you will learn how to assess proper database autogrowth configuration, report on database free space and review database configuration options.
Module 29 - Perform Backup and Restore a Database by Using T-SQL
In this module you will learn how to prepare databases for AlwaysOn Availability Groups, perform transaction log backup, perform restore of user databases and perform database backups with options.
Module 30 - Manage Authentication by Using T-SQL
This module will cover how to manage certificates and security principals.
Module 31 - Manage Authorization by Using T-SQL
In this module you will learn how to configure permissions for users to access database objects and configure permissions by using custom roles.