This 3/400-level, 2-day, SQL Server training class is designed to help you gain a deep understanding about Microsoft Azure, including Azure virtual machines and Azure SQL Database.
The class will give you a wealth of practical knowledge on creating and configuring Azure virtual machines as well as installing and configuring Microsoft SQL Server on those virtual machines. You’ll learn about compliance, networking, active directory integration, maintenance considerations, high availability and disaster recovery options, and how to scale performance. Various billing considerations and licensing options for SQL Server on Azure virtual machines will be covered in detail.
One student in the first ever IEAzure in 2017 learned how they’d over-estimated their usage and was immediately able to save their company US$48,000/year in Azure costs!
The class will then dive deep into Azure SQL Database, covering its numerous features such as restore services, Dynamic Data Masking, Row-Level Security, Always Encrypted, Query Store, Index Advisor, and Geo-Replication. We’ll also discuss what I call “unsupported features” (things you may be used to the on the box version of SQL Server that Azure SQL Database does not have) and explore the various Azure SQL Database pricing tiers and using the DTU calculator.
You’ll learn how to create Azure SQL Databases and methodologies for migrating your on-premises databases to Azure, different ways of connecting to Azure and methodologies for tuning, plus maintenance considerations and built-in/external monitoring and alerting.
Finally, you’ll get a high-level introduction to additional Azure features such as Azure SQL Database Warehouse, Azure Data Factory, and Power BI.
This course will provide you with enough knowledge and material that when you get back to the office, you’ll feel comfortable to help plan and implement a migration to Azure virtual machines and/or Azure SQL Database.
Instructor: Tim Radney
Module 1: Azure Virtual Machines
Understanding the technical and business benefits of leveraging Azure virtual machines is a critical part of making a decision of whether to migrate to the cloud. Topics covered include:
Module 2: Migrating to Azure Virtual Machines
Migrating to Azure virtual machines shouldn’t be a stressful task. By properly planning, and selecting the correct size of virtual machine, this should be an easy process. Topics covered include:
Module 3: Azure SQL Database
Understanding Azure SQL Database and how it differs from on-premises SQL Server is key to feeling comfortable with migrating production databases to a relational database cloud solution. Topics covered include:
Module 4: Migrating to Azure SQL Database
Migrating to Azure SQL databases isn’t much different than migrating to Azure virtual machines. You need to know your workload and select the correct size of environment. By properly planning and selecting the correct configuration, this should be an easy process. Topics covered include:
Module 5: Additional Azure Features
There is more to the Microsoft Azure platform than just virtual machines and Azure SQL Database. Knowing several of the other key products in Azure can help you build a full data platform solution in the cloud. Topics covered include:
If you have any questions not answered by our F.A.Q., please contact us.