Azure Managed Instance

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.

Azure Managed Instance (MI) Training Plans

	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

Trainer: Mr. Sai Phanindra T

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-SQL Installation, Architecture, DB Basics	Module II: Basic SQL DBA Backup-Restores, Jobs, Performance Tuning, Security	Module III: Advanced SQL DBA HA-DR, Errors & Solutions, Always-On, SLA
Ch 1: JOB ROLES, INSTALLATION Introduction to Databases, DBMS Microsoft SQL Server : Advantages, Use Versions and Editions of SQL Server SQL DBA Job Roles, Responsibilities Routine Maintenance DBA Activities Emergency SQL DBA Activities SQL Server Pre-requisites: S/W, H/W SQL Server 2019/2017/2016 Installation Default Instance, Named Instances Port Numbers, Instance Differences Service and Service Account Use Authentication Modes and Logins Firewall Configuration in Real-time SQLServr.exe and SQLBrowser.exe	Ch 9: BACKUPS - DB, Filegroup, File Database Backups, Filegroup Backups Log File Backups and Log Truncations COPY_ONLY Backups and Real-time Use Mirror Backups and Split Backups Partial Backups - ReadOnly Filegroups Format, Compression and Checksum Backup Verification, RetainDays, Stats ContinueOnError and Backup Scripts GUI and Script Backups: Differences Backup History Tables in MSDB - Joins Backup Audits. HOT and COLD Backups Backup Devices - Creation and Usage Using Backup Devices - Advantages Common Errors and Solutions	Ch 17: REPLICATION For HA - Level 1 Replication Architecture and Topology Publication Types - Purpose, Importance DB Articles, Publications, Subscriptions Distribution DB Configuration, Snapshots Snapshot Replication and Repl Agents Adding Articles to Existing (LIVE) Replica PUSH, PULL Subscriptions. N/W Shares Transactional Replication Configuration Log Reader Agent - Configuration, Keys Replication Monitor - Tracer Tokens Replication Monitor - Warnings, Alerts Replication Monitor - Adding Articles Replication Scripts, Reinitialization Replication Warnings and Agent Alerts
Ch 2: SSMS Tool, SQL BASICS - 1 SSMS Tool Installation, Connections SQL Server Management Studio Single Server, Multi Server Connections System Databases: Master and Model MSDB, TempDB, Resource Databases SQL and T-SQL: Basic Differences DDL, DML, SELECT Statements Using GUI and SQL Scripts in SSMS Creating Databases : Files [MDF, LDF] Creating Tables in SQL Server Data Storage in Tables : Inserts SELECT : Data Retrieval Statement Table Scans. LIVE QUERY STATISTICS Limitations with SSMS GUI Options	Ch 10: RESTORES & DB RECOVERY Restore Phases - COPY, REDO, UNDO RECOVERY, NORECOVERY Options STANDBY and REPLACE in Restores File, File Group & Metadata Restores Backup Verifications using GUI, Scripts VERIFYONLY : Backup Verification STATS, UNLOAD, STOPAT and INIT PARTIAL / PIECEMEAL Restores - Use Tail Log Backup Usage in Real-time Restores using GUI and T-SQL Scripts MOVE Options for File Level Restores Point-In-Time Restore, Checkpoint LSN Standby Restores and Read-Only State Common Errors and Solutions	Ch 18: REPLICATION For HA - Level 2 Merge Replication and Merge Agent Job Replication Conflicts and ROWGUIDCOL Server Subscription & Client Subscription Peer-Peer Replication Connections, Nodes NodeID and Conflict Detection Options Replication Conflicts and sp_MSRepl sp_changedbowner, backup initialization Replication Conflicts and Priority Settings Replication Verify - Rowcount, Checksum Disabling, Cleaning Replication Topology Replication Strategies for HA and DR Plan Replication for Load Balancing Topologies SQL Server Configuration Manager Tool Common Errors and Solutions
Ch 3: SQL BASICS - 2, TEMP TABLES Data Inserts and SELECT Statement WHERE Conditions and Keywords IN Operator and NOT IN Operator Between, Not Between Operators UPDATE Statement & Conditions DELETE & TRUNCATE Statements Logged and Non-Logged Operations ADD, ALTER and DROP Columns Aliases and Batch Statements Import and Export Wizard in SSMS Performing Bulk Operations in SSMS Temporary Tables : Real-time Use Local and Global Temporary Tables # and ## Prefix, Scope of Usage Session Level, Connection Level Use	Ch 11: JOBS, MAINTENENCE PLANS SQL Server Agent Service & Agent XPs SQL Agent Jobs - GUI, Script Creations Job Steps - Creation, Edits and Parse Job Executions, Disable/Enable Options Job History Purge. Job Activity Monitor Database Offline and Backup Errors Database Maintenance - Backup Jobs Scheduling Database Maintenance Plans Automated Job Creations using DMPs Backup Cleanup & History Cleanup Jobs Backup Strategies For Minimal Data Loss Backup Options: Block Size, Transfer Size DB Mail Configurations and Alert System DB Mail Profiles, SMTP Email Accounts Operators : Creation, Job Notifications	Ch 19: LOG SHIPPING (HA - DR) Log Shipping Topology for HA and DR Primary and Secondary: Recovery Plan Log Shipping Monitor, Jobs and Alerts NORECOVERY Mode - Configuration STANDBY Mode Configuration & Jobs Log Shipping Jobs and Manual Failover Log Shipping Mode Changes - cautions Re-Restoring Log Backups for Recovery LSBackup, LSCopy & LSRestore Jobs LS Job Audits, Dashboards (Reports) TUF Files and Standby Options in LS Broken Log Shipping Chains & Issues Log Shipping Manual Fail-over Options Log Shipping Configuration Precautions Common Backups Errors & Solutions
Ch 4: CONSTRAINTS, JOINS Constraints and Keys - Data Integrity NULL, NOT NULL Property on Tables UNIQUE KEY Constraints: Importance PRIMARY KEY Constraint: Importance FOREIGN KEY Constraint: Importance REFERENCES, CHECK and DEFAULT Candidate Keys and Identity Property JOINS - Table Comparisons Queries INNER JOINS For Matching Data OUTER JOINS For (non) Match Data Left Outer Joins with Example Queries Right Outer Joins with Example Queries FULL Outer Joins - Realtime Scenarios Join Queries with "ON" Conditions	Ch 12: SECURITY MANAGEMENT Authentication Types & Modifications Windows Logins & SQL Server Logins Logins - Users Mapping, DB Access Server Roles & Database Roles - Usage Object, Column and Schema Security GRANT, WITH GRANT, DENY, REVOKE CONTROL, OWNERSHIP, Authorization Data Encryption: Keys and Certificates Data Encryption with Stored Procedures Job Security : Credentials and Proxies Using Proxies for SSIS Jobs, Repl Jobs Security Scripts and Documentation DMVs for Security Audits, Orphan Users Login, User, Server Principal Audits	Ch 20: DB MIRRORING (HA - DR) DB Mirroring Architecture For HA & DR Log Shipping Versus Database Mirroring TCP Endpoints, TCP Network Security Heartbeat and Polling Concepts in DM Automatic Fail-Over Procedures, Tests PARTNER OFFLINE Conditions, Options DB Mirroring Monitors and Commit Loads SYNCHRONOUS & ASYNCHRONOUS DB Mirroring and Port Configurations Mirroring Monitor, Stop/Resume Options Need for Always-On & Higher Availability DB Recovery without Witness. Failover Mirroring Monitor Jobs - Real-time Usage Common Backups Errors & Solutions
Ch 5: Views & Stored Procedures Views : Types, Usage in Real-time Creating Views For SELECT Statement Views: Executions, Metadata Audits Views: Refresh Options, Recompilations System Predefined Views and Audits Listing Databases, Tables, Schemas Procedures : Types, Usage in Real-time User & System Predefined Procedures Parameters and Dynamic SQL Queries Using Static Joins and Metadata Audits Using Dynamic Joins and Metadata Audits Sp_help, Sp_helpdb and sp_helptext sp_pkeys, sp_rename and sp_help sp_recompile, sp_who, sp_who2, sp_lock	Ch 13: DB Migrations, Perf Tuning - 1 CDW : Copy Database Wizard @ SSMS Database Detach and Attach Options SMO Method and Database Scripting CDW SSIS Packages, SSIS Proxies Use Scheduling Database Migration Jobs Detecting and Resolving Orphan Users Containment Databases Authentication Audit Long Running Queries : DMV, DMF Activity Monitor Tool, Server Dashboards Logical I/O, Physical I/O, Database I/O Recent Expensive Queries, Wait Time Active Expensive Queries, Statistics Plan Handle, Execution Time - Audits CPU, IO, Memory Consumption Reports	Ch 21: PATCHES, UPGRADES, CUs Maintenance: Precautions & Downtime DB Backups, Scripting and Services Service Packs and Patch/Hotfix Activities Cumulative Updates (CU), Hotfix Process Instance Selectivity for Updates, Cautions Verifications, Smoke Test and Rollbacks Multi Instance Updates & Port Changes SERVER Upgrades & VERSION Changes Silent Installation & Installation Repairs Verifications, Smoke Test and Rollbacks System Database REBUILDs using CMD Silent Installation & Installation Repairs SQLCMD Tool and Instance Connections DAC : Dedicated Administration Console
Ch 6: UDF, Triggers, Stored Procedures Functions : Types, Usage in Real-time Scalar, Inline and Multi-Line Functions System Predefined Functions, Audits DBID, DBName, ObjectID, ObjectName Date and Time Functions: Getdate() User & System Predefined Procedures Parameters and Dynamic SQL Queries Triggers: Real-time Usage in SQL Server DDL Triggers and DML Triggers Automations with Triggers: DML,DDL INSERTED, DELETED Memory Tables Table Data Replication using Triggers System Objects for Listing Triggers Recompilations with Triggers - Cautions	Ch 14: Tuning 2 - Indexes, Partitions Indexes: Architecture and Index Types B Tree Structure, IAM Page [Root] Clustered & NonClustered Indexes Included, Columnstore, Online Filtered, Covering, Indexed Views Fill Factor and Pad Index Options Query Store - Settings and Advantages PARTITIONS : Advantages, Performance Partition Functions & Partition Schemes Partitioning Un-partitioned Tables: GUI Partition Compression : ROW and PAGE Auditing Table Partitioned Structures Statistics : Purpose, Auto Creation, Audits NUMA Nodes, Processor, IO Affinity	Ch 22: Clusters & AlwaysOn [Overview] Detailed Implementation @ Ch 34, 35 Windows Clusters For HA and DR Domain Controller (DC) Configuration Active Directory (AD) Accounts, Use SAN [Storage Area Network] and LUN Public IP Address, Private IP Address Windows Level Clusters, MSCS Service Active-Active, Active-Passive Clusters Always On Availability Group [AOAG] Synchronous and Asynchronous Modes Synchronization, Automated Seeding Data Synchronization for AOAG Backup Preferences, Location Options Detailed Implementation @ Ch 34, 35
Ch 7: Transactions, Lock Management Linked Servers and Real-time Usage Creating Linked Servers in SQL Server Security Options and Access Options Remote Data Access RPC Settings RPC Out, Remote Login Credentials Transactions : Types, ACID Properties Transaction Types and AutoCommit EXPLICIT & IMPLICIT Transactions COMMIT and ROLLBACK Statements Lock Hints: READPAST, NOLOCK LOCKS : Types and Isolation Levels S, X, IX,U, MD, Sch-M and Sch-S Lock Audits : SP_WHO2, SP_LOCK Deadlock Audits and Deadlock Graphs	Ch 15: Tuning 3 - INDEX MANAGEMENT Working with Indexes and Partitions Internal and External Fragmentation Index Rebuilding Process and Audits Database Maintenance Plans Jobs Last Used, Page Count, Fragmentation Degree Of Parallelism [DOP] Settings Resumable Indexes: ONLINE, RESUME Tuning Tools : Workload Files, Trace Files Profiler Tuning Template, SP Events DTA, Profiler Trace : Recommendations Perfmon Tool Counters, Realtime Tracking Execution Plan Analysis and Internals Query Costs: IO Cost and CPU Cost Query Costs: SubTree & Operator Cost	Ch 23: ROUTINE SQL DBA ACTIVITIES Audit Login Failures : Server Logs Monitoring Connectivity Issues Database Refresh and MSDTC Adhoc Memory Dump Files PLE (Page Life Expectancy) Issues Object Refresh and Recompilations Server Registrations and Operations Lock Monitoring Operations Index Management Options Open Transactions, Blocking Backup and HA-DR Strategies DB Restores and DB Repairs Online and Offline Backups - Issues Port Level Issues and Solutions
Ch 8: Server, DB Architecture Server Architecture and Protocols Database Engine and Query Processor Parser, Optimizer, SQL & DB Manager Storage Engine Components, SQL OS File Manager and Database Files Transaction Services, Buffer Manager Lock Manager, IO Manager, MDAC CLR, WAL, Lazy Writer, Checkpoint Database Architecture - Data Files Database Architecture - Log Files Primary (mdf), Secondary Files (ndf) Filegroups Usage, ReadOnly Filegroups Database Files: Size and Location Pages, Extents. Uniform, Mixed Extent	Ch 16: Health Checks, Issues, Solutions Alerts : Creation and Notifications DB Suspect Event Alerts (023) Important Perfmon Counters, Alerts Log Space, Memory, Tempdb Alerts Scheduling Alerts & Notifications DBCC CHECKDB : DB Health Checks Allocation Errors, Consistency Errors DBCC ShowContig, Extent Fragmentation Trace Flags and Page Restores DBCC Page: GAM, SGAM and PFS Consistency Errors : Cause & Solutions Allocation Errors : Cause and Solutions Log Space Issues and Log Rebuilds Memory & TempDB Issues, Solutions	Ch 24: EMERGENCY DBA ACTIVITIES Server Down Issues and Solutions Database Down Issues and Solutions Data Missing Issues and Solutions Hot CPU and Resource Allocations Health Checks, Issues, Solutions Automated Backups, Log File Readers Ticketing Tools : SLA & OLA Concepts Incident Management and Ticketing Immediate, High and Medium Priority Levels of Support for Production DBA Licensing and Pricing Options Versions, Editions Comparisons 3rd Party Tools: Real-time Use 3rd Party Tools: Dell Litespeed, Usage

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Module III: Advanced SQL DBA

HA-DR, Errors & Solutions, Always-On, SLA

Ch 1: JOB ROLES, INSTALLATION

Introduction to Databases, DBMS
Microsoft SQL Server : Advantages, Use
Versions and Editions of SQL Server
SQL DBA Job Roles, Responsibilities
Routine Maintenance DBA Activities
Emergency SQL DBA Activities
SQL Server Pre-requisites: S/W, H/W

SQL Server 2019/2017/2016 Installation
Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Firewall Configuration in Real-time
SQLServr.exe and SQLBrowser.exe

Ch 9: BACKUPS - DB, Filegroup, File

Database Backups, Filegroup Backups
Log File Backups and Log Truncations
COPY_ONLY Backups and Real-time Use
Mirror Backups and Split Backups
Partial Backups - ReadOnly Filegroups
Format, Compression and Checksum
Backup Verification, RetainDays, Stats

ContinueOnError and Backup Scripts
GUI and Script Backups: Differences
Backup History Tables in MSDB - Joins
Backup Audits. HOT and COLD Backups
Backup Devices - Creation and Usage
Using Backup Devices - Advantages
Common Errors and Solutions

Ch 17: REPLICATION For HA - Level 1

Replication Architecture and Topology
Publication Types - Purpose, Importance
DB Articles, Publications, Subscriptions
Distribution DB Configuration, Snapshots
Snapshot Replication and Repl Agents
Adding Articles to Existing (LIVE) Replica
PUSH, PULL Subscriptions. N/W Shares

Transactional Replication Configuration
Log Reader Agent - Configuration, Keys
Replication Monitor - Tracer Tokens
Replication Monitor - Warnings, Alerts
Replication Monitor - Adding Articles
Replication Scripts, Reinitialization
Replication Warnings and Agent Alerts

Ch 2: SSMS Tool, SQL BASICS - 1

SSMS Tool Installation, Connections
SQL Server Management Studio
Single Server, Multi Server Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
SQL and T-SQL: Basic Differences
DDL, DML, SELECT Statements

Using GUI and SQL Scripts in SSMS
Creating Databases : Files [MDF, LDF]
Creating Tables in SQL Server
Data Storage in Tables : Inserts
SELECT : Data Retrieval Statement
Table Scans. LIVE QUERY STATISTICS
Limitations with SSMS GUI Options

Ch 10: RESTORES & DB RECOVERY

Restore Phases - COPY, REDO, UNDO
RECOVERY, NORECOVERY Options
STANDBY and REPLACE in Restores
File, File Group & Metadata Restores
Backup Verifications using GUI, Scripts
VERIFYONLY : Backup Verification
STATS, UNLOAD, STOPAT and INIT

PARTIAL / PIECEMEAL Restores - Use
Tail Log Backup Usage in Real-time
Restores using GUI and T-SQL Scripts
MOVE Options for File Level Restores
Point-In-Time Restore, Checkpoint LSN
Standby Restores and Read-Only State
Common Errors and Solutions

Ch 18: REPLICATION For HA - Level 2

Merge Replication and Merge Agent Job
Replication Conflicts and ROWGUIDCOL
Server Subscription & Client Subscription
Peer-Peer Replication Connections, Nodes
NodeID and Conflict Detection Options
Replication Conflicts and sp_MSRepl
sp_changedbowner, backup initialization

Replication Conflicts and Priority Settings
Replication Verify - Rowcount, Checksum
Disabling, Cleaning Replication Topology
Replication Strategies for HA and DR Plan
Replication for Load Balancing Topologies
SQL Server Configuration Manager Tool
Common Errors and Solutions

Ch 3: SQL BASICS - 2, TEMP TABLES

Data Inserts and SELECT Statement
WHERE Conditions and Keywords
IN Operator and NOT IN Operator
Between, Not Between Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns

Aliases and Batch Statements
Import and Export Wizard in SSMS
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage
Session Level, Connection Level Use

Ch 11: JOBS, MAINTENENCE PLANS

SQL Server Agent Service & Agent XPs
SQL Agent Jobs - GUI, Script Creations
Job Steps - Creation, Edits and Parse
Job Executions, Disable/Enable Options
Job History Purge. Job Activity Monitor
Database Offline and Backup Errors
Database Maintenance - Backup Jobs
Scheduling Database Maintenance Plans

Automated Job Creations using DMPs
Backup Cleanup & History Cleanup Jobs
Backup Strategies For Minimal Data Loss
Backup Options: Block Size, Transfer Size
DB Mail Configurations and Alert System
DB Mail Profiles, SMTP Email Accounts
Operators : Creation, Job Notifications

Ch 19: LOG SHIPPING (HA - DR)

Log Shipping Topology for HA and DR
Primary and Secondary: Recovery Plan
Log Shipping Monitor, Jobs and Alerts
NORECOVERY Mode - Configuration
STANDBY Mode Configuration & Jobs
Log Shipping Jobs and Manual Failover
Log Shipping Mode Changes - cautions
Re-Restoring Log Backups for Recovery

LSBackup, LSCopy & LSRestore Jobs
LS Job Audits, Dashboards (Reports)
TUF Files and Standby Options in LS
Broken Log Shipping Chains & Issues
Log Shipping Manual Fail-over Options
Log Shipping Configuration Precautions
Common Backups Errors & Solutions

Ch 4: CONSTRAINTS, JOINS

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property

JOINS - Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins - Realtime Scenarios
Join Queries with "ON" Conditions

Ch 12: SECURITY MANAGEMENT

Authentication Types & Modifications
Windows Logins & SQL Server Logins
Logins - Users Mapping, DB Access
Server Roles & Database Roles - Usage
Object, Column and Schema Security
GRANT, WITH GRANT, DENY, REVOKE
CONTROL, OWNERSHIP, Authorization

Data Encryption: Keys and Certificates
Data Encryption with Stored Procedures
Job Security : Credentials and Proxies
Using Proxies for SSIS Jobs, Repl Jobs
Security Scripts and Documentation
DMVs for Security Audits, Orphan Users
Login, User, Server Principal Audits

Ch 20: DB MIRRORING (HA - DR)

DB Mirroring Architecture For HA & DR
Log Shipping Versus Database Mirroring
TCP Endpoints, TCP Network Security
Heartbeat and Polling Concepts in DM
Automatic Fail-Over Procedures, Tests
PARTNER OFFLINE Conditions, Options
DB Mirroring Monitors and Commit Loads

SYNCHRONOUS & ASYNCHRONOUS
DB Mirroring and Port Configurations
Mirroring Monitor, Stop/Resume Options
Need for Always-On & Higher Availability
DB Recovery without Witness. Failover
Mirroring Monitor Jobs - Real-time Usage
Common Backups Errors & Solutions

Ch 5: Views & Stored Procedures

Views : Types, Usage in Real-time
Creating Views For SELECT Statement
Views: Executions, Metadata Audits
Views: Refresh Options, Recompilations
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Procedures : Types, Usage in Real-time

User & System Predefined Procedures
Parameters and Dynamic SQL Queries
Using Static Joins and Metadata Audits
Using Dynamic Joins and Metadata Audits
Sp_help, Sp_helpdb and sp_helptext
sp_pkeys, sp_rename and sp_help
sp_recompile, sp_who, sp_who2, sp_lock

Ch 13: DB Migrations, Perf Tuning - 1

CDW : Copy Database Wizard @ SSMS
Database Detach and Attach Options
SMO Method and Database Scripting
CDW SSIS Packages, SSIS Proxies Use
Scheduling Database Migration Jobs
Detecting and Resolving Orphan Users
Containment Databases Authentication

Audit Long Running Queries : DMV, DMF
Activity Monitor Tool, Server Dashboards
Logical I/O, Physical I/O, Database I/O
Recent Expensive Queries, Wait Time
Active Expensive Queries, Statistics
Plan Handle, Execution Time - Audits
CPU, IO, Memory Consumption Reports

Ch 21: PATCHES, UPGRADES, CUs

Maintenance: Precautions & Downtime
DB Backups, Scripting and Services
Service Packs and Patch/Hotfix Activities
Cumulative Updates (CU), Hotfix Process
Instance Selectivity for Updates, Cautions
Verifications, Smoke Test and Rollbacks
Multi Instance Updates & Port Changes

SERVER Upgrades & VERSION Changes
Silent Installation & Installation Repairs
Verifications, Smoke Test and Rollbacks
System Database REBUILDs using CMD
Silent Installation & Installation Repairs
SQLCMD Tool and Instance Connections
DAC : Dedicated Administration Console

Ch 6: UDF, Triggers, Stored Procedures

Functions : Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
System Predefined Functions, Audits
DBID, DBName, ObjectID, ObjectName
Date and Time Functions: Getdate()
User & System Predefined Procedures
Parameters and Dynamic SQL Queries

Triggers: Real-time Usage in SQL Server
DDL Triggers and DML Triggers
Automations with Triggers: DML,DDL
INSERTED, DELETED Memory Tables
Table Data Replication using Triggers
System Objects for Listing Triggers
Recompilations with Triggers - Cautions

Ch 14: Tuning 2 - Indexes, Partitions

Indexes: Architecture and Index Types
B Tree Structure, IAM Page [Root]
Clustered & NonClustered Indexes
Included, Columnstore, Online
Filtered, Covering, Indexed Views
Fill Factor and Pad Index Options
Query Store - Settings and Advantages

PARTITIONS : Advantages, Performance
Partition Functions & Partition Schemes
Partitioning Un-partitioned Tables: GUI
Partition Compression : ROW and PAGE
Auditing Table Partitioned Structures
Statistics : Purpose, Auto Creation, Audits
NUMA Nodes, Processor, IO Affinity

Ch 22: Clusters & AlwaysOn [Overview]

Detailed Implementation @ Ch 34, 35
Windows Clusters For HA and DR
Domain Controller (DC) Configuration
Active Directory (AD) Accounts, Use
SAN [Storage Area Network] and LUN
Public IP Address, Private IP Address
Windows Level Clusters, MSCS Service

Active-Active, Active-Passive Clusters
Always On Availability Group [AOAG]
Synchronous and Asynchronous Modes
Synchronization, Automated Seeding
Data Synchronization for AOAG
Backup Preferences, Location Options
Detailed Implementation @ Ch 34, 35

Ch 7: Transactions, Lock Management

Linked Servers and Real-time Usage
Creating Linked Servers in SQL Server
Security Options and Access Options
Remote Data Access RPC Settings
RPC Out, Remote Login Credentials
Transactions : Types, ACID Properties
Transaction Types and AutoCommit

EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Lock Hints: READPAST, NOLOCK
LOCKS : Types and Isolation Levels
S, X, IX,U, MD, Sch-M and Sch-S
Lock Audits : SP_WHO2, SP_LOCK
Deadlock Audits and Deadlock Graphs

Ch 15: Tuning 3 - INDEX MANAGEMENT

Working with Indexes and Partitions
Internal and External Fragmentation
Index Rebuilding Process and Audits
Database Maintenance Plans Jobs
Last Used, Page Count, Fragmentation
Degree Of Parallelism [DOP] Settings
Resumable Indexes: ONLINE, RESUME

Tuning Tools : Workload Files, Trace Files
Profiler Tuning Template, SP Events
DTA, Profiler Trace : Recommendations
Perfmon Tool Counters, Realtime Tracking
Execution Plan Analysis and Internals
Query Costs: IO Cost and CPU Cost
Query Costs: SubTree & Operator Cost

Ch 23: ROUTINE SQL DBA ACTIVITIES

Audit Login Failures : Server Logs
Monitoring Connectivity Issues
Database Refresh and MSDTC
Adhoc Memory Dump Files
PLE (Page Life Expectancy) Issues
Object Refresh and Recompilations
Server Registrations and Operations

Lock Monitoring Operations
Index Management Options
Open Transactions, Blocking
Backup and HA-DR Strategies
DB Restores and DB Repairs
Online and Offline Backups - Issues
Port Level Issues and Solutions

Ch 8: Server, DB Architecture

Server Architecture and Protocols
Database Engine and Query Processor
Parser, Optimizer, SQL & DB Manager
Storage Engine Components, SQL OS
File Manager and Database Files
Transaction Services, Buffer Manager
Lock Manager, IO Manager, MDAC

CLR, WAL, Lazy Writer, Checkpoint
Database Architecture - Data Files
Database Architecture - Log Files
Primary (mdf), Secondary Files (ndf)
Filegroups Usage, ReadOnly Filegroups
Database Files: Size and Location
Pages, Extents. Uniform, Mixed Extent

Ch 16: Health Checks, Issues, Solutions

Alerts : Creation and Notifications
DB Suspect Event Alerts (023)
Important Perfmon Counters, Alerts
Log Space, Memory, Tempdb Alerts
Scheduling Alerts & Notifications
DBCC CHECKDB : DB Health Checks
Allocation Errors, Consistency Errors

DBCC ShowContig, Extent Fragmentation
Trace Flags and Page Restores
DBCC Page: GAM, SGAM and PFS
Consistency Errors : Cause & Solutions
Allocation Errors : Cause and Solutions
Log Space Issues and Log Rebuilds
Memory & TempDB Issues, Solutions

Ch 24: EMERGENCY DBA ACTIVITIES

Server Down Issues and Solutions
Database Down Issues and Solutions
Data Missing Issues and Solutions
Hot CPU and Resource Allocations
Health Checks, Issues, Solutions
Automated Backups, Log File Readers
Ticketing Tools : SLA & OLA Concepts

Incident Management and Ticketing
Immediate, High and Medium Priority
Levels of Support for Production DBA
Licensing and Pricing Options
Versions, Editions Comparisons
3rd Party Tools: Real-time Use
3rd Party Tools: Dell Litespeed, Usage

Module 2: Azure DBA Training Content

Ch 25: CLOUD INTRO, AZURE CONFIG

Introduction to Cloud & Advantages
Cloud Architecture: IaaS, PasS and SaaS
Microsoft Cloud Advantages, Azure Platform
Azure Products and Services - MarketPlace
Database Implementations in Azure Platform
Comparing PaaS and IaaS Implmentations
Paas Implementations For SQL Server

IaaS Implementations For SQL Server
Logical, Virtual Machine, Managed Instance
Installing SSMS and Azure Data Studio
Azure Account and Free Subscription
Azure Resources: Resource Groups Usage
Azure Active Directory: User & Groups
Azure Active Directory Authentication

Ch 29: XEL, STRETCH DATABASES

SQL Traces : Creation and Audits
Event Class, Category, Filter, Conditions
Extended Events, Target, Action, Session
TSQL, SP Debug Events with Global Fields
Catalog & Dynamic Management Views
XE Profiler - Templates for Event Profiling
Comparing XE Profiler with SQL Profiler

Azure SQL Database with On-Premise
Stretch Databases Tuning Benefits, Cautions
Table Migrations with Azure SQL Databases
Compute Performance Levels, DSU Pricing
Data Storage, Azure Database Snapshots
Remote Data Archive Configuration in Azure
Database Master Key, Cold Data Migration

Ch 33: POWERSHELL, AZURE VMs

Azure Virtual Machines : Deploy, Configure
Configure Windows Server, Redhat Linux
Azure Storage Blades and Pricing Options
Azure VM - Settings, Access & DB Creation
On-Premise & Azure VMs: Similarities
SQL Server Instance, Agent in Azure VM
Azure SQL Database in VM to SQL Cloud

Azure SQL Database in VM to on-Prem
Deployment Automation Scripts in Azure
Azure Cloud Shell - PowerShellGet
Power Shell Scripts for Configurations
Power Shell Scripts for Job Schedules
Power Shell Scripts for Firewall, ARM
Azure CLI - Purpose, Real-time Use

Ch 26: AZURE SQL SERVER CONFIG

Installing SSMS and Azure Data Studio
Azure Account and Free Subscriptions
Azure SQL Server (Logical Server)
Azure SQL Server Logical Server Firewall
Firewall Rules - IP for Remote Access
Server Properties and Status Format
Password Resets in Azure SQL Server

Azure SQL Databases & Pricing Tiers
Azure SQL Database Access from SSMS
Elastic Scaling with Azure Databases
General Purpose and Business Critical
Basic, Standard and Premium Plans
vCore Based Purchasing : Gen 4, Gen 5
Resource Groups For Azure SQL Server

Ch 30: ALERTS, BACKUPS / RESTORES

Azure SQL Server Activity Log and Options
Events, Operations and Event Categories
Quick Insights from Events and Filters
Events Exports to Event Hub, Log Analytics
Log Analytics Workspace, Alert Rules
Email / SMS Notifications and Schedules
Log Analytics Settings and Azure Storage

Activity Logs and Audit Reports, Insights
Azure SaaS Notifications System Options
Automated Backups in Azure SQL Database
Long Term, Automated Backup Retentions
Backups - Retentions, Audits. LTR Policy
Restore Points and Database Recovery
Geo-Redundant Backups and Restores

Ch 34: Windows Clusters with Azure VM

Windows Clusters For HA and DR
Virtual Networks, Subnets and Ips
Availability Sets and Availability Zones
Fault Domains and Update Domains
DC Deployment & Configurations
Active Directory Domain Services
SAN [Storage Area Network] and LUN

DNS Server, DSRM and Private IP
Windows Level Clusters, MSCS Service
Active-Active, Active-Passive Clusters
DNS Tools, Actions & Adding AA Hosts
SQL Clustering Service & RAID Levels
SQL Cluster Groups, Domain Accounts
Quorum and MSDTC Disks. LUN Grows

Ch 27: ELASTIC DTUs, MIGRATION

Azure Storage: Creation & Containers
LRS, GRS and RA-GRS Storage Accounts
Storage Containers, Storage Explorer Tool
Data and Database Migration in Azure
Data Migration Assistant (DMA) Tool
DB Migrations To Azure SQL Databases
Database Exports and Imports in Azure

Migration Scopes: Schema and Data
Schema Generation, Migration Compatibility
Data Migration Verification and Row Counts
DTU: Data Transaction Unit and Resources
Bounding Box Model, Elastic Pool Queries
eDTUs, Elastic Pool. Per Database Settings
Performance Recommendations in Azure

Ch 31: HA - DR : Geo Replication, DB Sync

Failover Groups, Active Geo-Replication
Read-Write Policy & Automated Failover
Geo Replication Configuration in Azure
Primary-Secondary and Read / Write Modes
GeoReplication Monitoring, Forced Failover
Azure Server Failover Process, Strategies
Automated, Manual and Forced Failover

Backup Errors, Geo Replication Errors
SQL Data Sync Service and Sync Groups
HUB, MEMBER and SYNC DATABASE
Sync Direction, Sync Schema, Sync Interval
bi-directional Load Balancing and Failover
Conflict Resolutions with HUB, MEMBER
Cloud to Cloud, OnPremise Synchronization

Ch 35: Always-On in SQL Server Clusters

SQL Server VMs and File Share Witness
Joining Machines to Domain Network
Install Accounts to Active Directory
Install Failover Cluster (FCI) Features
Firewall Configurations, Port Exceptions
FSW File Shares and Usability Options
Need for Always - On Availability (AAG)

Always On Availability Group [AOAG]
Multi-Database Replication Options
Backup Preferences, Automated Seeding/li>
Synchronous and Asynchronous Modes
Data Synchronization for AOAG
AOAG Dashboards & Automated Failover
Need for Azure Managed Instances

Ch 28: AZURE SQL DATABASE TUNING

Azure SQL Server Level Tuning Options
Azure SQL Database Level Tuning Options
Automated Tuning Options and Peak-Loads
Force Plan, Create Index and Drop Index
Performance Insight and Recommendations
IO Metrics, CPU Metrics & Query Statistics
Data File IO, Log File IO, Custom Reports
Query Audits with Query IDs, Dashboards

DTU Usage Reports and Elastic Queries
Query Recommendations, Query Costs
Azure Search Service and Pricing Tiers
Azure Search for Data Import. Indexer
Suggester and Analyzer Modes for Tuning
Retrievable, Facetable, Facetable Indexes
Filterable and Searchable Indexes
Change Tracking & Watermark Columns

Ch 32: SECURITY MANAGEMENT, RLS

Firewall and Virtual Network Configurations
Server Firewall, Database Firewall Rules
System Procedures for Firewall Settings
Logins, Users, Roles Permissions @ T-SQL
Creating Users without Logins. Containment
GRANT, DENY, REVOKE, WITH GRANT
Role Level and Schema Level Security
Threat Detection, Transparent Data Encryption

Vulnerability Assessment, Data Masking
Implementing RLS - Row Level Security
Creating Users with and without Logins
Using SECURITY Schema for RLS Functions
Creating Security Predicates and Filters
Security Policies for Row Level Security
EXECUTE AS option & STATE for RLS
Dynamic Data Masking with Azure SQL DB

Ch 36: Azure SQL DBA Project & DP 300 Exam

Real-time Project For your Resume

DP 300 Microsoft Examination Guidance

Module 3: Azure Managed Instance Training Content

Ch 37: Azure Managed Instance Intro

Azure Managed Instance Fundamentals
Azure SQL: Logical, Virtual & Managed
Deployment Options of Azure SQL?
SQL Server PaaS Implementation
Azure Managed Instance - Advantages
Azure Managed Instance - Architecture
Scaling Options & Vcore Purchasing

Flexible Service Tiers and Compliance
Frictionless Deployments in Azure MI
Comparing Azure MI with Azure VM
Comparing Azure MI with Logical Server
Database Engine Stability, Availability
Automated Tuning, Technical Features
Virtual Networks and Peer Connections

Ch 41: Azure MI - Tuning Concepts

Azure Managed Instance: Query Tuning
Automated and Manual Tuning in MI
Instance Level, Database, Object Level
Resource Dependencies: Service Plan
Memory, Disk Usage & Networking
General Purpose & Business Critical Plans
Memory Impact on Database Tuning

Disk and Virtual Core Impact on Tuning
Memory, Disk, Vcore Recommendations
Table Level Query Tuning Options
Implementing In-Memory OLTP
Benefits of Memory Optimized Tables
Temporal Tables : Creation and Usage
Data Capture with Temporal Tables

Ch 45: Azure MI - HA DR with Replication

Replication with Azure Managed Instance
Replication Topology with Azure Shares
Creating Azure Storage Accounts
Configuring Azure File Share Services
Distributor Configuration with File Share
Articles, Publications & Publication Types
Snapshot, Transactional and Merge

Push and Pull Subscriptions in Azure MI
Replication Agents: Snapshot, LogReader
Distribution Agent. Push / Pull Models
Replicating Azure MI with Azure VM
Create Distributor, Publication in Azure MI
Creating Subscriptions in Azure MI
Data Sync Verification; Alerts / Warnings

Ch 38: Azure MI Configurations

Azure Managed Instance Architecture
Network Environment, VNets, EndPoints
Capacity and Compute with VCore
Gen 4 and Gen 5 Purchasing Options
CPU Cores, Processor and SSD Capacity
Proxy, Redirect & Default Connections
Connection Topology In/Out Azure

TLS Versions and Security Options
Azure MI Entities: Virtual Nets, Subnets
Routing Tables, Virtual Clusters, NSG
Network Watchers with Azure MI
Managed Instance Configurations
Deployment Monitoring with Azure MI
Azure Managed Instance Key Features

Ch 42: Azure Managed Instance Backups

Azure MI: Backups Architecture
Azure MI: Automated & Manual Backups
Backups with Encrypted Databases
Backup Compression Ratio in Azure MI
Backup Frequency: Full, Differential, Log
Backup Storage Redundancy Options
LRS, GRS and ZRS Options for Backups

Backup Scheduling - Automated, Manual
Backup Storage Consumption Tuning
Backups Retention Time, Encryptions
Manual Backups: COPY_ONLY, FORMAT
Backups with Azure Storage Account
SAS: Shared Access Signature @ Security
Disable/Enable Encryptions with Backups

Ch 46: Managed Instance Pools

Azure Managed Instance Pools
Real-time Advantages with Az MI Pools
vCore Purchasing Options in Az MI Pools
Vnet Integration & Multi Instance Pools
Deployment and Security Advantages
IP Allocations and Network Configurations
Gateway Configurations with Azure MI

Virtual Machine Partitions & Pricing
Application Scenarios with Az MI Pools
Multiple Single Instances, Resource Limits
Storage Size Pools, Databases in Pools
Azure Active Directory (AAD) Admins
Supported Features with Managed Pools
Performance & Security Considerations

Ch 39: Azure MI Connections From VM

Accessing Azure Managed Instances
VM Connections and Peer Connections
Azure Managed Connections from VM
Configure Azure Virtual Machines with VN
Reusing Virtual Networks and Subnets
Azure SQL and Azure VM Deployments
Azure VM Connections to Azure MI

Installing and Using Azure Power Shell
Power Shell for Azure VM Deployments
PowerShell Commands & JS Templates
Azure Managed Instance Connections
Azure MI: SQL Server Authentication
Creating New Databases in Azure MI
Differences with On-Premise DB Creation

Ch 43: Azure MI Restores, Monitoring

Data Recovery Options with DB Restores
Creating New Databases, DB Replace
Point In Time Recovery [PITR] in Az MI
Recovery Time Factors and Challenges
Deleted Database Restore, Geo Restore
Manual Restores with Server Credentials
SAS Key Usage, Monitoring, Verifications

Azure Managed Instance Monitoring
Monitoring Azure MI from Azure Portal
Azure MI : Instance and Database Metrics
Overview Page, Resource Usage Reports
Metrics, Alerts and Diagnostics in MI
Monitoring Azure MI from SSMS Tool
Memory Consumption, Server Dashboards

Ch 47: On-Premise Connections

Azure Point to Site (P2S) Connections
Open VPN Connections with Azure MI
TLS VPN Solutions, Real-time Usage
P2S VPN Client Authentications
Azure Active Directory Authentication
Multi Factory Authentication in Azure
Azure MI : AD Connections with SSMS

Azure AD Tenants and Gateways
AD DS Domain Server Configurations
RADIUS Server Concepts for Azure MI
OnPremise Connections with Azure MI
Differences with On-Premise DB Engine
T-SQL Scripts, Agent, Backups & Restores
Onpremise Migrations to Azure MI

Ch 40: Azure MI Migrations From VM

Azure Managed Instance Migrations
Pre and Post Migration Precautions
Database Exports using SSMS (bacpac)
Database Backups using T-SQL Scripts
Database Imports and Restore Options
Using Azure Storage Accounts, Containers
Access Keys and Secured BAK File Store

T-SQL Differences with Azure MI
Database Creation Differences
Database Options, Security Differences
Backup and Restore Differences in MI
TempDB and MSDB Differences in MI
SQL Server Agent, Replication Differences
DB Mirroring and Credential Differences

Ch 44: Azure MI Security Management

Azure Managed Instance Security
Network Security, Access Management
Threat Protection, Information Protection
Customer Data Security & Encryptions
Encryption at REST and TRANSIT
Network Security with Subnets in VM
Endpoint Connections with Client, Public

Azure MI: Authentication Modes
SQL Authentication and Azure AD
Authorization Levels, Row Level Security
Threat Protection with Advanced Options
SSL, TLS and TDE Implementations
Always Encrypted, Key Management, VA
Creating Logins, Users, Roles. Privileges

Ch 48: Azure MI Features Comparison

Azure MI Features with Azure SQL DB
Azure MI Features with Azure VMs
Azure MI Features with OnPremise
Security Differences & Credentials
HA DR Differences and Compatibility
Performance Tuning Comparisons
Detach and Attach Options in Azure MI

Auditing and Azure AD Authentication
BULK INSERT, Built-In Functions
CDC - Change Data Capture, CT Tables
ColumnStore Indexes, Credentials
DB Mail and SMTP Connections
DBCC Commands and DB HealthChecks
Azure Managed Instance Advantages

Other Popular Courses: TSQL Training, MSBI Training, Power BI Training, Azure Data Engineer Training, SQL DBA Training, [+] More Courses

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Online Video

Details Register

Online Register

Details Register

Online Register

Online Video

Details Register

Azure Managed Instance