ORACLE

★★★★★

(2,095 ratings) 50,000+ Student

MS SQL SERVER DBA

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. DBA is also responsible for DBA Activities.

Radical Technologies

50,000+ English 50 hours Weekdays / Weekends Classroom / Online / Corporate

Online / Classroom

MS SQL SERVER DBA

IT Training Programme

Duration 50 hours

Batch Type Weekdays / Weekends

Mode of Training Classroom / Online / Corporate

Locations Pune, Bangalore, Kochi

Language English

Certification Globally Recognized

Call Now

100% placement assistance

What you'll learn

Understand core concepts and architecture from the ground up

Get hands-on with the tools used by working professionals

Build real-world projects you can add to your portfolio

Learn industry best practices and coding standards

Practice with real datasets and real-world scenarios

Prepare for certification and technical interviews

Work on collaborative, team-based exercises

Apply performance tuning and optimization techniques

Understand how the technology fits into a larger ecosystem

Complete assignments reviewed by mentors

Programme Overview

19 sections covering the complete curriculum — a single, progressive learning arc.

50 hours

Training Duration

Core Modules

275

Total Lessons

4.4★

Average Rating

50K+

Students Trained

Foundations & Core Concepts

Get hands-on with the fundamentals and architecture — the building blocks for everything that follows.

Fundamentals Architecture Setup

Hands-On Practical Training

Work through real exercises and assignments designed to mirror what you will do on the job.

Practicals Assignments Labs

Real-World Projects

Apply what you have learned to end-to-end projects that go straight into your portfolio.

Projects Portfolio Case Studies

Advanced Techniques

Go beyond the basics with advanced concepts, integrations and production-grade practices.

Advanced Integration Best Practices

Ecosystem Integration

Understand how this technology connects with the broader tools and platforms used in the industry.

Ecosystem Tools Platforms

Performance & Interview Prep

Master optimization techniques and prepare for the technical interview questions employers actually ask.

Optimization Interview Prep Certification

Who is this programme for?

Whether you're already writing code, working with data, or supporting applications today — this programme is built to take you into a ORACLE role.

Software Developers

Engineers who want to add this skill set to their toolkit

Analysts & Consultants

Professionals moving into a more technical, hands-on role

IT Professionals

System admins and support engineers upskilling into a new domain

Fresh Graduates

CS/IT graduates aiming for a job-ready technical role

Course Curriculum

19 sections • 275 lessons • 50 hours

Jump to Section

Total Duration

50 hours

100% Practical · Unlimited Doubt Sessions

01 SQL Server & T-SQL installation, Architecture, DB Job Roles, Installation

Introduction to Databases, DBMS

Microsoft SQL Server : Advantages, Use

Versions and Editions of SQL Server

SQL DBA Job Roles, Responsibilities

Routine Maintenance DBA Activities

Emergency SQL DBA Activities

SQL Server Prerequisites : S/W, H/W

SQL Server 2019/2017/2016 Installation

Default Instance, Named Instances

Port Numbers, Instance Differences

Service and Service Account Use

Authentication Modes and Logins

Firewall Configuration in Real-time

SQLServr.exe and SQLBrowser.exe

02 SSMS Tool, SQL Basics

SSMS Tool Installation, Connections

SQL Server Management Studio

Single Server, Multi Server Connections

System Databases: Master and Model

MSDB, TempDB, Resource Databases

SQL and T-SQL : Basic Differences

DDL, DML, SELECT Statements

Using GUI and SQL Scripts in SSMS

Creating Databases : Files [MDF, LDF]

Creating Tables in SQL Server

Data Storage in Tables : Inserts

SELECT : Data Retrieval Statement

Table Scans. LIVE QUERY STATISTICS

Limitations with SSMS GUI Options

03 SQL for DBAs

Creating Databases in SQL Server

Database Connections and Usage

Creating Tables and Data Storage

Data Inserts and SELECT Statement

WHERE Conditions and Keywords

IN Operator and NOT IN Operator

Between, Not Between Operators

LIKE and NOT LIKE Operators

UPDATE Statement & Conditions

DELETE & TRUNCATE Statements

Logged and Non-Logged Operations

Table Structure Modifications

ADD, ALTER and DROP Columns

Aliases and Batch Statements

04 Schemas, Temporary Tables

Schemas : Group Tables in Database

Schemas : Security Management Object

Creating Schemas & Batch Concept

Using Schemas for Table Creation

Data Storage in Tables with Schemas

Data Retrieval and Usage with Schemas

Table Migrations across Schemas

Import and Export Wizard in SSMS

Data Imports with Excel File Data

Performing Bulk Operations in SSMS

Temporary Tables : Real-time Use

Local and Global Temporary Tables

# and ## Prefix, Scope of Usage

Session Level, Connection Level Use

05 Constraints, Indexes

Constraints and Keys – Data Integrity

NULL, NOT NULL Property on Tables

UNIQUE KEY Constraints: Importance

PRIMARY KEY Constraint: Importance

FOREIGN KEY Constraint: Importance

REFERENCES, CHECK and DEFAULT

Candidate Keys and Identity Property

Database Diagrams and ER Models

Relationships Verification and Links

Indexes : Basic Types and Creation

Index Sort Options, Search Advantages

Clustered and Non Clustered Indexes

Primary Key and Unique Key Indexes

Need for Indexes – working with Keys

06 Joins & Audits

JOINS – Table Comparisons Queries

INNER JOINS For Matching Data

OUTER JOINS For (non) Match Data

Left Outer Joins with Example Queries

Right Outer Joins with Example Queries

FULL Outer Joins – Real Time Scenarios

Join Queries with “ON” Conditions

Join Unrelated Tables in SQL Server

NULL, IS NULL Operators in Joins

CROSS JOIN and CROSS APPLY

CROSS JOIN Versus CROSS APPLY

One-way & Two Way Data Comparisons

Important Join Queries in T-SQL

Join Options: Merge, Loop, Hash

07 View, Procedures, UDF Basics

Views : Types, Usage in Real-time

System Predefined Views and Audits

Listing Databases, Tables, Schemas

Functions : Types, Usage in Real-time

Scalar, Inline and Multi-Line Functions

System Predefined Functions, Audits

DBId, DBName, ObjectID, ObjectName

Date and Time Functions : Getdate()

Variables & Parameters in SQL Server

Procedures : Types, Usage in Real-time

User & System Predefined Procedures

Parameters and Dynamic SQL Queries

Sp_help, Sp_helpdb and sp_helptext

sp_pkeys, sp_rename and sp_help

sp_recompile, Performance Benefits

System Objects for Metadata Access

08 Transactions, Linked Servers

Linked Servers and Real-time Usage

Creating Linked Servers in SQL Server

Security Options and Access Options

Data Access, RPC and RPC Out Settings

Automations with Triggers: DML,DDL

INSERTED, DELETED Memory Tables

Table Data Replication using Triggers

Transactions : Types, ACID Properties

Transaction Types and AutoCommit

EXPLICIT & IMPLICIT Transactions

COMMIT and ROLLBACK Statements

SQL Server Configuration Manager Tool

Services : Start and Stop Options

Network Configurations and Protocols

SQL Server Instance: Ports, Aliases

09 Server, DB Architecture

Server Architecture and Protocols

Database Engine and Query Processor

Parser, Optimizer, SQL & DB Manager

Storage Engine Components, SQL OS

File Manager and Database Files

Transaction Services, Buffer Manager

Lock Manager, IO Manager, MDAC

CLR, WAL, Lazy Writer, Checkpoint

Database Architecture – Data Files

Database Architecture – Log Files

Primary (mdf), Secondary Files (ndf)

Filegroups Usage, ReadOnly Filegroups

Database Files : Size and Location

Pages, Extents. Uniform, Mixed Extents

Transaction Log File [LDF], LSN, VLF

10 SQL DBA – Backup-Restores, Jobs, Performance Tuning, Security : Backups – DB, Filegroup, File

Database Backups, Filegroup Backups

Log File Backups and Log Truncations

COPY_ONLY Backups and Real-time Use

Mirror Backups and Split Backups

Partial Backups – ReadOnly Filegroups

Format, Compression and Checksum

Backup Verification, RetainDays, Stats

ContinueOnError and Backup Scripts

GUI and Script Backups: Differences

Backup History Tables in MSDB – Joins

Backup Audits. HOT and COLD Backups

Backup Devices – Creation and Usage

Using Backup Devices – Advantages

Common Errors and Solutions

11 Restores & DB Recovery

Restore Phases – COPY, REDO, UNDO

RECOVERY, NORECOVERY Options

STANDBY and REPLACE in Restores

File, File Group & Metadata Restores

Backup Verifications using GUI, Scripts

VERIFYONLY : Backup Verification

STATS, UNLOAD, STOPAT and INIT

PARTIAL / PIECEMEAL Restores – Use

Tail Log Backup Usage in Real-time

Restores using GUI and T-SQL Scripts

MOVE Options for File Level Restores

Point-In-Time Restore, Checkpoint LSN

Standby Restores and Read-Only State

Common Errors and Solutions

12 Jobs, Maintenance Plans

SQL Server Agent Service & Agent XPs

SQL Agent Jobs – GUI, Script Creations

Job Steps – Creation, Edits and Parse

Job Executions, Disable/Enable Options

Job History Purge. Job Activity Monitor

Database Maintenance – Backup Jobs

Scheduling Database Maintenance Plans

Automated Job Creations using DMPs

Backup Cleanup & History Cleanup Jobs

Backup Strategies For Minimal Data Loss

Backup Options: Block Size, Transfer Size

DB Mail Configurations and Alert System

DB Mail Profiles, SMTP Email Accounts

Operators : Creation, Job Notifications

13 Security Management

Authentication Types & Modifications

Windows Logins & SQL Server Logins

Logins – Users Mapping, DB Access

Server Roles & Database Roles – Usage

Object, Column and Schema Security

GRANT, WITH GRANT, DENY, REVOKE

CONTROL, OWNERSHIP, Authorization

Data Encryption: Keys and Certificates

Data Encryption with Stored Procedures

Job Security : Credentials and Proxies

Using Proxies for SSIS Jobs, Repl Jobs

Security Scripts and Documentation

DMVs for Security Audits, Orphan Users

14 Migrations & SLA-OLA

CDW : Copy Database Wizard @ SSMS

Database Detach and Attach Options

SMO Method and Database Scripting

CDW SSIS Packages, SSIS Proxies Use

Scheduling Database Migration Jobs

Detecting and Resolving Orphan Users

Containment Databases Authentication

SLA and OLA Process, Ticketing Tools

Immediate, High, Normal Priorities

Impact, Urgency and SLA Metrics

Licensing and Pricing Options

Core Based Licenses. Device CALs

User CALs and Multiplexing Concept

Versions, Editions Comparisons

15 Tuning 1 – Audits, Indexes

Audit Long Running Queries : DMV, DMF

Activity Monitor Tool, Server Dashboards

Logical I/O, Physical I/O, Database I/O

Recent Expensive Queries, Wait Time

Active Expensive Queries, Statistics

Plan Handle, Execution Time – Audits

CPU, IO, Memory Consumption Reports

Indexes: Architecture and Index Types

B Tree Structure, IAM Page [Root]

Clustered & NonClustered Indexes

Included, Columnstore, Online

Filtered, Covering, Indexed Views

Fill Factor and Pad Index Options

Query Store – Settings and Advantages

16 Tuning 2 – Index Management

PARTITIONS : Advantages, Performance

Partition Functions & Partition Schemes

Partitioning Un-partitioned Tables: GUI

Partition Compression : ROW and PAGE

Auditing Table Partitioned Structures

Statistics : Purpose, Auto Creation

Statistics : Audits and Updates

Working with Indexes and Partitions

Internal and External Fragmentation

Index Rebuilding Process and Audits

Database Maintenance Plans Jobs

Last Used, Page Count, Fragmentation

Index Page Count and Index Condition

Degree Of Parallelism [DOP] Settings

Resumable Indexes: ONLINE, RESUME

PAUSE & RESUME in Index Rebuilds

17 Tuning 3 – Tuning Tools, Locks

Tuning Tools : Workload Files, Trace Files

Profiler Tuning Template, SP Events

DTA, Profiler Trace : Recommendations

Perfmon Tool Counters, Real-time Tracking

Execution Plan Analysis and Internals

Query Costs : IO Cost and CPU Cost

Query Costs: SubTree & Operator Cost

NUMA Nodes, Processor, IO Affinity

Thread Count, Degree of Parallelism

LOCKS : Types and Isolation Levels

S, X, IX,U, MD, Sch-M and Sch-S

Lock Audits : SP_WHO2 and SP_LOCK

sysprocesses and Lock Waits : Audits

Deadlock Audits and Deadlock Graphs

XDL Files and Deadlocks Prevention

18 Health Checks, Issues, Solutions

Alerts : Creation and Notifications

DB Suspect Event Alerts (023)

Important Perfmon Counters, Alerts

Log Space, Memory, Tempdb Alerts

Scheduling Alerts & Notifications

DBCC CHECKDB : DB Health Checks

Allocation Errors, Consistency Errors

DBCC ShowContig, Extent Fragmentation

Trace Flags and EstimateOnly

DBCC Page: GAM, SGAM and PFS

Consistency Errors : Cause & Solutions

Allocation Errors : Cause and Solutions

Log Space Issues and Log Rebuilds

Memory & TempDB Issues, Solutions

DBCC ShrinkDB and Page Restores

19 SQL DBA PROJECT – Level 1

Audit Login Failures : Server Logs

Monitoring Connectivity Issues

Database Refresh and MSDTC

Adhoc Memory Dump Files

PLE (Page Life Expectancy) Issues

Object Refresh and Recompilations

Server Registrations and Operations

Lock Monitoring Operations

Index Management Options

Open Transactions, Blocking

Metadata Sync-up Issues

Stored Procedure Recompilations

Backup and HA-DR Strategies

Db Restores and DB Repairs

Health Checks, Issues, Solutions

Tools & Technologies

Every tool listed here is installed, configured and used in a hands-on lab session.

Core Tools

Hands-On Labs

Practical Environment

Industry-Standard Tools

Real-World Setup

Guided Exercises

Skill Building

Sample Datasets

Practice Material

Practice & Projects

Mini Projects

Applied Practice

Assignments

Mentor Reviewed

Doubt Sessions

Live Support

Career Readiness

Resume Building

Career Support

Mock Interviews

Interview Prep

Certification Prep

Global Recognition

Deployment & Delivery

Production Practices

Real-World Ready

Best Practices

Industry Standards

275+

Hands-On Lessons

Core Modules

50 hours

Training Duration

100%

Practical Training

You don't just learn MS SQL SERVER DBA. You ship it.

Three major projects, each mirroring how production teams actually work — from guided foundations to a portfolio-ready capstone.

PROJECT // 01

Guided Foundation Project

→Requirement Analysis

→Guided Implementation

→Mentor Review

→Iteration

Foundation Beginner

Apply the fundamentals in a structured, mentor-reviewed project

Take the core concepts from the first half of the curriculum and apply them to a realistic scenario, with guidance and feedback from your mentor at every step.

Structured project brief

Step-by-step implementation

Mentor feedback and review

Documented outcome

Stack Core Concepts Best Practices

PROJECT // 02

Applied Practice Project

→Scenario Design

→Independent Build

→Testing & Validation

→Peer Review

Applied Intermediate

Build a more independent project mirroring real production scenarios

Work through a project that combines multiple concepts from the curriculum, closer to how work is actually structured on the job — less hand-holding, more ownership.

End-to-end implementation

Testing and validation

Documentation

Peer/mentor review

Stack Applied Skills Testing

PROJECT // 03

Capstone Project

→Planning

→End-to-End Build

→Review & Refinement

→Presentation

Capstone Advanced

Take a project from requirements to a polished, portfolio-ready deliverable

Your final project — plan, build, test and present a complete solution using everything covered in the curriculum, reviewed by mentors before you graduate.

Complete working solution

Presentation-ready documentation

Mentor sign-off

Portfolio-ready deliverable

Stack Full Curriculum Portfolio

All 3 projects go directly into your portfolio & resume — reviewed by mentors before you graduate.

See Sample Project Reports

Upcoming Batches

No upcoming batches scheduled right now. Enquire to get notified.

Why Radical Technologies

Live Online Training

Highly practical oriented training
Installation support on your system
24/7 Email and Phone support
100% Placement Assistance
Global Certification Preparation
Trainer-Student Interactive Portal
Assignments and Projects by Mentors

Enroll Now

Live Classroom Training

Weekend / Weekdays / Morning / Evening batches
80:20 Practical and Theory ratio
Real-life Case Studies
Easy make-up for missed sessions
PSI | Kryterion | Redhat Test Centers
Lifetime Video Classroom Access (coming soon)
Resume Prep and Mock Interviews

Enroll Now

Self-Paced Training

Learn 300+ courses at your own time
50,000+ Satisfied Learners
Course Completion Certificate
Practical Labs available
Mentor Support available
Doubt Clearing Session available
10% Discounted Global Certification

Enroll Now

Like the Curriculum? Let's Get Started

Join 50,000+ students already enrolled at Radical Technologies

Enroll Now

Global Certification

Radical Technologies is the leading IT certification institute in Pune, offering globally recognized certifications across various domains. With expert trainers and comprehensive materials, we ensure students gain in-depth knowledge and hands-on experience to excel in their careers. Our certification programs are tailored to meet industry standards — from cloud technologies to data science — empowering individuals to stay ahead in the ever-evolving tech landscape.

Career Services

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalised resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career.