Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Administering SQL Server in Azure

Course Summary

The Administering SQL Server in Azure training course is designed to demonstrate the knowledge and skills they need to effectively manage SQL servers in Azure.

The course begins with a comparison of the database administration tasks in an Azure database environment with on-premise environments as well as the characteristics and major differences of on-premises and Azure SQL Server environments. Next, it explores the various Azure database offerings including costs, as well as best practices around scaling, configuration, backups, monitoring. The course concludes with an examination of SLAs, High availability (HA), and disaster recovery (DR).

Purpose
 Learn about how the SQL Server database administrator (DBA) role changes when administering SQL Server in Azure with running SQL Server on Azure Virtual Machines or using Azure SQL Database.
Audience
 Developers and database administrators who manage on-premises SQL Server database environments.
Role
Data Engineer - DevOps Engineer - Software Developer - System Administrator
Skill Level
Introduction
Style
Workshops
Duration
3 Days
Related Technologies
Back-End Development Training | SQL | Cloud Computing Training | Azure

 

Productivity Objectives
  • Explain the major differences of on-premises and Azure SQL Server environments
  • Choose the right database for your application
  • Comprehend pricing and manage costs
  • Run and manage SQL Server database environments successfully in Azure

What You'll Learn:

In the Administering SQL Server in Azure training course, you'll learn:
  • Identify the database administration tasks in an Azure database environment compared to on-premises tasks
  • Characteristics and major differences of on-premises and Azure SQL Server environments
    • (boxed product vs. SQL Server on Azure VM vs. Azure SQL Database vs. Azure SQL Managed Instance)
  • Choosing the right database offering, tiers, and sizes in Azure
  • Pricing and managing costs
  • Upscaling and downscaling resources
  • Configuration and best practices
  • Backup management
  • Monitoring
  • SLAs, High availability (HA), and disaster recovery (DR)
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.