Skip to main content
  • 4.7
  • 5.0

Official Learning Partner

As a candidate for this exam, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:

  • SQL Server on-premises
  • Azure SQL services

You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.

As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.

You’re responsible for the following concerning database solutions:

  • Management
  • Availability
  • Security
  • Performance monitoring and optimization

You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.

As a candidate for this exam, you should have knowledge of and experience with:

  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines (Windows and Linux)

Skills Measured

Audience profile

As a candidate for this exam, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with:

  • SQL Server on-premises
  • Azure SQL services

You’re a database administrator who manages on-premises and cloud databases built with SQL Server and Azure SQL services.

As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and Azure SQL services. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes.

You’re responsible for the following concerning database solutions:

  • Management
  • Availability
  • Security
  • Performance monitoring and optimization

You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.

As a candidate for this exam, you should have knowledge of and experience with:

  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure Virtual Machines (Windows and Linux)

Skills at a glance

  • Plan and implement data platform resources (20–25%)
  • Implement a secure environment (15–20%)
  • Monitor, configure, and optimize database resources (20–25%)
  • Configure and manage automation of tasks (15–20%)
  • Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)

Plan and implement data platform resources (20–25%)

Plan and deploy Azure SQL solutions

  • Deploy database offerings on selected platforms
  • Understand automated deployment
  • Apply patches and updates for hybrid and infrastructure as a service (IaaS) deployment
  • Deploy hybrid SQL Server solutions
  • Recommend an appropriate database offering based on specific requirements
  • Evaluate the security aspects of the possible database offering
  • Recommend a table partitioning solution
  • Recommend a database sharding solution

Configure resources for scale and performance

  • Configure Azure SQL Database for scale and performance
  • Configure Azure SQL Managed Instance for scale and performance
  • Configure SQL Server on Azure Virtual Machines for scale and performance
  • Configure table partitioning
  • Configure data compression

Plan and implement a migration strategy

  • Evaluate requirements for the migration
  • Evaluate offline or online migration strategies
  • Implement an online migration strategy
  • Implement an offline migration strategy
  • Perform post migration validations
  • Troubleshoot a migration
  • Set up SQL Data Sync for Azure
  • Implement a migration to Azure
  • Implement a migration between Azure SQL services

Implement a secure environment (15–20%)

Configure database authentication and authorization

  • Configure authentication by using Active Directory and Microsoft Entra ID
  • Create users from Microsoft Entra ID identities
  • Configure security principals
  • Configure database and object-level permissions using graphical tools
  • Apply the principle of least privilege for all securables
  • Troubleshoot authentication and authorization issues
  • Manage authentication and authorization by using T-SQL

Implement security for data at rest and data in transit

  • Implement transparent data encryption (TDE)
  • Implement object-level encryption
  • Configure server- and database-level firewall rules
  • Implement Always Encrypted
  • Configure secure access
  • Configure Transport Layer Security (TLS)

Implement compliance controls for sensitive data

  • Apply a data classification strategy
  • Configure server and database audits
  • Implement data change tracking
  • Implement dynamic data masking
  • Manage database resources by using Azure Purview
  • Implement database ledger in Azure SQL
  • Implement row-level security
  • Configure Microsoft Defender for SQL

Monitor, configure, and optimize database resources (20–25%)

Monitor resource activity and performance

  • Prepare an operational performance baseline
  • Determine sources for performance metrics
  • Interpret performance metrics
  • Configure and monitor activity and performance
  • Monitor by using SQL Insights
  • Monitor by using Extended Events

Monitor and optimize query performance

  • Configure Query Store
  • Monitor by using Query Store
  • Identify sessions that cause blocking
  • Identify performance issues using dynamic management views (DMVs)
  • Identify and implement index changes for queries
  • Recommend query construct modifications based on resource usage
  • Assess the use of query hints for query performance
  • Review execution plans

Configure database solutions for optimal performance

  • Implement index maintenance tasks
  • Implement statistics maintenance tasks
  • Implement database integrity checks
  • Configure database automatic tuning
  • Configure server settings for performance
  • Configure Resource Governor for performance
  • Implement database-scoped configuration
  • Configure compute and storage resources for scaling
  • Configure intelligent query processing (IQP)

Configure and manage automation of tasks (15–20%)

Create and manage SQL Server Agent jobs

  • Manage schedules for regular maintenance jobs
  • Configure job alerts and notifications
  • Troubleshoot SQL Server Agent jobs

Automate deployment of database resources

  • Automate deployment by using Azure Resource Manager templates (ARM templates) and Bicep
  • Automate deployment by using PowerShell
  • Automate deployment by using Azure CLI
  • Monitor and troubleshoot deployments

Create and manage database tasks in Azure

  • Create and configure elastic jobs
  • Create and configure database tasks by using automation
  • Configure alerts and notifications on database tasks
  • Troubleshoot automated database tasks

Plan and configure a high availability and disaster recovery (HA/DR) environment (20–25%)

Recommend an HA/DR strategy for database solutions

  • Recommend HA/DR strategy based on Recovery Point Objective/Recovery Time Objective (RPO/RTO) requirements
  • Evaluate HA/DR for hybrid deployments
  • Evaluate Azure-specific HA/DR solutions
  • Recommend a testing procedure for an HA/DR solution

Plan and perform backup and restore of a database

  • Recommend a database backup and restore strategy
  • Perform a database backup by using database tools
  • Perform a database restore by using database tools
  • Perform a database restore to a point in time
  • Configure long-term backup retention
  • Backup and restore a database by using T-SQL
  • Backup and restore to and from cloud storage

Configure HA/DR for database solutions

  • Configure active geo-replication
  • Configure an Always On availability group
  • Configure auto-failover groups
  • Configure quorum options for a Windows Server Failover Cluster
  • Configure Always On Failover Cluster Instances on Azure virtual machines
  • Configure log shipping
  • Monitor an HA/DR solution
  • Troubleshoot an HA/DR solution

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Technical FAQs

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL ServerT-SQLSQL Server DBA and MSBI (SSISSSASSSRS) Courses. All our training services are completely practical and real-time.CREDITS of SQL School Training Center

  • We are Microsoft Partner. ID# 4338151
  • ISO Certified Training Center
  • Completely dedicated to Microsoft SQL Server
  • All trainings delivered by our Certified Trainers only
  • One of the few institutes consistently delivering the trainings for more than 8+ Years online as inhouse
  • Real-time projects in
    • Healthcare
    • Banking
    • Insurance
    • Retail Sales
    • Telecom
    • ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last EIGHT years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even aftrer the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register.html. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance
×