Course DP-300T00-A: Administering Relational Databases on Microsoft Azure

Course Modality

Online

Course Level

Intermediate

Course Time

4 days

Course Language

English

Course Overview

This 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 of use to individuals who develop applications that deliver content from SQL-based relational databases.

Prerequisites

In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:

  • Azure Fundamentals
  • Azure Data Fundamentals

Intended Audience

The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

  • 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

Get In Touch

Course Curriculum

The Role of the Azure Database Administrator

This module explores the role of a database administrator in the world of Azure. It also provides some foundational information relevant to the overall content. This includes a review of the various SQL Server-based options (SQL Server in a VM, Managed Instances, and Azure SQL Database.) Students will learn why compatibility level is a crucial concept when working with SQL databases in Azure. Students are also introduced to other database platforms available on Azure in addition to those based on SQL Server, in particular PostgreSQL and MySQL

Lessons

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

Lab : 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

 

After completing this module, students will:

  • Understand the role of Azure Database Administrator as it fits in with other data platform roles
  • Be able to describe the key differences between the SQL Server-based database op
  • Be able to describe the difference between versions and compatibility levels
  • Know how to enable and disable preview features

Plan and Implement Data Platform Resources

This module introduces methods for deploying data platform resources in Azure. You will learn about options for both upgrading and migrating existing SQL databases to Azure. You will learn how to set up Azure resources to host SQL Server on a Virtual Machine, a Managed Instance, Azure SQL Database and either PostgreSQL or MySQL. You will learn how to determine which options are best based on specific requirements including the High Availability and Disaster Recovery (HADR) needs. They will learn to calculate resource

Recommended Exams

Exam DP-300

Microsoft Certified: Azure Database Administrator Associate

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure