DP-300 Administering Relational Databases on Azure training | Arcskill
    Have any questions?
  • +(91) 720 483 9066
  • info@arcskill.com
Courses

DP-300 Administering Relational Databases on Azure training

Skill Level:

Intermediate

Course Start Date:

22-Nov-21

Categories:

Cloud Computing



About
Objective
Course Content
Why Attend
Prerequisites

The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Azure Data Services and SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes. This role is responsible for management, availability, security and performance monitoring and optimization of modern relational database solutions. This role works with the Azure Data Engineer role to manage operational aspects of data platform solutions.


Course Timing

Batch Day's Time Batch Start Date
1 Wednesday-Saturday 11:00PM-07:00PM 30-Nov-2021
2 Monday-Friday 08:30PM-10:30PM 05-Dec-2021
3 Saturday-Sunday 12:00AM-08:00AM 11-Dec-2021

After successful completion of the course, the participants would be able to:

  • Understand the differences between Azure SQL offerings and how best to leverage their features 
  • Implement a secure database environment 
  • Monitor database and server performance 
  • Optimize database and server performance 
  • Automate database tasks 
  • Implement high availability and disaster recovery  
  • Use T-SQL to perform database administration tasks  
  • Deploy resources using automated deployment scripts
  • Create scheduled tasks
  • Create notifications and alerts
  • Configure automation for PaaS services
  • Azure Data platform roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features
  • Using the Azure Portal and SQL Server Management Studio
  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup
  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open-Source Database Solutions on Azure
  • Deploying Azure SQL Database
  • Deploy a VM using an ARM template
  • Configure resources needed prior to creating a database
  • Deploy an Azure SQL Database
  • Register the Azure SQL Database instance in Azure Data Studio and validate connectivity
  • Deploy PostgreSQL or MySQL using a client tool to validate connectivity
  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data
  • Implement a Secure Environment
  • Configure a server-based firewall rule using the Azure Portal
  • Authorize Access to Azure SQL Database with Azure Active Directory
  • Enable Advanced Data Security and Data Classification
  • Manage access to database objects
  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks
  • Monitor and Optimize Resources
  • Isolate CPU Problems
  • Use Query Store observe blocking problems
  • Detect and correct fragmentation issues
  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements
  • Query Performance Troubleshooting
  • Identify issues with database design AdventureWorks2017
  • Isolate problem areas in poorly performing queries in AdventureWorks2017
  • Use Query Store to detect and handle regression in AdventureWorks2017
  • Use query hints to impact performance in AdventureWorks2017
  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods
  • Automating Tasks
  • Deploy an Azure template from a Quickstart template on GitHub
  • Configure notifications based on performance metrics
  • Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database
  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery
  • Plan and Implement a High Availability and Disaster Recovery Environment
  • Create an Always On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL
  • Database Administrators
  • Data Management Specialists
  • Data Architects
  • Application Developers

No prerequisite