Implementing Microsoft Azure Data Platform Services
Cloud computing is the most happening technology today. Most enterprises have either migrated to cloud or are in the process for some or all of their important mission critical applications. This 40-hour course is designed to give you the right amount of knowledge to design and implement cloud data platform solutions. The course has advanced coverage of designing, implementing, managing, securing, automating SQL Server on Azure VM and Azure SQL Database deployments. The course also covers Azure SQL Data Warehouse and DocumentDB. The course will help you to prepare for Microsoft Certification 70-473, Designing and Implementing Cloud Data Platform Solutions. Overall, this is the most detailed, advanced & comprehensive training on Azure Data Platform.
All Master Class participants will get a 1-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library during this period.
Read Master Class Testimonials
| Course Code | PI_SQL_104 | |
| Course Title | Implementing Microsoft Azure Data Platform Services | |
| Course Brochure | Download  | |
| Delivery Format | In-Person (Classroom-based). Learn more about our In-Person Delivery Model | |
| Date, Time & Duration | To Be Announced Later | |
| List Price | To Be Announced Later | |
| Level | 300-400 (Advanced to Expert) | |
| Target Audience | This course is intended for SQL Server Database Administrators, Application Developers, SQL Database Engineers, SQL Architects and Cloud Solution Architects. | |
| Prerequisites | This course requires that participants have at least 1 to 2 years of genuine experience with SQL Server database engine. This course is not meant for Fresher | |
| Trainer/Instructor | SQLMaestros Trainer | |
- The most advanced Microsoft Azure Data Platform Services.
- 40 hours of deep-dive learning
- Exclusive, level 300/400 content
- Packed with real-world scenarios and examples
- Get your own copy of SQLMaestros course material developed by SQLMaestros Trainer
Module 1: Introduction to Microsoft Azure
Introduction to cloud computing, service models, platform as a service, infrastructure as a service, software as a service, azure services, networking, compute offerings, data management offerings, developer services, backup, identity and access, azure architecture and more!!!
Module 2: Azure Storage
Coverage Includes: Storage types, Blob Storage, Table Storage, Queue and File Storage, premium storage, best practices, Azure storage architecture internals and more!!!
Module 3: Azure Networking
Introduction to Azure Networking, Site-to-Site and Point-To-Site Connections, Azure AD Connect, Traffic Manager, Virtual Private Network, load balancer, DNS and more!!!
Module 4: Deploying SQL Server on Azure VMs
Provision SQL Server in an Azure VM, configure firewall rules, configure and optimize storage, migrate an on-premises database to Microsoft Azure, configure and optimize VM sizes by workload, automated deployment and configuration management, virtual machine networking and more!!!
Module 5: Securing SQL Server on Azure VM
Configure firewalls, manage logins, users and roles, assign permissions, configure auditing, configure transparent database encryption and more!!!
Module 6: Performance Tuning SQL Server on Azure VMs
Monitor database and instance activity, monitor using dynamic management views (DMVs) and dynamic management functions (DMFs), monitor performance and scalability, Data Files on Azure Blobs, Operational Insights, understanding performance, tempdb, database settings, data disks, storage, network, compute, best practices and more!!!
Module 7: SQL Server Backup to Azure Storage
Managed backups, snapshot backups, native backups, securing backups and more!!!
Module 8: SQL Server High Availability and Disaster Recovery for SQL Server on Azure VM
Implementing high availability solution using Configuring Always On Availability groups, database mirroring, implementing disaster recovery solution using Always On, Availability groups, database mirroring, backup and restore with storage blobs, hybrid disaster recovery solutions using Always On Availability groups, database mirroring, log shipping, and backup and restore to Azure Blob Storage and more!!!
Module 9: Implementing Hybrid Solution
Hybrid model architecture, backups to Azure Storage, Smart Backups, SQL Server files in Azure Storage, Always On Configuration on Azure VM and more!!!
Module 10: Introduction to Azure SQL Database
Azure SQL Database Architecture, Tenant and Control ring, service tiers, management tools and more!!!
Module 11: Design and Implement an Azure SQL Database
Design a solution architecture, design Geo/DR topology, design a security architecture, design a data load strategy, determine the appropriate service tier, Provision SQL Database, configure firewall rules, configure active geo-replication, configure for scale and performance and more!!!
Module 12: Migrating to Azure SQL Database
Test and fix compatibility issues, migrate using SQL Server Data Tools for Visual Studio, SqlPackage, SQL Server Management Studio, SQL Azure Migration Wizard, transactional replication, data sync and copy database and more!!!
Module 13: Securing Azure SQL Database
Configure firewalls, manage logins, users, and roles, assign permissions, configure auditing, configure row-level security, configure data encryption, configure data masking, configure Always Encrypted and more!!!
Module 14: Monitoring and Tuning Azure SQL Database
Understanding DTUs, choosing the performance level, monitor Azure SQL Database using Azure Portal, DMVs and Catalog Views and Extended Events, Index Advisor, Query Performance Insights and more!!!
Module 15: Azure SQL Database In-Memory Optimization
In-Memory OLTP tables, indexes, internals, performance benefits, usage scenarios, Clustered Columnstore Indexes, Non-Clustered Columnstore Indexes, In-Memory OLTP and Columnstore Indexes and more!!!
Module 16: Scaling Azure SQL Database
Horizontal and Vertical Scaling, Sharding, Multi-Tenancy and Single-Tenancy, elastic tools, elastic database client library, split-merge tool, elastic database jobs, elastic database query, elastic transactions and more!!!
Module 17: Azure SQL Database High Availability and Disaster Recovery
Coverage Includes: Automatic Backups, Local redundancy, Point-In-Time Restore, Geo-Restore, Geo-Replication, SQL Server Replication and more!!
Module 18: SQL Server Stretch Database
Concepts, benefit, architecture, configuration, management, limitation of Stretch Database
Module 19: Azure SQL Data Warehouse
Overview, creating and managing Azure SQL DW, Integration with Azure ecosystem, loading, migration, performance and more!!!
Module 20: Automation and Management of SQL Databases with PowerShell
Manage SQL Server in Azure VMs with PowerShell, manage Azure SQL Database with PowerShell, configure Automation and Runbooks.
Module 21: DocumentDB
Overview, creating database, collections, inserting, updating and deleting data, migrating data from sql server, csv and JSON to DocumentDB, common use cases, building applications with DocumentDB and more!!!
Please feel free to contact us if you need any further information
Email : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-7829999046 / +91-9503124667