Azure SQL Database Administration

Learn the Microsoft Azure SQL Database

20 hours
Manoj S. Mahajan, Senior IT trainer view profile »
Rs. 13900 ($235) *Get 30% discount this month! Pay Rs. 9730 ($165)
For Indian students: Pay using NEFT/IMPS
International Students, Use PayPal: Please read our refund policy »
Microsoft Azure SQL DBA training in India Rated 4.5/5 based on 997 reviews
Best Microsoft Azure SQL training Pune, Pimpri Chinchwad, India

Microsoft Azure SQL Database (formerly SQL Azure or Windows Azure SQL Database) is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change.

This training course covers the Azure SQL Database architecture in detail and helps you to provision Azure SQL Database and Migrate a SQL Server Database to an Azure SQL. You will learn to manage the DBA activities like: Backing Up and restoring, Securing, High Availability and Disaster Recovery, Monitoring Azure SQL - the cloud database.

Prerequisites

  • Basic knowledge of Windows OS
  • No SQL Server knowledge required

Syllabus

Following topics will get covered in this training:

Microsoft Azure SQL Database Introduction
  • What is Microsoft Azure SQL Database
  • Why Azure SQL Database
  • Azure SQL Database Architecture

Migrating a SQL Server Database to an Azure SQL Database
  • Migrating a SQL Server Database to an Azure SQL Database
  • Finding the Migration Benefits
  • Finding the Blockers
  • Selecting a Service Model
  • Selecting a Service Tier
  • Selecting the Main and Disaster Recovery Region
  • Selecting a Migration Tool
  • Azure SQL Database Service Tiers
  • Determining an Appropriate Service Tier
  • Determining Compatibility Issues
  • Determining the Migration Method

Backing Up the Azure SQL Database
  • Backing Up the Azure SQL Database
  • Automatic Backups
  • Manual Backups

Restoring an Azure SQL Database
  • Restoring an Azure SQL Database
  • Restore Types

Securing an Azure SQL Database
  • Securing an Azure SQL Database
  • Access Control
  • Proactive Security

Scaling Out Azure SQL Database
  • Scaling Out Azure SQL Database
  • Vertical Scaling
  • Horizontal Scaling

Elastic Pools
  • Introducing Elastic Pools
  • Elastic Jobs

High Availability and Disaster Recovery
  • High Availability
  • Disaster Recovery

Monitoring and Tuning Azure SQL Database
  • Monitoring and Tuning Azure SQL Database
  • Monitoring an Azure SQL Database using the Azure Portal
  • Tuning an Azure SQL Database

Student Testimonials

Questions?

Key Features

Best Windows Server 2016 training in Pune
Contact us