Complete Practical and Real-time Training on Azure Managed Instance. Azure SQL Managed Instance provides users and option in Azure to combine all the great features that come with a platform as a service (PaaS) with a scalable cloud database service that has the broadest SQL Server database engine compatibility. It presents an option for those who are looking to migrate their current database solution to Azure and still have access to near 100% of the most recent SQL Server features with minimal database changes.
This class is a great option for those who are looking to understand the benefits of Managed Instance as compared to other services such as Azure SQL DB. Users will also understand performance, cost, and features available within Managed Instance.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Azure Managed Instance (Azure MI) |
Azure SQL, Azure VM, Azure MI |
Core DBA, Azure SQL, Azure MI |
|
No of Videos | 10 Videos | 20 Videos | 50 Videos |
Azure Managed Instance | ✔ | ✔ | ✔ |
Azure MI Architecture | ✔ | ✔ | ✔ |
Azure MI Replication Topology | ✔ | ✔ | ✔ |
Azure MI Connection Types | ✔ | ✔ | ✔ |
Machine Learning with Azure MI | ✔ | ✔ | ✔ |
Azure SQL Database Migration | ❌ | ✔ | ✔ |
Azure SQL DB Security, HA-DR | ❌ | ✔ | ✔ |
Azure Always-On, PowerShell | ❌ | ✔ | ✔ |
Azure Virtual Machines (VM) | ❌ | ✔ | ✔ |
Routine SQL DBA Activities | ❌ | ❌ | ✔ |
Emergency SQL DBA Activities | ❌ | ❌ | ✔ |
SQL Server, DB Maintenance | ❌ | ❌ | ✔ |
DB Repairs, Security Management | ❌ | ❌ | ✔ |
Tuning Tools, Execution Plans | ❌ | ❌ | ✔ |
Clustering, Always-On Availability | ❌ | ❌ | ✔ |
Total Course Fee * |
INR 9000
USD 122 |
INR 18000 USD 244 |
INR 37000 USD 500 |
If above schedule does not work, opt for Azure Admin Training Videos
Azure Managed Instance Training Highlights :
✔ Azure Fundamentals, Cloud Implementations | |
✔ SaaS, IaaS & PaaS Implementation Concepts | |
✔ Azure Kubernetes Services (AKS) Concepts | |
✔ Azure Active Directory and Security Concepts | |
✔ Public Cloud and Private Cloud Concepts | |
✔ Azure Governance Methodologies | |
✔✔ End to End Real-time Project @ Resume |
All Session Are Completely Practical & Real Time
Module I: SQL Server & T-SQLInstallation, Architecture, DB Basics |
Module II: Basic SQL DBABackup-Restores, Jobs, Performance Tuning, Security |
Module III: Advanced SQL DBAHA-DR, Errors & Solutions, Always-On, SLA |
Ch 1: JOB ROLES, INSTALLATION
|
Ch 9: BACKUPS - DB, Filegroup, File
|
Ch 17: REPLICATION For HA - Level 1
|
Ch 2: SSMS Tool, SQL BASICS - 1
|
Ch 10: RESTORES & DB RECOVERY
|
Ch 18: REPLICATION For HA - Level 2
|
Ch 3: SQL BASICS - 2, TEMP TABLES
|
Ch 11: JOBS, MAINTENENCE PLANS
|
Ch 19: LOG SHIPPING (HA - DR)
|
Ch 4: CONSTRAINTS, JOINS
|
Ch 12: SECURITY MANAGEMENT
|
Ch 20: DB MIRRORING (HA - DR)
|
Ch 5: Views & Stored Procedures
|
Ch 13: DB Migrations, Perf Tuning - 1
|
Ch 21: PATCHES, UPGRADES, CUs
|
Ch 6: UDF, Triggers, Stored Procedures
|
Ch 14: Tuning 2 - Indexes, Partitions
|
Ch 22: Clusters & AlwaysOn [Overview]
|
Ch 7: Transactions, Lock Management
|
Ch 15: Tuning 3 - INDEX MANAGEMENT
|
Ch 23: ROUTINE SQL DBA ACTIVITIES
|
Ch 8: Server, DB Architecture
|
Ch 16: Health Checks, Issues, Solutions
|
Ch 24: EMERGENCY DBA ACTIVITIES
|
Ch 25: CLOUD INTRO, AZURE CONFIG
|
Ch 29: XEL, STRETCH DATABASES
|
Ch 33: POWERSHELL, AZURE VMs
|
Ch 26: AZURE SQL SERVER CONFIG
|
Ch 30: ALERTS, BACKUPS / RESTORES
|
Ch 34: Windows Clusters with Azure VM
|
Ch 27: ELASTIC DTUs, MIGRATION
|
Ch 31: HA - DR : Geo Replication, DB Sync
|
Ch 35: Always-On in SQL Server Clusters
|
Ch 28: AZURE SQL DATABASE TUNING
|
Ch 32: SECURITY MANAGEMENT, RLS
|
Ch 36: Azure SQL DBA Project & DP 300 Exam
|
|
Ch 37: Azure Managed Instance Intro
|
Ch 41: Azure MI - Tuning Concepts
|
Ch 45: Azure MI - HA DR with Replication
|
Ch 38: Azure MI Configurations
|
Ch 42: Azure Managed Instance Backups
|
Ch 46: Managed Instance Pools
|
Ch 39: Azure MI Connections From VM
|
Ch 43: Azure MI Restores, Monitoring
|
Ch 47: On-Premise Connections
|
Ch 40: Azure MI Migrations From VM
|
Ch 44: Azure MI Security Management
|
Ch 48: Azure MI Features Comparison
|