DP-300T00-A: Implement scalable database solutions using Azure SQL

Course code: NP1896

This intermediate-level course is designed for database administrators and data professionals who manage relational databases in cloud, on-premises, or hybrid environments. Learners will gain hands-on experience in planning, securing, optimizing, and automating Azure SQL database solutions. The course prepares candidates for the Azure Database Administrator Associate certification.

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Guaranteed

Type: Self-paced

Course duration: 32 hours

Language: en

Price without VAT: 285 EUR

Register

Starting date: Upon request

Guaranteed

Type: Self-paced

Course duration: 32 hours

Language: en

Price without VAT: 75 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
G Upon request Self-paced 32 hours en 285 EUR Register
G Upon request Self-paced 32 hours en 75 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course description

Plan Scalable Resources

Design data platforms for performance and growth.

Secure Azure SQL Access

Control permissions and protect database environments.

Optimize & Automate Tasks

Improve query performance and automate admin routines.

Backup & Recovery Strategy

Implement disaster recovery and ensure data resilience.

Course structure

Lesson 1: Plan and Implement Data Platform Resources

Module 1: Prepare to Maintain SQL Server-Based Databases on Azure

Module 2: Deploy IaaS Solutions with Azure SQL

Module 3: Deploy PaaS Solutions with Azure SQL

Module 4: Migrate SQL Server Workloads to Azure SQL Database

Module 5: Migrate SQL Server Workloads to Azure SQL Managed Instance

Lesson 2: Implement a Secure Environment for a Database Service

Module 1: Configure Database Authentication and Authorization

Module 2: Protect Data In-Transit and At Rest

Module 3: Implement Compliance Controls for Sensitive Data

Lesson 3: Monitor and Optimize Operational Resources in Azure SQL

Module 1: Describe Performance Monitoring

Module 2: Configure SQL Server Resources for Optimal Performance

Module 3: Configure Databases for Optimal Performance

Lesson 4: Optimize Query Performance in Azure SQL

Module 1: Explore Query Performance Optimization

Module 2: Explore Performance-Based Database Design

Module 3: Evaluate Performance Improvements

Lesson 5: Automate Database Tasks for Azure SQL

Module 1: Automate Database Deployment

Module 2: Create and Manage SQL Agent Jobs

Module 3: Manage Azure PaaS Tasks Using Automation

Lesson 6: Plan and Implement a High Availability and Disaster Recovery Environment

Module 1: Describe High Availability and Disaster Recovery Strategies

Module 2: Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery

Module 3: Back Up and Restore Databases

Prerequisites

  • Experience with SQL Server and relational databases
  • Familiarity with Azure services and portal usage
  • Understanding of security concepts and access management
  • Basic knowledge of performance tuning and automation

Do you need advice or a tailor-made course?

onas

product support

ComGate payment gateway MasterCard Logo Visa logo