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 Maintenace 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 Shiping

✔ Log Shipping Overview

✔ Configuration of the Log Shipping

✔ Deploy Log Shiping

✔ 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