Professional Azure SQL Database Administration

Azure SQL Database is a highly scalable, high performing SQL Server based Managed Cloud Database Service offering from Microsoft. Though Azure SQL Database or SQL Database is the cloud version of SQL Server, however, it differs in management, maintenance and administration. It’s important to know how to administer SQL Database so as to get most out of features that it provides. The course addresses different management aspects of SQL Database such as Migration, Backup and Restore, Pricing, Security, Scalability, Monitoring and Performance Optimization, High Availability and Disaster Recovery.

What you will learn

• Understand Azure SQL Database Configuration and Pricing options
• Provision a new SQL Database or Migrate an existing On-Premise SQL Server database to Azure SQL Database
• Backup and Restore Azure SQL Database
• Secure an Azure SQL Database
• Scale an Azure SQL Database
• Monitor and Tune an Azure SQL Database

Hardware requirements

For an optimal student experience, we recommend the following hardware configuration:

• Processor: 2.6 GHz or higher, preferably multi-core
• Memory: 4GB RAM
• Hard disk: 10GB or more
• An Internet connection

Software requirements

You’ll also need the following software installed in advance:

• Operating System: Windows (8 or higher).
• Google Chrome
• Azure Subscription
• SQL Server Management Studio 17.2 or above
• PowerShell 5.1
• Microsoft Azure PowerShell
• Microsoft RML Utilities
• Visual Studio 2013 or above community edition