Administering Microsoft Azure SQL Solutions

Inquire now

Administering Microsoft Azure SQL Solutions covers the essential skills required to deploy, secure, monitor, optimize, and maintain Azure SQL databases and managed instances for scalable, high-performance cloud data management.

 

Duration  4 days – 28 hrs

 

Overview

This course teaches concepts and techniques that are crucial for anyone administering SQL Server databases on Microsoft Azure. It also provides content for working with hybrid database systems, on-premises SQL Server installation, and Azure databases. The course assumes that the students have professional experience working with Microsoft SQL Server as a Database Administrator. 

Candidates for this exam should have subject matter expertise in designing, creating, and deploying enterprise-scale database solutions.

 

Objectives

  • Understand the fundamentals of Microsoft Azure SQL solutions and their role in cloud computing.
  • Learn how to deploy and configure Azure SQL databases for optimal performance and scalability.
  • Gain proficiency in managing security and access controls for Azure SQL solutions to ensure data protection and compliance.
  • Explore techniques for monitoring and troubleshooting Azure SQL databases to maintain uptime and reliability.
  • Develop skills in implementing disaster recovery and high availability solutions for Azure SQL databases.
  • Learn best practices for optimizing and tuning Azure SQL databases to meet performance requirements.
  • Understand advanced features and capabilities of Azure SQL solutions for efficient data management and analytics.
  • Prepare for the Microsoft Certified: Azure Database Administrator Associate certification exam (exam DP-300) through hands-on exercises and practical knowledge acquisition.

 

Audience

  • Database Administrators: Professionals responsible for managing and administering databases, both on-premises and in the cloud, who want to expand their skills to include Azure SQL solutions.
  • Cloud Administrators: Individuals tasked with managing cloud resources and services within Microsoft Azure, particularly those related to databases.
  • IT Professionals: Those responsible for maintaining and optimizing database performance, security, and availability in a cloud environment.
  • System Administrators: Professionals involved in configuring, monitoring, and troubleshooting databases and database-related services.
  • Data Engineers: Individuals responsible for designing, building, and maintaining data solutions, including database architecture and management.
  • Developers: Those involved in developing applications that leverage Azure SQL databases, who want to gain a deeper understanding of database administration in Azure.
  • IT Managers: Decision-makers responsible for overseeing database operations and strategic planning within their organization’s IT infrastructure.

 

Pre- requisites 

  • A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals.
  • Experience designing and building scalable databases, configuring, monitoring, and optimizing databases to increase business value using Microsoft SQL Server. For more information see Azure Database Administrator.

 

Course Content

 

Day 1

  • Introduction to Azure Database Administration
  • Plan and implement data platform resources.
  • Lab 1: Provision SQL Server on an Azure Virtual Machine
  • Lab 2: Provision an Azure SQL Database

 

Day 2

  • Implement a secure environment.
  • Lab 3: Authorize access to Azure SQL Database with Microsoft Entra ID
  • Lab 4: Configure a server-based firewall rule using the Azure portal
  • Lab 5: Enable Microsoft Defender for SQL and Data Classification
  • Monitor and optimize operations resources.
  • Lab 6: Isolate performance problems through monitoring
  • Lab 7: Detect and correct fragmentation issues.

 

Day 3

  • Optimize query performance.
  • Lab 8: Identify and resolve blocking issues.
  • Lab 9: Identify database design issues.
  • Lab 10: Isolate problem areas in poorly performing queries in an SQL Database.
  • Automate database tasks.
  • Lab 11: Deploy an Azure SQL Database using an Azure Resource Manager Template.
  • Lab 12: Create a CPU status alert for a SQL Server
  • Lab 13: Deploy an Automation runbook to automatically rebuild indexes.

 

Day 4

  • Plan and implement a high availability and disaster recovery environment.
  • Lab 14: Configure geo-replication for Azure SQL Database
  • Lab 15: Backup to URL and Restore from URL

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy