DP - 300 : Azure Database Administrator Associate Training

DP - 300 : Azure Database Administrator Associate

This course equips students with the knowledge and skills needed to administer SQL Server database infrastructures in cloud, on-premises, and hybrid environments. It covers the management of relational databases within Microsoft's PaaS offerings, making it valuable for professionals who work with SQL-based relational databases, whether in development or administration.

Audience Profile:

This course is designed for data professionals responsible for managing data and databases who want to learn how to administer the data platform technologies available on Microsoft Azure. It is also beneficial for data architects and application developers who need to understand Azure's data platform technologies and how to integrate them into their applications.

Course Outline:

Module 1: Prepare to maintain SQL databases on Azure

Understand the role of Azure Database Administrator within the data platform
Describe key differences between SQL Server-based options in Azure
Explore other Azure SQL platform features

Module 2: Deploy IaaS solutions with Azure SQL

Learn SQL Server basics in IaaS offerings
Explore provisioning and deployment options
Deploy SQL Server into an Azure Virtual Machine

Module 3: Deploy PaaS solutions with Azure SQL

Configure database authentication and authorization
Implement security for data at rest and in transit
Apply compliance controls for sensitive data

Module 4: Evaluate strategies for migrating to Azure SQL

Monitor baselines and performance
Identify causes of performance issues and optimize resources
Perform performance-related maintenance tasks

Module 5: Migrate SQL Server workloads to Azure SQL Database

Explore migration capabilities of Azure SQL Database
Use Azure Data Studio, Data Migration Assistant, and transactional replication for migrations

Module 6: Migrate SQL workloads to Azure Managed Instances

Evaluate and perform migrations to Azure SQL Database Managed Instance
Load and move data to Managed Instances

Module 7: Configure database authentication and authorization

Learn authentication options and create security principals
Configure permissions and identify authentication failures

Module 8: Protect data in-transit and at rest

Understand encryption options and firewall rules for Azure SQL
Explore Always Encrypted with secure enclaves

Module 9: Implement compliance controls for sensitive data

Plan data classification and implement row-level security
Explore Microsoft Defender for SQL and Azure SQL Database Ledger

Module 10: Describe performance monitoring

Identify potential performance issues and collect metrics
Use Azure SQL Database Intelligent Insights and extended events

Module 11: Configure SQL Server resources for optimal performance

Learn storage and TempDB data file configurations
Choose appropriate VM types and configure Resource Governor

Module 12: Configure databases for optimal performance

Understand database maintenance tasks and Intelligent Query Processing
Explore Azure's automatic tuning features

Module 13: Explore query performance optimization

Generate execution plans and analyze Query Store reports
Understand query plan generation and optimization

Module 14: Evaluate performance improvements

Optimize indexes and use wait statistics for performance enhancement
Understand the use of query hints

Module 15: Explore performance-based design

Learn normal forms and evaluate appropriate datatypes and index types

Module 16: Automate deployment of database resources

Explore deployment models using PowerShell, Azure CLI, ARM templates, and Bicep

Module 17: Create and manage SQL Agent jobs

Schedule maintenance tasks and configure SQL Server Agent job alerts

Module 18: Manage Azure PaaS tasks using automation

Explore Azure Policy, Automation, Logic Apps, and elastic jobs for task automation

Module 19: Describe high availability and disaster recovery strategies

Define recovery objectives and explore HA/DR strategies for IaaS and PaaS

Module 20: Explore IaaS and PaaS solutions for high availability and disaster recovery

Deploy WSFC, AG in Azure, Temporal Tables, and active geo-replication

Module 21: Back up and restore databases

Implement backup and restore options for IaaS and PaaS

(4.7 Ratings)

Download Course Contents

Course Outline PDF

SpireTec Unique Features

1-On-1 Training

Benefit from our 1-On-1 Training for personalized, focused, and effective learning experiences.

Customized Training

Experience our Customized Training service tailored to meet your specific learning needs and goals

4 - Hours / Weekend Session

Join our Class featuring 4 - Hours / Weekend Session for in-depth learning and expert training.

Free Demo Class

Join our Free Demo Class to experience top-notch training and expert guidance first hand!

Purchase This Course

Add Exam

Live Online Training (Duration : 32 Hours)

Guaranteed to run classes as per your convenient time zone

Industry experienced & certified trainers

Query Handling session by technical expert after 2 month completion of training

Career path counselling

Custom tailored training as per the requirement

Exam assistance

Exam Mock papers

100% Quality assurance with certified & industry experienced Traine

4 Hours Week Days

8 Hours Weekends

Live Online Training (Duration : 32 Hours)

Guaranteed to run classes as per your convenient time zone

Industry experienced & certified trainers

Query Handling session by technical expert after 2 month completion of training

Career path counselling

Custom tailored training as per the requirement

Exam assistance

Exam Mock papers

100% Quality assurance with certified & industry experienced Traine

Request More Information

CERTIFICATE

Get Ahead With SpireTec Solutions
Training Certificate

Earn your Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Differentiate yourself with Masters Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Share your achievement

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Need Customized Curriculum?

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Talk To Adviser

Download Course Contents

Audience Profile:

Course Outline:

Module 1: Prepare to maintain SQL databases on Azure

Understand the role of Azure Database Administrator within the data platform
Describe key differences between SQL Server-based options in Azure
Explore other Azure SQL platform features

Module 2: Deploy IaaS solutions with Azure SQL

Learn SQL Server basics in IaaS offerings
Explore provisioning and deployment options
Deploy SQL Server into an Azure Virtual Machine

Module 3: Deploy PaaS solutions with Azure SQL

Configure database authentication and authorization
Implement security for data at rest and in transit
Apply compliance controls for sensitive data

Module 4: Evaluate strategies for migrating to Azure SQL

Monitor baselines and performance
Identify causes of performance issues and optimize resources
Perform performance-related maintenance tasks

Module 5: Migrate SQL Server workloads to Azure SQL Database

Explore migration capabilities of Azure SQL Database
Use Azure Data Studio, Data Migration Assistant, and transactional replication for migrations

Module 6: Migrate SQL workloads to Azure Managed Instances

Evaluate and perform migrations to Azure SQL Database Managed Instance
Load and move data to Managed Instances

Module 7: Configure database authentication and authorization

Learn authentication options and create security principals
Configure permissions and identify authentication failures

Module 8: Protect data in-transit and at rest

Understand encryption options and firewall rules for Azure SQL
Explore Always Encrypted with secure enclaves

Module 9: Implement compliance controls for sensitive data

Plan data classification and implement row-level security
Explore Microsoft Defender for SQL and Azure SQL Database Ledger

Module 10: Describe performance monitoring

Identify potential performance issues and collect metrics
Use Azure SQL Database Intelligent Insights and extended events

Module 11: Configure SQL Server resources for optimal performance

Learn storage and TempDB data file configurations
Choose appropriate VM types and configure Resource Governor

Module 12: Configure databases for optimal performance

Understand database maintenance tasks and Intelligent Query Processing
Explore Azure's automatic tuning features

Module 13: Explore query performance optimization

Generate execution plans and analyze Query Store reports
Understand query plan generation and optimization

Module 14: Evaluate performance improvements

Optimize indexes and use wait statistics for performance enhancement
Understand the use of query hints

Module 15: Explore performance-based design

Learn normal forms and evaluate appropriate datatypes and index types

Module 16: Automate deployment of database resources

Explore deployment models using PowerShell, Azure CLI, ARM templates, and Bicep

Module 17: Create and manage SQL Agent jobs

Schedule maintenance tasks and configure SQL Server Agent job alerts

Module 18: Manage Azure PaaS tasks using automation

Explore Azure Policy, Automation, Logic Apps, and elastic jobs for task automation

Module 19: Describe high availability and disaster recovery strategies

Define recovery objectives and explore HA/DR strategies for IaaS and PaaS

Module 20: Explore IaaS and PaaS solutions for high availability and disaster recovery

Deploy WSFC, AG in Azure, Temporal Tables, and active geo-replication

Module 21: Back up and restore databases

Implement backup and restore options for IaaS and PaaS

SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.

Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.

Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.

It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training.

Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world.

We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.

AZ - 104 : Microsoft Azure Administrator

AZ - 900 : Microsoft Azure Fundamentals

MS - 700 : Managing Microsoft Teams

PL - 200 : Microsoft Power Platform Functional Consultant

PL - 900 : Microsoft Power Platform Fundamentals

SC - 200 : Microsoft Security Operations Analyst

SC - 300 : Microsoft Identity and Access Administrator

PL - 300 : Power BI Data Analyst Associate

DP - 600T00 : Microsoft Fabric Analytics Engineer

MS - 102 : Microsoft 365 Administrator

DP - 601 : Implement a Lakehouse with Microsoft Fabric

M55371A : Windows Server Administration

DP - 602T00 : Implement a Data Warehouse with Microsoft Fabric

DP - 603T00 : Implement Real-Time Intelligence with Microsoft Fabric

DP - 604T00 : Implement a data science and machine learning solution for AI with Microsoft Fabric

DP - 700T00 : Microsoft Fabric Data Engineer

AI - 102 : Designing and Implementing an Azure AI Solution

AI - 900 : Microsoft Azure AI Fundamentals

AI - 103 : Develop Generative AI Solutions with Azure Open AI Service

AI - 3004 : Create computer vision solutions with Azure AI Vision

AI - 3003 : Develop natural language processing solutions with Azure AI Services

AI - 3002 : Develop solutions with Azure AI Document Intelligence

55485 - Microsoft 365 Copilot Super User

M55616A : Microsoft Copilot Overview for IT Professionals

M55604A : Using AI and Copilot in the Microsoft Power Platform

M55618A : Microsoft Copilot for Microsoft 365 for End Users

AI - 3016 : Develop Custom Copilots with Azure AI Studio

Certified Associate in Project Management (CAPM)®

Project Management Professional (PMP)®

Program Management Professional (PgMP)®

PMI Professional in Business Analysis (PMI-PBA)®

PMI Risk Management Professional (PMI-RMP)®

PMI Agile Certified Practitioner (PMI-ACP)®

PRINCE2® Foundation

PRINCE2® Practitioner

Certification of Capability in Business Analysis (CCBA®)

Certified Business Analysis Professional (CBAP®)

Scrum Fundamentals Certified (SFC)

Scrum Product Owner Certified (SPOC®)

SAFe Practice Consultant

Six Sigma Black Belt Certification CSSBB

EC-Council CEH: Certified Ethical Hacker v12

EC-Council CCT : Certified Cybersecurity Technician

EC-Council Certified Incident Handler V3

EC-Council CND: Certified Network Defender v2

EC-Council CTIA: Certified Threat Intelligence Analyst

EC-Council Certified Ethical Hacker (CEH) Master

EC-Council CCSE: Certified Cloud Security Engineer

EC-Council Certified Ethical Hacker (CEH) Practical

EC-Council CCISO: Certified Chief Information Security Officer

EC-Council CHFI: Computer Hacking Forensic Investigator v10

EC-Council ECIH : Certified Incident Handler

ISO 9001 Quality Management System

ISO/IEC 27005 Information Security Risk Management

ISO/IEC 27033 Network Security

ISO/IEC 27035 Information Security Incident Management

ISO 22301 Business Continuity Management System

ISO 22317 Business Impact Analysis

ISO 31000 Risk Management

ISO 37301 Compliance Management System

ISO/IEC 27701 Privacy Information Management System

ISO/IEC 27001 Lead Auditor

ISO/IEC 27001 Foundation

ISO/IEC 42001 Lead Implementer

ISO/IEC 42001 Lead Auditor

ISO 14001 Lead Implementer

ISO 14001 Lead Auditor

ISO 37301 Lead Implementer

ISO 37301 Lead Auditor

ISO 22301 Lead Implementer

ISO 22301 Lead Auditor

Data Protection Essentials

CISSP - Certified Information Systems Security Professional

CCSP – Certified Cloud Security Professional

CGRC – Governance, Risk and Compliance Certification

ISSEP – Information Systems Security Engineering Professional

SSCP – Systems Security Certified Practitioner

CISA - Certified Information Systems Auditor

CISM - Certified Information Security Manager

CRISC - Certified in Risk and Information Systems Control