SQL Server DBA Certification Training

✔ SQL Server DBA 2019 Installation
✔ Server Components and Purpose
✔ New features of SQL Server 2019
✔ Service Accounts, Purpose, and Usage
✔ Authentication Modes & Logins
✔ Instance Configuration Options
✔ Management Studio (SSMS) Tool Usage
✔ Troubleshooting the failed Instance

✔ Establishing Downtime For Maintenance
✔ Service Packs and Patch/hotfix Activities
✔ Pre & Post Database Maintenance Activities

✔ Steps for doing the Side-by-Side Migration
✔ Migration with Backup and Restore Method
✔ Migration of the Logins and Fixing Orphan users
✔ Merits/Demerits of the side by Side Migration
✔ Import and Export utility
✔ Scripts for copying the tables with data

✔ Configuration of the Network Protocols
✔ Dedicated Administrator Connection(DAC) configuration
✔ What is RAID Levels and choosing the Best suited for All DBs
✔ Database Configurations
✔ Attaching and detaching SQL Server DBA

✔ What is TempDB
✔ Corruption of TempDB
✔ How to troubleshoot and avoid common tempdb issues

✔ Starting and Stopping the SQL Server Services
✔ Configuration Manager
✔ Net commands
✔ Command Prompts and SQL CMD
✔ Starting the Dbs in Single-user Mode

✔ What is a database and a database management system (DBMS)
✔ ACID Properties
✔ The Life Cycle of a Query
✔ The Relational and Storage Engines
✔ Recovery
✔ Difference between Checkpoint and LazyWriter
✔ Types of System Dbs
✔ Startup Parameters
✔ Licencing of SQL Server DBA

✔ Pages & Types of Pages
✔ Extents and Types of Extents
✔ Managing Extents

✔ Data Files: Purpose and Storage
✔ Filegroups: Purpose and Usage
✔ Shrinking the log files
✔ File growth and MAXSIZE Options
✔ Scripting Database Structures

✔ Security
✔ Security Architecture
✔ Fixing the Server Roles
✔ Creating Logins
✔ Fixed Database Roles
✔ Database Users

✔ SQL Server Agent and Monitoring the Agent logs
✔ Troubleshooting the Jobs with help of Logs and Event Logs
✔ Steps for creation of Jobs with different steps.
✔ Job Activity Monitor and History Deletes
✔ Database Maintenance Plans.
✔ DB Maintenance Strategies & Schedules

✔ Monitoring tools used for SQL Server Monitoring
✔ Log file Viewer and Maintenance of Log File Viewer
✔ Activity Monitor
✔ Database reports
✔ Monitoring Processes in T-SQL
✔ sp_who and sp_who2
✔sys.dm_exec_connections

✔ Backups with T-SQL Scripts
✔ Backups Concept and Mechanism
✔ Data Backups – Syntax and Types
✔ Log Backup Mechanism and Use
✔ COMPRESSION, CHECKSUM, and STATS
✔ Scheduling Backups & Strategies
✔ FILELISTONLY and VERIFYONLY Options
✔ COPY_ONLY Backups and Importance

✔ Compatibility, Recovery Model Options
✔ Working with Recovery Models & Backups
✔ Point-In-Time Restores & Recovery
✔ Overwrite Options for DB Restores

✔ Log Shipping
✔ Log Shipping Overview
✔ Configuration of the Log Shipping
✔ Deploy Log Shipping

✔ DB Mirroring Architecture & Use
✔ Mirroring Configuration Scenarios
✔ Backups & Restores for Mirrors

✔ Architecture
✔ Availability Group Replicas and Roles
✔ Availability Modes
✔ Types of Failover Supported
✔ Allowing Read-Only Access to Secondary Replicas
✔ Availability Group Example
✔ Configure a New Availability Group
✔ Configure an Existing Availability Group
✔ AlwaysOn Group Dashboard

✔ Understanding SQL Clustering Need
✔ SQL Server Clustering Architecture
✔ Windows Server Installation Options

✔ SQL Server Cluster Installation (VM)
✔ Add Nodes to SQL Server Cluster

✔ Replication Overview
✔ Replication Components
✔ Replication Types
✔ Implementing Replication
✔ Implementing Transactional
✔ Replication Monitor

✔ Understanding the Memory
✔ Windows and Memory
✔ Physical Memory
✔ SQL Server Memory
✔ Understanding Wait Statistics

✔ Locks a currency
✔ Lock Types
✔ Blocking and how to monitor the blocking
✔ DMVs for monitoring the blocking

✔ Table and Index Architecture
✔ Cluster and Non-Cluster indexes
✔ What is Heap
✔ Cluster index structure
✔ Index fragmentation

✔ Common Causes of High CPU Usage
✔ Outdated statistics
✔ I/O
✔ Disks
✔ Performance counters for Disk I/Os