Azure SQL Database is the cloud version of SQL Server. It differs in terms of management, maintenance and administration. It’s important to know how to administer SQL Database so that you can get the most out of the features that it provides. You will learn different management aspects of an Azure SQL Database, such as migration, backup and restoration, pricing, security, scalability, monitoring and performance optimization, high availability and disaster recovery. You’ll start by understanding the architecture of the Azure SQL Database and its service tiers. Through a narrative of a DBA, who is migrating from a traditional on-premises system to Azure SQL Database, this course will explain the concepts by using different scenarios you might come across while working with Azure SQL Database. If you are interested in developing new or migrating existing applications with Azure SQL Database, then this course is for you.
- Build a new Azure SQL Database or migrate to it from an on-premise SQL Database
- Backup, restore, secure, and scale an Azure SQL Database
- Monitor and tune an Azure SQL Database
- Implement the high availability and disaster recovery features
- Automate common management tasks with PowerShell
- Develop a scalable cloud solution with SQL Database
For an optimal student experience, we recommend the following hardware configuration:
- Processor: Intel Core i5 or equivalent, preferably multi-core
- Memory: 8GB RAM
- Hard disk: 20GB or more
- An Internet connection
You’ll also need the following software installed in advance:
- Operating System: Windows (8 or higher)
- Browser: Latest version of Google Chrome
- SQL Server Management Studio 17.2 or above
- Microsoft Azure PowerShell
- Microsoft RML Utilities
- Microsoft® Data Migration Assistant v3.4
- SQL Server 2016 Feature pack