Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

Administering Relational Database on Microsoft Azure (DP-300)

( Duration: 4 Days )

This Administering Relational Database on Microsoft Azure (DP-300) training course provides the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and work with the Microsoft PaaS relational database offerings.

By attending Administering Relational Database on Microsoft Azure (DP-300) workshop, delegates will learn:

  • Planning and Implementation of Data Platform Resources: The first module covers the best practices to deploy resources using manual methods, how to recommend a valid database offering when stringent requirements are expressed, how to best configure resources around business scaling and performance, the best strategies to integrate while migrating to Azure and finally, how to best introduce a strategy around the same.
  • Implementation of A Secure Environment: One of the biggest concerns around databases and information management revolves around data security. This module covers how to best configure database authorization using both the platform and database tools, the best way to implement security for data both in transit and at rest and finally, the best practices to ensure compliance controls are actively used when dealing with sensitive data.
  • Monitor and Optimize Operational Resources : Maintaining consistent performance is just as critical as introducing the right solution. This module covers how students should keep a close eye on activity and performance while implementing performance-related maintenance tasks, identifying performance-related issues, and configuring resources and the user database for optimal performance.
  • Optimization of Query Performance: Students learn to review query plans, evaluate performance improvements, and review database table and index design to ensure all relevant features and changes are working cohesively with the database.
  • Performing Automation of Tasks: Automation sits at the forefront of many business strategies today. Automation offers improved efficiency and effectiveness. This module covers how to create scheduled tasks, introduce alert and notification strategies and introduce the best methods to automate tasks within Azure.
  • Planning and Implementation around High Availability and Disaster Recovery (HADR) Environment: Within this module, students learn how to recommend a HADR strategy for data platform solutions, test the same strategy using platforms and database tools, perform backups, and configure the HA/DR.
  • Performing Administration Using T-SQL : The final module within the examination unit allows students to understand system health, introduce configurations using T-SQL, monitor database configurations, perform backups and manage both authenticity and authorization using T-SQL.

  • Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.
  • Working with, maintaining, and developing with SQL Server
  • Experience with Azure, such as deploying and managing resources

The Administering Relational Database on Microsoft Azure (DP-300) class is ideal for:

  • Database Administrators
  • Data Management Specialists
  • Azure Data Engineers
  • Any professional entering an organization in an operational management capacity across data platform solutions
  • Professionals who are looking to clear their DP-300 certification exam

COURSE AGENDA

1

The Role of the Azure Database Administrator

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features
  • Provision a SQL Server on an Azure Virtual Machine
  • Connect to SQL Server and Restore a Backup
2

Plan and Implement Data Platform Resources

  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open Source Database Solutions on Azure
  • 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
3

Implement a Secure Environment

  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data
  • 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
4

Monitor and Optimize Operational Resources

  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks
  • Isolate CPU Problems
  • Use Query Store observe blocking problems
  • Detect and correct fragmentation issues
5

Optimize Query Performance

  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements
  • 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
6

Automation of Tasks

  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods
  • 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
7

Plan and Implement a High Availability and Disaster Recovery Environment

  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery
  • Create an Always On Availability Group
  • Enable Geo-Replication for Azure SQL Database
  • Backup to URL and Restore from URL

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top