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 MS SQL Server DBA Training in Mumbai [TOP-RATED]

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

MEET YOUR TRAINER

Uday Kumar

SQL Server DBA Consultant & Corporate Trainer

Experience: 14+ Years

Specialization: SQL Server Administration, High Availability, Performance Tuning, Cloud & Migrations.

Professional Summary

Uday Kumar is a seasoned SQL Server DBA & Trainer with over 14 years of hands-on experience in SQL Server Database Administration and 9+ years in professional training. He has successfully trained 50+ batches of students and IT professionals, enabling them to build strong careers in the database domain.

As an experienced SQL Server DBA Trainer, [Trainer Name] has successfully delivered numerous training batches and mentored IT professionals in SQL Server Database Administration. His training approach combines hands-on practice, real-world database scenarios, and practical industry insights, making him a trusted mentor for aspiring and working SQL Server DBAs.

Certifications

EDB PostgreSQL Professional Certification
EDB PostgreSQL Advanced Certification
EDB PostgreSQL Administration Certification
PostgreSQL High Availability & Replication Certification
PostgreSQL Performance Tuning Certification
PostgreSQL Backup & Recovery Certification
AWS Certified Database – Specialty
Microsoft Azure Database Administrator Associate
Google Cloud Professional Cloud Database Engineer

Technical Expertise

Microsoft SQL Server Database Administration

SQL Server Installation & Configuration

Database Backup & Restore

High Availability & Disaster Recovery (HA/DR)

Always On Availability Groups

Failover Clustering

Database Mirroring & Log Shipping

Performance Tuning & Query Optimization

SQL Server Security Administration

STUDENT SUCCESS STORIES

Student Student

★★★★★

8734 learner reviews are currently available for this course.

Enquire Now

Download Brochure

MS SQLServer DBA in Mumbai

COURSE OVERVIEW

WHO SHOULD JOIN?

CAREER OUTCOMES

Develop practical skills for career opportunities such as:

PRACTICE LIKE A REAL PROFESSIONAL