Clientele ➞

Microsoft Azure Certification BootCamp for DP-300 (Administering Relational Databases on Microsoft Azure)

DP-300

Duration: 4 Days

Description

This BootCamp course from CloudThat is designed to help candidates pass the Microsoft DP-300 certification exam to become Microsoft certified Azure Database Administrator Associate.

This course teaches  candidates how to administer a SQL Server database infrastructure for Cloud, on-premises and hybrid relational databases and work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

The Azure Database Administrator is responsible for the 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.

Why should you get DP-300 certification?

  • By earning DP-300 certification, you will show your future or current employer that you are capable of  implementing and managing the operational aspects
...Read more

Objectives

After completing this course, students will be able 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

Who Should Attend

  • Data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure
  • Data Architects
  • Application Developers

Prerequisites

Should have basic knowledge of:

  • Azure Fundamentals
  • Azure Data Fundamentals

Course Outline

Module 1: The Role of the Azure Database Administrator Lessons:

  • Azure Data Platform Roles
  • Azure Database Platforms and Options
  • SQL Server Compatibility Levels
  • Azure Preview Features

Hands-On: Using the Azure Portal and SQL Server Management Studio Hands-On: Provision a SQL Server on an Azure Virtual Machine Hands-On: Connect to SQL Server and Restore a Backup Module 2: Plan and Implement Data Platform Resources Lessons:

  • Deploying SQL Server using IaaS
  • Deploying SQL Server using PaaS
  • Deploying Open Source Database Solutions on Azure

Hands-On: Deploying Azure SQL Database Hands-On: Deploy a VM using an ARM template Hands-On: Configure resources needed prior to creating a database Hands-On: Deploy an Azure SQL Database Hands-On: Register the Azure SQL Database instance in Azure Data Studio and validate connectivity Hands-On: Deploy PostgreSQL or MySQL using a client tool to validate connectivity Module 3: Implement a Secure Environment Lessons:

  • Configure Database Authentication
  • Configure Database Authorization
  • Implement Security for Data at Rest
  • Implement Security for Data in Transit
  • Implement Compliance Controls for Sensitive Data

Hands-On: Implement a Secure Environment Hands-On: Configure a server-based firewall rule using the Azure Portal Hands-On: Authorize Access to Azure SQL Database with Azure Active Directory Hands-On: Enable Advanced Data Security and Data Classification Hands-On: Manage access to database objects Module 4: Monitor and Optimize Operational Resources Lessons:

  • Baselines and Performance Monitoring
  • Major Causes of Performance Issues
  • Configuring Resources for Optimal Performance
  • User Database Configuration
  • Performance-related Maintenance Tasks

Hands-On: Monitor and Optimize Resources Hands-On: Isolate CPU Problems Hands-On: Use Query Store observe blocking problems Hands-On: Detect and correct fragmentation issues Module 5: Optimize Query Performance Lessons:

  • Understanding SQL Server Query Plans
  • Explore Performance-based Database Design
  • Evaluate Performance Improvements

Hands-On: Query Performance Troubleshooting Hands-On: Identify issues with database design AdventureWorks2017 Hands-On: Isolate problem areas in poorly performing queries in AdventureWorks2017 Hands-On: Use Query Store to detect and handle regression in AdventureWorks2017 Hands-On: Use query hints to impact performance in AdventureWorks2017 Module 6: Automation of Tasks Lessons:

  • Setting up Automatic Deployment
  • Defining Scheduled Tasks
  • Configuring Extended Events
  • Managing Azure PaaS resources Using Automated Methods

Hands-On: Automating Tasks Hands-On: Deploy an Azure template from a Quickstart template on GitHub Hands-On: Configure notifications based on performance metrics Hands-On: Deploy an Azure Automation Runbook (or elastic job) to rebuild indexes on an Azure SQL Database Module 7: Plan and Implement a High Availability and Disaster Recovery Environment Lessons:

  • High Availability and Disaster Recovery Strategies
  • IaaS Platform and Database Tools for HADR
  • PaaS Platform and Database Tools for HADR
  • Database Backup and Recovery

Hands-On: Plan and Implement a High Availability and Disaster Recovery Environment Hands-On: Create an Always On Availability Group Hands-On: Enable Geo-Replication for Azure SQL Database Hands-On: Backup to URL and Restore from URL

About the Trainer

A Certified Microsoft Azure Trainer

Other Details

Questions? For latest batch dates, fees, location and general inquiries, contact our sales team at: +91 8880002200 or email at sales@cloudthat.in

Upcoming Batches

India Online Enroll
  • 28 Oct, 2020 - 31 Oct, 2020 (Wed - Sat)
  • 31 Oct, 2020 - 8 Nov, 2020 (Sat - Sun)
  • Quick Inquiry: Microsoft Azure Courses




    Our Partners