WHAT IF I MISS A CLASS?

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that particular session.

HOW DO I JOIN THE LIVE SESSIONS?

Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

WHAT IF I HAVE QUERIES AFTER COMPLETION OF THE CLASS?

You can contact our support team, or just drop an email to online@akswave.com with your queries.

HOW WILL I EXECUTE THE PRACTICAL?

For practical execution, our trainer/technical team will provide server access details to the student.

IS THE COURSE MATERIAL ACCESSIBLE AFTER COMPLETION OF THE COURSE?

The course material and recorded videos which are provided during the course period. You can download it anytime.

WILL YOU HELP US IN BUILDING OUR OWN LAB SETUP IN OUR LOCAL DESKTOP / LAPTOP?

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

ANY OFFER/DISCOUNT THAT I CAN AVAIL?

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant.& special discount for 2 or more participants.

WHAT IS THE DIFFERENCE BETWEEN LIVE ONLINE AND PRE-RECORDED VIDEOS TRAINING?

Live-Online training is where you can have live session with the trainer and clarify queries parallelly. Pre-recorded sessions are the recorded videos that will be provided to you so that you can see, listen and learn anytime at your feasible place. For doubts in the videos you can mail the trainer regarding the same.

WILL I GET THE REFUND IF I CANCEL MY ENROLLMENT?

If request for cancelation is made within 2 days of enrolment for class, 100% refunded. If request made after 2 days, then Refund is made after deduction of administration fee.

✅Best SQL Server DBA Training Institute [Top-Rated & Certified]

MS SQL Server DBA

Master SQL Server DBA with ✅ #EXP yrs of Certified expert trainer. Enjoy ✅ #SESS hrs of live interactive sessions, ✅ #LAB+ hrs hands-on labs, ✅ #REC+ hrs recorded videos & 24/7 lab access. Get real-time scenarios, in-depth course materials & certification guidance to boost your SQL Server DBA career with practical skills & industry insights.

14+ yrs Experience Trainer

Hands-on Lab Practice

55+ hrs Recording Access

24×7 Lab Access

Real-Time Projects

Career & Interview Support

COURSE CURRICULUM

36+ Course Topics • Hands-on Labs • Real-Time Practice

Module 1 - Starting with SQL Server

01 Overview of SQL Server & DBA Roles Topics

· Responsibilities of a Database Administrator

· Types of DBAs, SQL Server Version History

· What's New in SQL Server 2022 for DBAs

02 SQL Server Editions and Requirements Topics

· Editions of SQL Server

· Enterprise vs. Standard Editions

· Hardware and Software Requirements

03 Understanding Instances Topics

· Advantages of Instances

· Types of Instances:

- Default Instance & Named Instances

Module 2 - Installing and Configuring

04 Installing SQL Server 2022 Topics

· Pre-Installation Steps

· Installation Process

· Viewing Installation Log Files

· Common Installation Issues

· Adding or Removing Components

· Installing Service Packs

05 Post-Installation Configuration Topics

· Configuring Services and Startup Parameters

· Setting Data and Log File Paths

· Memory Configuration

· Enabling Remote Connections

· Configuring Network Protocols and Ports

· Setting Default Backup Folder

Module 3 - Working with Databases

06 Understanding Database Types Topics

· System Defined Databases

· Moving System Databases

· Managing TempDB

07 SQL Server Database Architecture Topics

· Data Files, Log Files, Filegroups

· Extents and Page Architecture

· Tracking Free Space

· Troubleshooting Log File Full Issues

08 Creating and Managing Databases Topics

· Creating Databases

· Adding Files and Filegroups

Module 4 - Security in SQL Server

09 Authentication and Logins Topics

· Security Enhancements

· Windows Authentication:

· Creating Logins from Windows Users and Groups

· Orphan Logins

· SQL Server Authentication:

· Creating and Testing SQL Logins

· Setting Authentication Mode

10 User and Role Management Topics

· Understanding Server Roles

· Working with Users

· Resolving Orphan Users

· Understanding Database Roles

· Understanding Permissions

11 Auditing and Troubleshooting Topics

· Security Auditing

· Common Security Issues

Module 5 - Backup and Restoration

12 Recovery Models Topics

· Full

· Bulk Logged

· Simple

13 Backup Types and Strategies Topics

· Why We Need Backups

· Backup Types:

· Full

· Differential

· Transaction Log

· File or Filegroup

· Copy-Only, Mirrored, and Tail Log Backups

· Backup Devices

· Backup of System Databases

14 Restoration Techniques Topics

· Performing Restorations

· Point-in-Time Recovery

· Viewing Backup Details

· Troubleshooting Backup Issues

15 High Availability Overview Topics

· Introduction to High Availability

Module 6 - Working with Log Shipping

16 Log Shipping Essentials Topics

· Features and Jobs

· Requirements for Implementation

17 Configuring and Monitoring Topics

· Configuring Log Shipping

· Monitoring and Manual Failover

· Transferring Logins

18 Internals and Troubleshooting Topics

· Log Shipping Tables and Stored Procedures

· Handling Issues

Module 7 - Always ON

19 HADR Configuration Topics

· Internals and Advantages

· Setting up HADR and Adding DB to AG

20 AG Management Topics

· Adding Replica in AG

· Setting up Listener and Read-Only Replicas

21 Maintenance and Troubleshooting Topics

· Patching in Always On

· Troubleshooting and Maintenance

Module 8 - Replication

22 Replication Basics Topics

· Introduction and Advantages

· Replication Entities and Architecture

· Replication Agents

23 Types and Configuration Topics

· Snapshot, Transactional, Merge, Peer-to-Peer Replication

· Configuring and Managing Replication

24 Monitoring and Tuning Topics

· Monitoring and Tuning Replication Performance

Module 9 - Failover Clustering Instances

25 Clustering Concepts Topics

· Failover Clustering Overview

· Windows Clustering Overview

· Requirements

26 Cluster Setup and Management Topics

· Installation and Configuration

· Applying Service Packs and Fixes

· Moving Groups

· Adding Nodes

· Troubleshooting Cluster Issues

Module 10 - Automating Administrative Tasks

27 Maintenance Plans and Database Mail Topics

· Maintenance Plans

· Configuring Database Mail:

· Architecture

· Profiles and Accounts

· Sending Mails

28 Automation and Job Management Topics

· Configuring SQL Server Agent

· Creating Operators, Alerts, and Jobs

· Managing and Monitoring Jobs

· Auto Alerts for Job Status

Module 11 - Advanced Administration Concepts

29 Performance and Index Management Topics

· Database Indexes and Defragmentation

· Health Checks

30 Monitoring and Troubleshooting Tools Topics

· SQL Server Profiler and Extended Events

· Traces and Configurations

· Monitoring Tools:

· System Monitor

· Database Engine Tuning Advisor

· Dynamic Management Views (DMVs)

· SQL Server and Windows Error Logs

31 Performance Tuning Topics

· Troubleshooting Locks and Deadlocks

· Transaction Isolation Levels

· Blocking and Terminating Processes

· Using DAC

· Managing Databases

Module 12 - Microsoft Azure SQL Database

32 Provisioning and Pricing Topics

· Creating Azure SQL DB

· DTU vs. vCore Models

33 Migration and Backup Topics

· Migrating SQL DB to Azure using DMA & DMS

· Automatic and Manual Backups

34 Restoration Methods Topics

· Point-in-Time, Long-Term, Deleted DB Restore

· Geo-Restore and Importing Databases

35 Scaling and High Availability Topics

· Vertical and Horizontal Scaling

· Zone Redundancy and DR Options

· Geo-Replication and Auto-Failover

36 Monitoring and Tuning Topics

· Azure Portal Monitoring

· Query Performance Insight

· Monitoring with DMVs

· Tuning Azure SQL Database

HANDS-ON LABS YOU WILL WORK ON

SQL Server Installation

Server Configuration

Security & Permissions

Backup & Recovery

Performance Tuning

Always On & Failover

Monitoring & Troubleshooting

Migration & Maintenance

24×7 Access to Dedicated Cloud Lab

Enquire Now

Download Brochure

MS SQL Server DBA

COURSE OVERVIEW

WHO SHOULD JOIN?

CAREER OUTCOMES

PRACTICE LIKE A REAL PROFESSIONAL