Azure SQL DBA (Admin) - Classroom Training

Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to Azure SQL Database Administration (Azure SQL DBA) activities including On-premise to Azure Azure Database Migrations, Troubleshooring, Security Management, Geo Replication, Azure Server Failover, Storage Management, Virtual Machines, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, and SQL Managed Instances. This Azure SQL DBA course also includes One Real-time Project with Routine DBA Activiteis and Emergency DBA Activities.

Azure SQL DBA (with SQL Server, Azure SQL DB Admin)

	PLAN A	PLAN B	PLAN C
SQL DBA Job Profile	Azure DBA	SQL DBA + Azure DBA	SQL DBA + Azure DBA + Power BI
SQL DBA Course Duration	2 Weeks	8 Weeks	12 Weeks
Course Contents	Ch 28 - Ch 38	Ch 1 - Ch 38	Ch 1 - Ch 56
Basic to Advanced DBA Activities	❌
Common Issues and Solutions	❌
Backups, Query Tuning, 3rd Party Tools	❌
DB Repairs, Security Management	❌
Migrations, Updates, Upgrades	❌
Clustering & Always - On Availability	❌
HA - DR, Clustering, Always-On (AAG)	❌
New Features: SQL 2016, 2017, 2019	❌
SLA-OLA Reports, Incident Management	❌
Azure SQL Database Migration (Admin)
Azure SQL DB Security and HA-DR
Azure Power Shell and Azure CLI
LINUX and Windows Virtual Machines
MCSA 70-764, 70-765 Exams : Guidance
Azure Data Access for Data Analysis	❌	❌
Basic to Advanced Data Analytics, Reports	❌	❌
Power BI Design, Data Modeling, Security	❌	❌
Power BI Cloud Administration, Gateways	❌	❌
Power BI Report Server Administration	❌	❌
Gateway Management, Administration	❌	❌
Total Course Fee (Payable in installments)	INR 8,000	INR 15,000	INR 22,000

Trainer : Mr. Sai Phanindra T

S. No	Timings (IST)	Start Date
Schedules for Chapters 26 to 37 (For Azure DBA)
1	6:30 AM - 8 AM (W)	Apr 4th	Register
2	10 AM - 12 PM (W)	Apr 18th	Register
Schedules for Chapter 1 to 27 (For Core SQL DBA)
1	6:15 AM - 7:15 AM	Mar 31st	Register
2	10:30 AM - 11:30 AM	Apr 28th	Register
3	8 PM - 9 PM	Started	Register

If above schedules does not work, opt for Azure SQL DBA Video Training

Azure SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning	✔ HA-DR Issues
✔ In-Memory Data	✔ Graph Tables
✔ Stretch Databases	✔ DAC, PBM
✔ DB Migrations	✔ Licensing Plans
✔ VN, VPN Config	✔ DMA Tool
✔ SSMA Tool	✔ POCs, RCA
✔ Ticketting Tool	✔ PSSDIAG
✔ LiteSpeed	✔ Always-On
✔ Windows Clusters	✔ Linux (RHEL)
✔ BLOB Storage	✔ Power Shell
✔ Google Cloud	✔ Virtual Machines
✔ Azure CLI	✔ AWS Cloud

Azure SQL DBA Training (with SQL Server, Azure DBA) Course Contents:

Brochure

Register Today

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 10: 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 19: 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 - Usage and Options Replication Scripts, Adding Articles 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 11: 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 20: REPLICATION For HA - Level 2 Merge Replication and Merge Agent Job Replication Conflicts and ROWGUIDCOL Subscription Reinitialization, Expiry Setting 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 Common Errors and Solutions
Ch 3: SQL BASICS For DBAs - 2 Creating Databases in SQL Server Database Connections and Usage Creating Tables and Data Storage Data Inserts and SELECT Statement WHERE Conditions and Keywords IN Operator and NOT IN Operator Between, Not Between Operators LIKE and NOT LIKE Operators UPDATE Statement & Conditions DELETE & TRUNCATE Statements Logged and Non-Logged Operations Table Structure Modifications ADD, ALTER and DROP Columns Aliases and Batch Statements	Ch 12: 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 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 21: 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 Disconnections and Delay in Restores 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 Common Errors and Solutions
Ch 4: SCHEMAS, TEMPORARY TABLES Schemas : Group Tables in Database Schemas : Security Management Object Creating Schemas & Batch Concept Using Schemas for Table Creation Data Storage in Tables with Schemas Data Retreival and Usage with Schemas Table Migrations across Schemas Import and Export Wizard in SSMS Data Imports with Excel File Data 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 13: 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 22: 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 Errors and Solutions
Ch 5: CONSTRAINTS, INDEXES Basics 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 Database Diagrams and ER Models Relationships Verification and Links Indexes : Basic Types and Creation Index Sort Options, Search Advantages Clustered and NonClustered Indexes Primary Key and Unique Key Indexes Need for Indexes - working with Keys	Ch 14: MIGRATIONS & SLA-OLA 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 SLA and OLA Process, Ticketing Tools Immediate, High, Normal Priorities Impact, Urgency and SLA Metrics Licensing and Pricing Options Core Based Licenses. Device CALs User CALs and Multiplexing Concept Versions, Editions Comparisons	Ch 23: CLUSTER CONFIGURATION 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 DNS Tools, Actions & Adding AA Hosts SQL Clustering Service & RAID Levels RAID Levels for Data Files & Log Files SQL Cluster Groups, Domain Accounts Active-Active, Active-Passive Clusters Quorum and MSDTC Disks. LUN Grows MSCS Service Startup Options, Drains Need for Always - On Availability (AAG)
Ch 6: JOINS & AUDITS 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 Join Unrelated Tables in SQL Server NULL, IS NULL Operators in Joins CROSS JOIN and CROSS APPLY CROSS JOIN Versus CROSS APPLY One-way & Two Way Data Comparisons Important Join Queries in T-SQL Join Options: Merge, Loop, Hash	Ch 15: Tuning 1 - Audits, Indexes 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 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	Ch 24: ALWAYS ON AVAILABILITY Always On Availability Group [AOAG] Synchronous and Asynchronous Modes Policy Based Management for AOAG Facets and Conditions for Policies Backup Preferences, Location Options Synchronization, Automated Seeding Data Synchronization for AOAG Port Settings, Backup Strategies in AAG AOAG Verifications and Dashboards Adding Availability Replica, Database Adding Availability Listeners and DNS Automated Failovers, Manual Failovers Always-On Availability Groups Health AAA Hosts, Forward Lookup Zones
Ch 7: View, Procedures, UDF Basics Views : Types, Usage in Real-time System Predefined Views and Audits Listing Databases, Tables, Schemas 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() Variables & Parameters in SQL Server Procedures : Types, Usage in Real-time User & System Predefined Procedures Parameters and Dynamic SQL Queries Sp_help, Sp_helpdb and sp_helptext sp_pkeys, sp_rename and sp_help sp_recompile, Perrformance Benefits System Objects for Metadata Access	Ch 16: Tuning 2 - INDEX MANAGEMENT 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 Statistics : Audits and Updates Working with Indexes and Partitions Internal and External Fragmentation Index Rebuilding Process and Audits Database Maintenance Plans Jobs Last Used, Page Count, Fragmentation Index Page Count and Index Condition Degree Of Parallelism [DOP] Settings Resumable Indexes: ONLINE, RESUME PAUSE & RESUME in Index Rebuilds	Ch 25: PATCHES, UPGRADES, CUs Establishing Downtime For Maintenance Precautions for Maintenance Activities 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 Service Startup Issues and Solutions
Ch 8: Transactions, Linked Servers Linked Servers and Real-time Usage Creating Linked Servers in SQL Server Security Options and Access Options Data Access, RPC and RPC Out Settings Automations with Triggers: DML,DDL INSERTED, DELETED Memory Tables Table Data Replication using Triggers Transactions : Types, ACID Properties Transaction Types and AutoCommit EXPLICIT & IMPLICIT Transactions COMMIT and ROLLBACK Statements SQL Server Configuration Manager Tool Services : Start and Stop Options Network Configurations and Protocols SQL Server Instance: Ports, Aliases	Ch 17: Tuning 3 - Tuning Tools, Locks Tuning Tools : Workload Files, Trace Files Profiler Tuning Template, SP Events DTA, Profiler Trace : Recommendations Perfmon Tool Counters, Real-time Tracking Execution Plan Analysis and Internals Query Costs : IO Cost and CPU Cost Query Costs: SubTree & Operator Cost NUMA Nodes, Processor, IO Affinity Thread Count, Degree of Parallelism LOCKS : Types and Isolation Levels S, X, IX,U, MD, Sch-M and Sch-S Lock Audits : SP_WHO2 and SP_LOCK sysprocesses and Lock Waits : Audits Deadlock Audits and Deadlock Graphs XDL Files and Deadlocks Prevention	Ch 26: SQL DBA PROJECT - Level 1 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 Metadata Sync-up Issues Stored Procedure Recompilations Backup and HA-DR Strategies Db Restores and DB Repairs Health Checks, Issues, Solutions
Ch 9: 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 Extents Transaction Log File [LDF], LSN, VLF	Ch 18: 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 EstimateOnly 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 DBCC ShrinkDB and Page Restores	Ch 27: SQL DBA PROJECT - Level 2 Server Down Issues and Solutions Database Down Issues and Solutions Data Missing Issues and Solutions Hot CPU and Resource Allocations Port Level Issues and Solutions Online and Offline Backups - Issues Ticketing Tools : SLA & OLA Concepts Incident Management and Ticketing Immediate, High and Medium Priority Levels of Support for Production DBA 3rd Party Tools and Real-time Use Automated Backups, Log File Readers Licensing and Pricing Options, CALs Device CALs and User CALs Multiplexing with Server Licenses

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 10: 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 19: 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 - Usage and Options
Replication Scripts, Adding Articles
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 11: 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 20: REPLICATION For HA - Level 2

Merge Replication and Merge Agent Job
Replication Conflicts and ROWGUIDCOL
Subscription Reinitialization, Expiry Setting
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
Common Errors and Solutions

Ch 3: SQL BASICS For DBAs - 2

Creating Databases in SQL Server
Database Connections and Usage
Creating Tables and Data Storage
Data Inserts and SELECT Statement
WHERE Conditions and Keywords
IN Operator and NOT IN Operator
Between, Not Between Operators
LIKE and NOT LIKE Operators

UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
Table Structure Modifications
ADD, ALTER and DROP Columns
Aliases and Batch Statements

Ch 12: 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 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 21: 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
Disconnections and Delay in Restores

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
Common Errors and Solutions

Ch 4: SCHEMAS, TEMPORARY TABLES

Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retreival and Usage with Schemas
Table Migrations across Schemas

Import and Export Wizard in SSMS
Data Imports with Excel File Data
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 13: 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 22: 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 Errors and Solutions

Ch 5: CONSTRAINTS, INDEXES Basics

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

Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sort Options, Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes - working with Keys

Ch 14: MIGRATIONS & SLA-OLA

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

SLA and OLA Process, Ticketing Tools
Immediate, High, Normal Priorities
Impact, Urgency and SLA Metrics
Licensing and Pricing Options
Core Based Licenses. Device CALs
User CALs and Multiplexing Concept
Versions, Editions Comparisons

Ch 23: CLUSTER CONFIGURATION

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
DNS Tools, Actions & Adding AA Hosts

SQL Clustering Service & RAID Levels
RAID Levels for Data Files & Log Files
SQL Cluster Groups, Domain Accounts
Active-Active, Active-Passive Clusters
Quorum and MSDTC Disks. LUN Grows
MSCS Service Startup Options, Drains
Need for Always - On Availability (AAG)

Ch 6: JOINS & AUDITS

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

Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Important Join Queries in T-SQL
Join Options: Merge, Loop, Hash

Ch 15: Tuning 1 - Audits, Indexes

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

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

Ch 24: ALWAYS ON AVAILABILITY

Always On Availability Group [AOAG]
Synchronous and Asynchronous Modes
Policy Based Management for AOAG
Facets and Conditions for Policies
Backup Preferences, Location Options
Synchronization, Automated Seeding
Data Synchronization for AOAG

Port Settings, Backup Strategies in AAG
AOAG Verifications and Dashboards
Adding Availability Replica, Database
Adding Availability Listeners and DNS
Automated Failovers, Manual Failovers
Always-On Availability Groups Health
AAA Hosts, Forward Lookup Zones

Ch 7: View, Procedures, UDF Basics

Views : Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
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()

Variables & Parameters in SQL Server
Procedures : Types, Usage in Real-time
User & System Predefined Procedures
Parameters and Dynamic SQL Queries
Sp_help, Sp_helpdb and sp_helptext
sp_pkeys, sp_rename and sp_help
sp_recompile, Perrformance Benefits
System Objects for Metadata Access

Ch 16: Tuning 2 - INDEX MANAGEMENT

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
Statistics : Audits and Updates
Working with Indexes and Partitions

Internal and External Fragmentation
Index Rebuilding Process and Audits
Database Maintenance Plans Jobs
Last Used, Page Count, Fragmentation
Index Page Count and Index Condition
Degree Of Parallelism [DOP] Settings
Resumable Indexes: ONLINE, RESUME
PAUSE & RESUME in Index Rebuilds

Ch 25: PATCHES, UPGRADES, CUs

Establishing Downtime For Maintenance
Precautions for Maintenance Activities
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
Service Startup Issues and Solutions

Ch 8: Transactions, Linked Servers

Linked Servers and Real-time Usage
Creating Linked Servers in SQL Server
Security Options and Access Options
Data Access, RPC and RPC Out Settings
Automations with Triggers: DML,DDL
INSERTED, DELETED Memory Tables
Table Data Replication using Triggers

Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
SQL Server Configuration Manager Tool
Services : Start and Stop Options
Network Configurations and Protocols
SQL Server Instance: Ports, Aliases

Ch 17: Tuning 3 - Tuning Tools, Locks

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

NUMA Nodes, Processor, IO Affinity
Thread Count, Degree of Parallelism
LOCKS : Types and Isolation Levels
S, X, IX,U, MD, Sch-M and Sch-S
Lock Audits : SP_WHO2 and SP_LOCK
sysprocesses and Lock Waits : Audits
Deadlock Audits and Deadlock Graphs
XDL Files and Deadlocks Prevention

Ch 26: SQL DBA PROJECT - Level 1

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
Metadata Sync-up Issues
Stored Procedure Recompilations
Backup and HA-DR Strategies
Db Restores and DB Repairs
Health Checks, Issues, Solutions

Ch 9: 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 Extents
Transaction Log File [LDF], LSN, VLF

Ch 18: 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 EstimateOnly
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
DBCC ShrinkDB and Page Restores

Ch 27: SQL DBA PROJECT - Level 2

Server Down Issues and Solutions
Database Down Issues and Solutions
Data Missing Issues and Solutions
Hot CPU and Resource Allocations
Port Level Issues and Solutions
Online and Offline Backups - Issues

Ticketing Tools : SLA & OLA Concepts
Incident Management and Ticketing
Immediate, High and Medium Priority
Levels of Support for Production DBA
3rd Party Tools and Real-time Use
Automated Backups, Log File Readers
Licensing and Pricing Options, CALs
Device CALs and User CALs
Multiplexing with Server Licenses

Module IV : AZURE SQL DATABASE	Module V : AZURE SQL DBA
Ch 28: AZURE CLOUD INTRO, CONFIGURATION Introduction to Cloud. Need for Cloud, Advantages Cloud Architecture Basics - IaaS, PasS and SaaS Advantages of Microsoft Cloud - Azure Platform Azure Products and Azure Services - MarketPlace SQL Database Implementations in Azure Platform Logical Servers, Virtual Machines, Managed Instance Installing SSMS and Azure Data Studio (ADS) Tools Creating Azure Account and Free Subscriptions Creating Azure SQL Server (Logical Server) Firewall Settings for Azure SQL Server (Logical Server) Adding Firewall Rules - IP for Remote Access Server Properties and Status Check. Server Name Format Password Resets and Azure SQL Server Name Format Creating Azure SQL Databases and Pricing Tiers Azure SQL Database Access from SSMS Tool	Ch 33 : HA - DR LEVEL 1 Failover Groups and Active Geo-Replication Read-Write Failover Policy, Automated Failover Geo Replication Configurations - Azure Locations Primary-Secondary and Read / Write Modes GeoReplication : Monitoring and Forced Failover Azure Server Failover Process, Strategies Automated Failover , Manual & Forced Failover Backup Errors, Geo Replication Errors - Solutions SQL Data Sync Service and Sync Groups HUB, MEMBER and SYNC DATABASE Sync Direction, Sync Schema and Sync Interval bi-directional Load Balancing and Failover Conflict Resolution Policy with HUB and MEMBER Cloud to Cloud / On-Premise Synchronization Hub to Member and Member to Hub Sync Policies
Ch 29 : DTU, ELASITC QUERIES, MIGRATIONS Azure Storage : Types, Creation & Containers LRS, GRS and RA-GRS Azure Storage Accounts Storage Containers, Storage Explorer Tool Usage Data Migration and Database Migration in Azure Data Migration Assistant (DMA) Tool, Assessment Data / Database Migrations To Azure SQL Database Exports and Imports in Azure with bacpac Migration Scopes : Schema, Data, Schema & Data Schema Generation and Compatibility For Migration Data Migration Verification and Row Counts DTU : Data Transaction Unit, Resource Allocations Basic, Standard and Premium Plans For SQL DB vCore Based Purchasing : Gen 4 and Gen 5 Types General Purpose and Business Critical Plans Compute Tier : Provisioned and Serverless Bounding Box Model, Elastic Pools & Queries eDTUs and Elastic Pool, per Database Settings Elastic Scaling with Azure SQL Databases	Ch 34 : HA - DR LEVEL 2 Azure AlwaysOn with SQL Server Clusters Primary Node and Secondary Node Clusters SQL Server Virtual Machines and Settings Domain Controller (DC) Virtual Machines Witness File Share (WFS) Settings in DC Azure Server Failover Process, Strategies Adding Databases to Failover Group Always On Health Check Reports (AOAG) Configuring and Using Azure Always-On Load Balancing with Azure Always-On Azure Cloud Shell - PowerShellGet, Versions Power Shell Scripts for Configurations Power Shell Scripts for Job Schedules Power Shell Scripts for Firewall, ARM Azure CLI - Purpose, Real-time Use Command Line Interface for Automations Azure telemetry Commands and Usage Help, Show, Create and Firewall Commands
Ch 30 : 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 Query Performance Insight, 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 Level Recommendations and Query Costs Azure Search Service Configuration, Pricing Tiers Azure Search for Data Import and Indexer Options Suggester and Analyzer Index Modes for Tuning Retrievable, Facetable, Filterable Indexes Facetable and Searchable Indexes for Tuning Change Tracking Options, Watermark Columns Full Text Search : Performance Advantages	Ch 35 : SECURITY MANAGEMENT, RLS Firewall and Virtual Network Configurations Server-level Firewall & Database Firewall Rules System Stored Procedures for Firewall Settings Logins, Users, Roles and Permissions using T-SQL Creating Logins without Logins. Containment Users GRANT, DENY, REVOKE, WITH GRANT Permissions Role Level and Schema Level Security in Azure Threat Detection, Transparent Database Encryption Vulnerability Assessment, Dynamic 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 options for RLS. STATE ON/OFF Dynamic Data Masking with Azure SQL Database Implementing DDM with Azure Portal & T-SQL
Ch 31 : XEL GRAPHS, STRETCH DATABASES SQL Traces : Creation and Audits. Limitations SQL Traces : Event Class, Category, Filter, Conditions Extended Events Package, Target, Action, Session TSQL and SP Debug Events with Global Fields XE Objects : Catalog & Dynamic Management Views XE Profiler - Templates for Event Profiling (Audits) Comparing XE Profiler with SQL Profiler Tool Comparing Azure SQL Database with On-Premise Stretch Databases in Azure SQL Databases Stretch Databases - Tuning Benefits, Cautions Table Level Migrations with Azure SQL Databases Compute Performance Levels and DSU Pricing Data Storage and Azure Database Snapshots Geo Backup Of Tables and Hybrid Cloud Settings Remote Data Archive Configuration in Azure Database Master Key [DMK], Cold Data Migration Real-time Advantages of Stretch Databases	Ch 36 : AZURE VIRTUAL MACHINE - WINDOWS IaaS, Azure VM. Install Azure Virtual Machines Install/Configure Windows Server, Redhat, Ubuntu SQL Server Azure VM - Config Settings, Elastic Pools Resource Groups, Resource Pools and eDTUs Verify SQL Instances in Azure VM. sysadmin Account Azure Storage Blades and Pricing Options Azure VM - Settings, DB Creation in Azure VM On-Premise & Azure Virtual Machines: Similarities SSMS, SQL Server Instance, Agent in Azure VM Azure Virtual Machines ; Security Options Azure SQL Database in VM to SQL Cloud Azure SQL Database in VM to on-Prem Deployment Automation Process, Automation Scripts SQL Database in AWS and Google Cloud Azure Virtual Machine Configuration Settings Azure SQL Database Advantages in Virtual Machines Public Access with SQL Server Instance, Security
Ch 32 : 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 (bacpac) Backups - Retentions, Audits. LTR Policy Restore Points and Azure SQL Database Recovery Geo-Redundant Backups and Advantages in Azure Restore Options and DB Creations with LTR Azure Storage Explorer Tool using Backups Disaster Recovery (DR) Advantages in Azure	Ch 37 : LINUX VM, MANAGED INSTANCES SQL Server on LINUX - RHEL (Red Hat Linux) Advantages of LINUX RHEL Over Windows LINUX RHEL Security Management, Firewall Storage, vCores and Storage Options in VM RHEL Clusters for SQL Server on LINUX Failover Mode and Node Majority - TCP Deployment Models and Azure Resource Manager RHEL Cluster Resource Manager Settings Pacemaker and SQL Server Nodes in AG SQL Database Managed Instance - TDE Native Virtual Networks and Scalability Lift - Shift LOB Applications, PaaS Infrastructure Frictionless Migration for On-Premise vCore Purchasing Model for Azure SQL DB Gen 4 and Gen 5 Logical CPUs, Resource Limits Managed Instances Vs AWS & Google Cloud Cell Level Encryption and Always-Encrypted
Chapter 38 : MCSA Certification Guidance with Resource Governor, Policy Based Management, Real-time Project for your Resume, Job Work