Sale Date Ended
Day 1: RDBMS Intro, MS SQL DBA Roles and Responsibilities & Course Outline
Day 2: SQL Server Versions, & Editions, H/W & S/W Requirements,
Firewall Configurations, SSMS Tool, System Configuration.
Types of Installations & Instances
Installation and Overview of Connectivity
Installation Errors and Checks
Day 3: Service Packs & Hotfixes: Precautions for Maintenance Activities.
Cumulative Updates (CU), Hotfix Process, App Testing and Rollbacks
Day 4: SQL Server Architecture & Storage Architecture
Day 5: Database Architecture/Checkpoint/Lazy Writer/Dirty Pages/ Indirect Checkpoint & T-Log Architecture
Day 6: Databases & Properties, Recovery Models, Moving the DB Files from one location to another location
Day 7: Backups
Backup Process, Database Backups, Filegroup Backups, File Backups, Copy Only Backups.
Day 8: Partial Backups, Split Backups, Mirrored Backups.
Backup Options, Media Options and Compression. Backup Audits From MSDB
Day 9: Maintenance Plans - Routine Backups and Maintenance Cleanup.
Database Mail Configurations. Agent Operators and Job Notifications
Day 10: Restoration
Restore Phases (Copy, Redo, Undo), Recovery and NoRecovery Options. Standby Backup Files and Point In Time Restores
VERIFYONLY, FILISTONLY, HEADERONLY. Partial Restores and Tail Log Backups.
MOVE Options for File / File Group Level Restores
Day 11: Automation
SQL Server Agent Service and Agent XPs. Job Steps - Creation, Edits and Parse.
Job Failures and Job History. History Purge
Day 12: Security (Logins, Users, Permissions, Roles)
Authentication Types - Windows, SQL Server.
Logins, Users, Roles, Schemas. Grant, With Grant, Deny, Revoke. Keys, Certificates. Job Security.
Orphan Users & Fixing
Day 13: Monitoring (Activity Monitor, Task Manager, Reports, Perfmon)
Day 14: Log Shipping, Theory, Configuration, Troubleshooting, Monitoring
LOG SHIPPING (HA - DR) : Primary and Secondary: Recovery Plan. Log Shipping Monitor, Jobs and Alerts. NORECOVERY & STANDBY
Log Shipping Mode Changes - cautions. Re-Restoring Log Backups. LSBackup, LSCopy & LSRestore Jobs. TUF Files. Broken Log Sequence
Day 15: DB Mirroring Theory, Configuration, Troubleshooting, Monitoring
DB MIRRORING (HA - DR) : DB Mirroring Architecture For HA & DR. TCP Endpoints, TCP Network Security. Automatic Fail-Over Tests
SYNCHRONOUS & ASYNCHRONOUS Transfer Modes. Mirroring Monitor, Stop/Resume Options. DB Mirroring - Errors and Solutions
Day 16: Import/Export/Attach/Detach/Server Properties/DB Properties
Maxdop/Fill Factor/Cost Threshold Parallelism/Server Configurations
Day 17: Upgradation (In-Place)
Server Upgrades: Server Upgrades, Version Changes. System Database REBUILDs.
DAC: Dedicated Admin Console. Upgrade Rollbacks
Day 18: Migration (Side by Side)
Database Migrations: Using Database Detach and Attach Options. Database Migration Jobs
Day 19: REPLICATION For HA - LEVEL 1 :
Replication Architecture and Topology, DB Articles, Publications, Subscriptions, Replication Monitor
Snapshot Replication and Repl Agents, PUSH, PULL Subscriptions. N/W Shares, Log Reader Agent, Tracer Tokens, Replication Warnings
Day 20: REPLICATION For HA - LEVEL 2 : Merge Replication & Merge Agent Job,
Peer-Peer Replication Connections, Nodes. Conflict Detection
MSSQL_ENGXXXXX Errors & Solutions. Replication Priority. Disabling,
Cleaning Replication. Replication Strategies for HA and DR Plan
Day 21: AlwaysOn Lab setup & Configuration Part-1
Day 22: AlwaysOn Patching Part-2
ALWAYS ON AVAILABILITY (AAG): Synchronous and Asynchronous Modes. Synchronization, Automated Seeding. AOAG Health Check
AOAG Dashboards, Forward Lookup Zones. Availability Replica, Availability Listeners and DNS. Automated Failovers, Manual Failovers
Day 23: Cluster Lab setup Part-1
CLUSTER CONFIGURATION: Windows Clusters For HA and DR.
Domain Controller (DC) Configuration. Active Directory (AD) Accounts
Day 24: Cluster Installation Configuration Part-2
SAN [Storage Area Network] and LUN. Public & Private IP.
SQL Clustering Service. Active-Active, Active-Passive Clusters
Day 25: Locking, Locks and Lock Types. Transaction Isolation Levels
Day 26: Blocking/Deadlocks & Troubleshooting, Deadlocks and Live Locks
Day 27: Indexing
INDEX MANAGEMENT, LOCKS - Internal Fragmentation and External Fragmentation. Index Rebuild & Reorganize
Day 28: CPU/Memory/IO Issues and Troubleshooting
Day 29: Database Health Checks: DBCC Commands, Allocation Errors, Consistency Errors.
DBCC for Object Level Integrity, DBCC Page
Alerts: Notifications Configuration. Solutions to Allocation Errors,
Consistency Errors, Log Space Issues, Tempdb Issues
Day 30: Miscellaneous