SQL Server DBA Certification Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

Our SQL Server DBA Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities: Capacity Planning, Query Tuning, Index Management, Database Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management including Azure SQL DBA Activities like Azure Sync, Azure Server Failover, Azure Virtual Machines, and Azure DB Migrations. Enroll now and get certified in it.

SQL Server DBA Training Course Syllabus

Module 1: Installation, Upgradation, Configuration

✔ 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

SQL Server Upgrade and Hot Fixes and RollBack

✔ Establishing Downtime For Maintenance

✔ Service Packs and Patch/hotfix Activities

✔ Pre & Post Database Maintenance Activities

Upgradation: Side by Side Migration

✔ 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 SQL Server DBA 2016

✔ 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

TempDB

✔ What is TempDB

✔ Corruption of TempDB

✔ How to troubleshoot and avoid common tempdb issues

Managing The Services

✔ Starting and Stopping the SQL Server Services

✔ Configuration Manager

✔ Net commands

✔ Command Prompts and SQL CMD

✔ Starting the Dbs in Single-user Mode

Module 2: Architecture

✔ 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 &Extents

✔ Pages & Types of Pages

✔ Extents and Types of Extents

✔ Managing Extents

File and File Groups & Database Design Concepts

✔ Data Files: Purpose and Storage

✔ Filegroups: Purpose and Usage

✔ Shrinking the log files

✔ File growth and MAXSIZE Options

✔ Scripting Database Structures

Module 3: Security, Automation, and Monitoring

✔ Security

✔ Security Architecture

✔ Fixing the Server Roles

✔ Creating Logins

✔ Fixed Database Roles

✔ Database Users

Automation Administrative Tasks

✔ 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 SQL Server

✔ 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

Module 4: Backup and Restore

✔ 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

Backups, Restores and Recovery

✔ Compatibility, Recovery Model Options

✔ Working with Recovery Models & Backups

✔ Point-In-Time Restores & Recovery

✔ Overwrite Options for DB Restores

Module 5: High Availability and Replication

✔ Log Shiping

✔ Log Shipping Overview

✔ Configuration of the Log Shipping

✔ Deploy Log Shiping

SQL Server Mirroring

✔ DB Mirroring Architecture & Use

✔ Mirroring Configuration Scenarios

✔ Backups & Restores for Mirrors

SQL Server DBA Awayson Availability Groups

✔ 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

Windows Clustering

✔ Understanding SQL Clustering Need

✔ SQL Server Clustering Architecture

✔ Windows Server Installation Options

SQL Server DBA Cluster Configuration

✔ SQL Server Cluster Installation (VM)

✔ Add Nodes to SQL Server Cluster

Replication

✔ Replication Overview

✔ Replication Components

✔ Replication Types

✔ Implementing Replication

✔ Implementing Transactional

✔ Replication Monitor

Module 6: SQL Server DBA Performance and Optimization

✔ Understanding the Memory

✔ Windows and Memory

✔ Physical Memory

✔ SQL Server Memory

✔ Understanding Wait Statistics

Locking and Latches

✔ Locks a currency

✔ Lock Types

✔ Blocking and how to monitor the blocking

✔ DMVs for monitoring the blocking

Indexes Architecture

✔ Table and Index Architecture

✔ Cluster and Non-Cluster indexes

✔ What is Heap

✔ Cluster index structure

✔ Index fragmentation

CPU Utilization

✔ Common Causes of High CPU Usage

✔ Outdated statistics

✔ I/O

✔ Disks

✔ Performance counters for Disk I/Os

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

SQL Server DBA Training - Upcoming Batches

7th NOV 2022

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

SQL Server DBA Training FAQ'S

What do you mean by Extent in an SQL Server Database?

Extents in an SQL server database are the basic unit of measuring space for indexes and tables in the database. 

What are the contents of the page header in an SQL server database?

The contents of the page header are - Index of Data and Free Space.

What are the different types of System databases?

The different types of System Databases include:

  • Resource
  • TempDB
  • Distribution
  • Model
  • Master
  • MSDB

Get ahead in your career by learning SQL Server DBA through VISWA Online Trainings

What is the Syntax used to create an SQL database?

The syntax used to create an SQL database is - Create database <databasename>

How do you create databases with specific file locations in SQL?

This is one of the most common SQL Server DBA interview questions asked in technical interviews. To create a database with a specific file location, the following command is used:

Restore Database <database name> from disk='<Backup file location + file name>’

Reviews

vishal meda
vishal meda
2023-04-15
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
2023-04-01
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
2023-04-01
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
2023-03-27
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
2023-03-19
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
2023-03-15
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
HARIKRISHNA BANDLA
HARIKRISHNA BANDLA
2023-03-13
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
2023-01-18
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
2023-01-18
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links