This 3/400-level, 4-day, SQL Server training class is designed to help you gain a deep understanding about Microsoft Azure, including Azure virtual machines, Azure SQL Database, and Azure SQL Database Managed Instance.
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 on-premises differences 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.
We’ll then dive into Azure SQL Database Managed Instance, Microsoft’s instance-scoped Azure SQL Database offering. We’ll cover Managed Instance features, on-premises and Azure SQL Database differences, tuning options, migration options, and pricing.
The class will then move on to Azure security options. The Azure platform offers numerous tools for monitoring and protecting your data assets. We will explore the Azure Security Center, Operational Insights, Log Analytics, vulnerability assessment, data classification, and threat protection.
You’ll learn about automation and scheduling options that are available within Azure too, covering Azure Automation, Elastic Agent, and discuss how PowerShell can be used to deploy assets.
Finally, you’ll get a high-level introduction to additional Azure features such as Hyper-Scale, Power BI, Azure Data Factory, Azure SQL Database Warehouse, Azure Analysis Services.
This course will provide you with enough knowledge and material that when you get back to the office, you’ll feel comfortable to planning and implementing a migration to one or all of Azure virtual machines, Azure SQL Database, and Azure SQL Database Managed Instance.
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.
If you have any questions, please contact us.