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.
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.
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.