Implement scalable database solutions using Azure SQL (DP-300)

Name: Implement scalable database solutions using Azure SQL (DP-300)
Price: 3450 GBP
Availability: InStock

Description

Title: Implement scalable database solutions using Azure SQL (DP-300)

Location: CA

Company: Learning Tree

This Implement scalable database solutions using Azure SQL (DP-300) certification 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 helpful to individuals who develop applications that deliver content from SQL-based relational databases.

DP-300 Certification Course Delivery Methods

In-Person
Online

DP-300 Certification Course Information

In this Administering Microsoft Azure SQL Solutions (DP-300) course, you will learn how 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.

Administering Microsoft Azure SQL Solutions (DP-300) 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 know the information in the following courses before attending the course:

Introduction to Cloud Infrastructure (AZ-900)
Microsoft Azure Data Fundamentals Training (DP-900)

Administering Microsoft Azure SQL Solutions (DP-300) Exam Information

This course can help you prepare for the following Microsoft role-based certification exam — Exam DP-300: Microsoft Certified: Azure Database Administrator Associate.

DP-300 Certification Course Outline

Learning Objectives

Plan and implement data platform resources

Prepare to maintain SQL Server-based databases on Azure

- Understand the role of Azure Database Administrator as it fits in with other data platform roles.
- Describe the key differences between the SQL Server-based database options in Azure.
- Describe other features for Azure SQL platforms available.

Deploy IaaS solutions with Azure SQL

- Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
- Learn the available options for provisioning and deployment
- Deploy SQL Server into an Azure Virtual Machine

Deploy PaaS solutions with Azure SQL

- Gain an understanding SQL Server in a Platform as a Service (PaaS) offering
- Understand PaaS provisioning and deployment options
- Understand elastic pools
- Examine Azure SQL Managed Instances
- Configure a template for PaaS deployment

Migrate SQL Server workloads to Azure SQL Database

- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
- Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
- Use transactional replication as an online method to migrate to Azure SQL Database.
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Migrate SQL Server workloads to Azure SQL Managed Instance

- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Managed Instance.
- Learn how Log Replay Service works to migrate to Azure SQL Managed Instance.
- Understand how Managed Instance link feature works in a migration scenario.
- Load and move data to and from Azure SQL Managed Instance.
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.

Implement a secure environment for a database service

Configure database authentication and authorization

- Learn about authentication options for Azure SQL
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication and authorization failures

Protect data in-transit and at rest

- Understand the data encryption options available in the various platforms
- Implement object level encryption
- Understand the difference between database and server firewall rules for Azure SQL Database
- Explore Always Encrypted with secure enclaves

Implement compliance controls for sensitive data

- Plan and implement data classification in Azure SQL Database
- Understand and configure row-level security and dynamic data masking
- Understand the usage of Microsoft Defender for SQL
- Explore how Ledger works

Monitor and optimize operational resources in Azure SQL

Describe performance monitoring

- Review potential performance issues.
- Identify critical Azure metrics.
- Learn how to collect metrics for an established baseline.
- Use extended events for performance analysis.
- Understand database watcher for Azure SQL Database and Azure SQL Managed Instance.

Configure SQL Server resources for optimal performance

- Understand your options for configuration of Azure storage
- Learn how to configure TempDB data files in SQL Server
- Learn how to choose the right type of VM for SQL Server workloads
- Understand the use cases and configuration of Resource Governor in SQL Server

Configure databases for optimal performance

- Understand database scoped configuration options
- Understand maintenance tasks related to indexing and statistics
- Understand the features of Intelligent Query Processing (IQP)
- Explore the automatic tuning feature in Azure

Optimize query performance in Azure SQL

Explore query performance optimization

- Generate and save execution plans
- Compare the different types of execution plans
- Understand how and why query plans are generated
- Explain the purpose and benefits of the Query Store
- Investigate the available reports and data in the Query Store

Explore performance-based database design

- Explore normal forms and how they affect database design
- Choose appropriate datatypes for your data
- Evaluate appropriate index types

Evaluate performance improvements

- Determine when changing indexes or defining new ones can affect performance
- Evaluate wait statistics as an aid in finding areas for performance improvement
- Understand how query hints work, and when to use them

Automate database tasks for Azure SQL

Automate database deployment

- Describe the deployment models available on Azure
- Deploy database resources using PowerShell and Azure CLI
- Deploy an Azure Resource Manager template and Bicep
- Understand the difference between multiple command-line options

Create and manage SQL Agent jobs

- Schedule necessary maintenance activities for your databases.
- Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
- Configure alerts based on performance monitor values.

Manage Azure PaaS tasks using automation

- Understand the benefits of Azure policy
- Explore the capabilities of Azure Automation
- Configure elastic jobs
- Use Logic Apps for database workflow

Plan and implement a high availability and disaster recovery environment

Describe High Availability and Disaster Recovery Strategies
Describe recovery time objective (RTO) and recovery point objective (RPO)
Explore high availability and disaster recovery options
Describe Azure high availability and disaster recovery features for Virtual Machines
Describe high availability and disaster recovery for PaaS deployments
Explore high availability and disaster recovery solutions for IaaS
Describe hybrid solutions

Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery

Describe failover clusters in Windows Server
Configure Always On Availability Groups
Describe active geo-replication for Azure SQL Database
Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
Monitor availability
Exercise: Configure geo-replication for Azure SQL Database

Back Up and Restore Databases