Skip to main content

#DBA Full Stack

DBA Full Stack professionals manage the complete database ecosystem — from design and development to administration and performance tuning. They handle SQL, cloud, and automation tools to ensure data security, scalability, and high availability across enterprise environments.

✅ MSSQL DBA Concepts
✅ Azure SQL DBA Concepts
✅ PostgreSQL DBA Concepts
✅ Azure PostgreSQL DBA
✅ LIVE Databases: Lift & Shift
✅ MSSQL DBA Versus Postgres
✅ Multi Cloud Integrations
✅ Resume & Interview Prep
✅ Multi-DBA Portfolio Creation
✅ 1:1 Mentorship, Career Guidance

DBA Full Stack
Training Course Contents:

Module 1 : SQL DBA

Ch 1: Introduction

  • Database Introduction
  • Types of Databases
  • Need for Database Admins
  • ETL Admin Job Roles
  • Routine, Emergency DBA
  • SQL Server Advantages
  • Version, Editions of MSSQL

Ch 2: Installation

  • SQL Server 2019, 2017
  • SSMS Tools Installation
  • Database Engine (OLTP)
  • SCM, Configuration Tools
  • Instance Types, Uses
  • Authentication Modes
  • Collation, File Stream

Ch 3: SQL BASICS – 1

  • Need for Databases, Tables
  • Need for SQL Commands
  • DDL, DML & DQL Statements
  • Database Creation @ GUI
  • Data Operations @ GUI
  • Session ID, SQL Context
  • DB, Tables, Data @ SQL

Ch 4: SQL BASICS – 2

  • DDL Variants in MSSQL
  • DML Variants in MSSQL
  • INSERT & INSERT INTO
  • SELECT & SELECT INTO
  • Basic Operators in SQL
  • Special Operators in MSSQL
  • ALTER, ADD, TRUNCATE, DROP

Ch 5: Data Imports, Schemas

  • Data Imports with Excel
  •  ORDER BY & UNION
  • UNION ALL For Sorting Data
  •  Creating, Using Schemas
  •  Real-world Banking Database
  •  Table Migrations @ Schemas
  •  2 Part, 3 Part & 4 Part Naming

Ch 6 : Constraints, Index Basics

  • Need for Constraints, Keys
  •  NULL, NOT NULL, UNIQUE
  •  Primary Key & Foreign Key
  •  RDBMS and ER Models
  •  Identity Property, Default
  •  Clustered Index, Primary Key
  •  Non Clustered Index, Unique

Ch 7: Joins & Views Basics

  • JOINS: Purpose. Inner Joins
  • Left / Right / Full Outer Joins
  • Cross Joins, Query Tuning
  • Creating & Using Views
  • DML, SELECT with Views
  • RLS : WITH CHECK OPTION
  • System Views & Metadata

Ch 8: Functions(UDF), Data Types

  • Using Functions in MSSQL
  •  Scalar Value Functions
  • Inline & Multiline Functions
  • Date & Time Functions
  • String, Aggregate Functions
  • Data Types : Integer, Char, Bit
  • SQL Variant, Timestamp, Date

Ch 9: Stored Procedures,Models

  • Stored Procedures & Usage
  • Creating, Testing Procedures
  • Encryption, Deferred Names
  • SPs for Validations, Analysis
  • System SPs, Recompilation
  • Normal Forms & Types
  • Data Models, Self-References

Ch 10: Triggers, Temp Tables

  • Need for Triggers
  • DDL & DML Triggers
  • Using Memory Tables
  • Data Replication, Automation
  • Local & Global Temp Tables
  • Testing & Using Temp Tables
  • SELECT .. INTO & Bulk Loads

Ch 11: DB Architecture, Locks

  • Planning VLDBs : Files, Sizing
  • Filegroups, Extents & Types
  • Log Files : VLF, Mini LSN
  •  Table Location, Performance
  • Schemas, Transfer, Synonyms
  • Transactions Types, Lock Hint
  •  Query Blocking Scenarios

Ch 12 : Cursors & CTEs, Links

  • Cursors : Realtime Use
  • Fetch & Access Cursor Rows
  • CTEs for SELECT, DML
  • CTEs: Scenarios & Tuning
  • Linked Servers, Remote Joins
  • Linked Servers: MSDTC, RPC
  • Tuning Remote Queries

Ch 13: Backups

  • Database Backups & Files
  • Backup Types & Options
  • DB, Filegroup, File Backups
  • Copy Only Backups, Usage
  • Partial Backups, Split Backups
  • Mirror Backups, Verifications
  • Checksum, ContinueOnError

Ch 14: Restores

  • DB, Filegroups, File Restores
  • GUI Restores: Limitations
  • Partial / Piece-meal Restores
  • Restoring & Online States
  • Standby Mode Restores
  • Point-In-Time (PITR) Restores
  • FILELISTONLY, MOVE Options

Ch 15: Jobs, Maintenance

  • Jobs & SQL Server Agent
  • Job Steps & Schedules
  • Maintenance Plans
  • Backup Maintenance Options
  • Job Notifications, Operators
  • DB Mail Configurations
  • Common Errors, Solutions

Ch 16: Security Management

  • Security Objects Usage
  • Creating Logins & Users
  • Creating Roles, Add Principals
  • Schema Level Security
  • Object, Column Level Security
  • Security Management Scripts
  • Security Audit, Logon Failures

Ch 17: DB Migrations

  • Creating Credentials
  • Creating Proxies, Realtime Use
  • Creating CDW Packages
  • Database Detach – Attach
  • SMO Migration Method
  • DB Migration Schedules
  • Detect, Fix Orphan Users

Ch 18: DB Health Checks, Repairs

  • DBCC Commands in Realtime
  • DBCC for Audits, Repairs
  • MSDB Suspect Pages
  • User Database Repairs
  • Log Space Issues, Solutions
  • TempDB Issues, Solutions
  • Memory Issues, Solutions

Ch 19: Query Audits, Perfmon

  • Query Performance Issues
  • Reasons for Slow Queries
  • Performance Tuning Options
  • Performance Tuning Tools
  • Query Store & History
  • Activity Monitor, Perfmon
  • DMVs & DMFs for Audits

Ch 20: Indexes & Tuning

  • Indexes: Sort Locations
  • Clustered & Online Indexes
  • Non-Clustered, Columnstore
  • Included Indexes in Realtime
  • Filtered Indexes & Usage
  • Covering Index & Selectivity
  • Indexed Views (Materialized)

Ch 21: Partitions, Statistics

  • Partition Implementations
  • Partition Functions & Schemes
  • Primary & Secondary Types
  • Data Archival with Partitions
  • Compression with Partitions
  • Statistics: Realtime Use
  • Index, Column Stats, Updates

Ch 22: Tuning Tools, Exec Plans

  • Tuning Tools and Workloads
  • Profiler Tool: Trace Files
  • Trace Filters and Rollover
  • DTA Tool Recommendations
  • PDS, & Index Size, Index Scan
  • Execution Plans, Index Seeks
  • Query Cost Issues, Solutions

Ch 23: MOT & Temporal Tables

  • Memory Optimized Tables
  • Non-Clustered Primary Keys
  • Stats Updates, Performance
  • Temporal Tables in Realtime
  • History Tracking & Testing
  • Timestamp Columns Usage
  • Tuning Stored Procedures

Ch 24: Locks & Isolation Levels

  • Transactions & Locks
  • Lock Types & Performance
  • Lock Management Options
  • Isolation Levels & TempDB
  • Snapshots and Performance
  • Deadlocks Simulations, Graphs
  • Profiler Tool & LIVE Locks

Ch 25: HA DR @ Replication – 1

  • Replication: Realtime Usage
  • Replication Considerations
  • Distributor Configurations
  • Publisher and Subscriber
  • Replication Types: Snapshot
  • Transactional Replication
  • Log Reader Agent & Usage
  • Replication Monitor, Alerts

Ch 26: HA DR @ Replication – 2

  • Merge Replication & Usage
  • Peer – Peer Replication
  • Peer to Peer Topology
  • Push & Pull Subscriptions
  • Conflict Detection, Avoidance
  • Scripting Replication Agents
  • Limitations with Replication
  • Common Errors, Solutions

Ch 27: HA DR @ Log Shipping

  • Log Shipping Configurations
  • Primary, Secondary Servers
  • Monitor Instance Selection
  • Working with Network Shares
  • LS Jobs: Backup, Copy, Restore
  • NORECOVERY, STANDBY
  • Manual Failover Process
  • Common Errors, Solutions

Ch 28: HA DR @ DB Mirroring

  • Database Mirroring Concepts
  • Configuring Principal, Mirror
  • Configure Witness, End Point
  • Synchronous, Asynchronous
  • Automated Failover Process
  • Manual Failover, Monitoring
  • Common Errors, Solutions

Ch 29: Updates, Upgrades

  • Updates, Upgrades Planning
  • Pre-Maintenance Checklist
  • Updates Process, Verifications
  • Upgrade Process, Verifications
  • History Tracking & Testing
  • System Database Rebuilds
  • DAC: Dedicated Admin Console

Ch 30: SQL DBA Project Phase

  • Routine DBA Activities
  • Emergency DBA Activities
  • Maintenance DBA Activities
  • SLA – OLA Process
  •  Ticketing Tools
  •  3rd Party Tools
  • Common Errors & Solutions

Module 2: Oracle DBA

Ch 1: Getting Started with UNIX

  •  What is UNIX & Architecture
  •  Login, Logout & Password Management
  •  List Files, Users & Directories
  •  UNIX Shutdown Commands

Ch 2: File Management & VI
Editor

  •  File Creation & Display Commands
  •  Hidden Files & Metacharacters
  •  Edit Files Using vi Editor
  •  File Count, Copy, Rename, Delete

Ch 3: Directory Management

  •  Absolute vs Relative Paths
  •  Create, Copy, Rename Directories
  •  Remove & Navigate Directories
  •  Dot (.) and Dot-dot (..) Directories

Ch 4: File & Directory
Permissions

  •  File/Dir Access Modes (r, w,x)
  •  chmod (Symbolic & Absolute Modes)
  •  chown & chgrp Commands
  •  Ownership & Permission Change

Ch 5: Users, Groups &
Environment

  •  Create/Modify Users & Groups
  •  Profile Files (.bash_profile)
  •  Set Environment Variables
  •  Path and Shell Settings

Ch 6: SQL Introduction &
Queries

  •  SQL Command Types (DML, DDL…)
  •  SELECT, WHERE, ORDER BY
  •  DISTINCT, ALIAS, CASE, DUAL Table
  •  Logical & Comparison Operators

Ch 7: Single Row Functions

  • Character & Numeric Functions
  •  Date & Conversion Functions
  •  Nested Functions
  •  Using GROUP Functions

Ch 8: Joins & Subqueries

  •  INNER, OUTER, SELF Joins
  •  Table Aliases
  •  Single/Multiple Row Subqueries
  •  Nested Queries Usage

Ch 9: DML & Transaction
Control

  •  INSERT, UPDATE, DELETE, TRUNCATE
  •  COMMIT & ROLLBACK
  •  SAVEPOINT & Restore
  •  Data Validation

Ch 10: Tables & Constraints

  •  Create, Alter, Drop Table
  •  Add/Remove/Hide Column
  •  Constraint Types & Syntax
  •  Table Renaming & READ ONLY Mod

Ch 11: Intro to Oracle DBA

  •  What is a Database?
  •  DBA Roles & Tools
  •  Oracle Product Overview
  •  Database Types & Vendors

Ch 12: Oracle Instance
Architecture

  •  SGA, PGA & Process Architecture
  •  Logical vs Physical Storage
  •  Control, Redo, Data Files

Ch 13: Software Installation &
DB Creation

  •  12cR1 & 12cR2 Installation
  •  DBCA GUI & Manual Creation
  •  Database Layout
  •  Patch Set Prerequisites

Ch 14: Startup, Shutdown &
Parameters

  •  Startup/Shutdown Modes
  •  Initialization Parameter Files
  •  System & Session Parameters
  •  Using V$ & DBA_ Views

Ch 15: User Management &
Security

  •  Common & Local Users
  •  Roles & Privileges
  •  Profiles & Password Policies
  •  Session Management

Ch 16: Tablespace & Datafile
Admin

  •  Create/Alter/Drop Tablespaces
  •  Resize Datafiles
  •  Segment & Extent Management

Ch 17: Undo Tablespace

  •  Create & Manage Undo
  •  Assign Undo Tablespace
  •  Transaction Undo Usage
  •  Views for Undo Monitoring

Ch 18: Temporary Tablespace

  •  Create & Resize Temp Files
  •  Temp Tablespace Groups
  •  Views for Temp Usage
  •  Best Practices

Ch 19: Control File
Management

  •  Purpose of Control Files
  •  Multiplexing Control Files
  •  Backup Control Files
  •  V$CONTROLFILE View

Ch 20: Redo Logs & FRA

  •  Redo & Archive Logs
  •  Archive Mode Setup
  •  Fast Recovery Area (FRA)
  •  Redo Log Views

Ch 21: Oracle Net Services

  •  Oracle Listener Setup
  •  netca & netmgr Utilities
  •  Dedicated vs Shared Server
  •  TNS_ADMIN Configuration

Ch 22: Database Links

  •  DB Link Overview
  •  Private vs Public Links
  •  Create & Drop Links
  •  Use Cases for DB Links

Ch 23: Logical Backup (Data
Pump)

  •  expdp & impdp Basics
  •  Table/Schema/DB Export
  •  Metadata Packages
  • Export/Import Modes

Ch 24: RMAN Backup & Restore

  •  RMAN Concepts & Configuration
  •  Full & Incremental Backups
  •  Catalog Usage
  • RMAN Views & Reports

Ch 25: Flashback & Restore
Points

  •  Flashback Modes & Prereqs
  •  Restore Point Setup
  •  Flashback Table/DB
  •  Use Cases

Ch 26: RMAN Duplicate Cloning

  •  Cloning Types
  •  Clone Oracle Home
  •  Duplicate Command
  •  Considerations & Cleanup

Ch 27: Standby DB & Data
Guard

  •  Physical & Logical Standby
  •  Data Guard Architecture
  •  SQL & RMAN for DG Setup
  •  Real-time Apply & Monitoring

Ch 28: Performance Tuning

  •  Memory Structure Sizing
  •  Wait Events & Session Tracing
  •  Index Monitoring
  •  AWR Reports & Stats

Ch 29: Oracle Patching

  •  Versioning & Patch Types
  •  Applying PSU & SPU
  •  OPatch Utility
  •  Upgrade Patch Strategy

Module 3: PostgreDBA

Ch 1: Intro to PostgreSQL

  • Overview & Use Cases
  • PostgreSQL History &
    Growth
  • Core Features & Licensing
  • Architecture Highlights

Ch 2: Installation

  • Windows Setup Steps
  • Linux via Yum/RPM
  •  Source Code Installation
  •  Contrib Module
    Installation

Ch 3: Configuration File & Directory Layout

  • Data & Base Directory
  •  PostgreSQL.conf Overview
  •  pg_hba.conf & Authentication
  •  File System Structure

Ch 4: Database Cluster

  • Initdb & Cluster Setup
  •  Start/Stop/Reload Commands
  •  Windows & Linux Cluster Demos
  • Systemctl Integration

Ch 5: Process & Memory Architecture

  •  Postmaster Process Flow
  •  Backend Utility Processes
  •  Shared Memory Segments
  •  Memory Components Explained

Ch 6: Create Objects and Privileges

  •  Create/Drop DB & Users
  •  Schema Management
  •  Search Path Configurations
  •  Grant & Revoke Commands

Ch 7: Tools and catalog

  •  psql Command Line Usage
  •  pgAdmin GUI Operations
  •  pg_catalog Schema Insights
  •  Metadata & Info Schema

Ch 8: CRUD Operations

  •  CREATE TABLE Syntax
  •  INSERT, UPDATE, DELETE
  •  TRUNCATE vs DELETE
  •  Data Types & Constraints

Ch 9: Tablespaces

  • Tablespace Concepts
  •  pg_default & pg_global
  •  Create/Drop Tablespaces
  •  Temporary Tablespace Use

Ch 10: Backup and Restore

  •  Logical Backups (pg_dump)
  •  Restore with pg_restore
  •  Online vs Offline Backups
  •  pg_basebackup Overview

Ch 11: Advanced Backup & Restore

  •  pgBackRest Utility
  •  Configure PITR Steps
  •  Timeline & WAL Archives
  •  Restore PITR Scenarios

Ch 12: MVCC  in PostgreSQL

  •  What is MVCC?
  •  MVCC Transaction Flow
  •  Data Structures & Snapshots
  •  Transaction ID Wraparound

Ch 13: Ch 13: Maintenance &
Vacuum

  •  VACUUM Types
  •  ANALYZE Command Use
  •  Clustering Tables
  •  Auto-Vacuum Settings

Ch 14: Joins and Constraints 

  •  Join Types (INNER,OUTER)
  •  Primary & Foreign Keys
  •  NOT NULL & UNIQUE Constraints
  •  ER Diagrams Overview

Ch 15: Indexing and Types

  •  B-Tree Index Structure
  •  Hash & Expression Indexes
  •  GiST & SP-GiST Indexes
  •  GIN & BRIN Use Cases

Ch 16: Performance Tuning – I

  •  VACUUM & Partitioning
  •  Query Plans (EXPLAIN)
  •  Index Usage Analysis
  •  Subquery Optimization

Ch 17: Performance Tuning –
II

  •  shared_buffers & work_mem
  •  effective_cache_size Setup
  •  pg_stat Monitoring
  •  CPU, RAM & Storage Tuning

Ch 18: Data Loading

  •  COPY Command Usage
  •  pgloader Configuration
  •  Import/Export Data Sets
  •  Use of FDWs

Ch 19: Extensions

  •  Overview of Extensions
  •  Installing Extensions
  •  Common Examples (postgis, hstore)
  •  Managing Extensions

Ch 20: HA & Replication – I

  •  Streaming Replication Setup
  •  Master & Standby Config
  •  Manual Failover Process
  •  promote Command Demo

Ch 21-22: HA & Replication –
II

  •  Logical Replication Basics
  •  Configure Publishers/Subscribers
  •  Auto Switchover Techniques
  •  Sync vs Async Modes

Ch 23-24: HA Tools & Software

  •  pgpool Setup & Load Balancing
  •  repmgr Cluster Management
  •  Patroni with etcd/Consul
  •  Failover Automation

Ch 25-26:  HA and (DR) strategies

  •  DR Concepts & Objectives
  •  Multi-Master Replication
  •  PITR as DR Strategy
  •  DR Tools & Integration

Ch 27: Tuning & Partitioning

  •  Configurable Parameters
  •  Partition Types (List, Range)
  •  Partitioning Strategy
  •  Performance Impact

Ch 28: Migration to
PostgreSQL

  •  Manual SQL Migration
  •  pg_dump & restore
  •  Migration via DMS Tools
  •  3rd Party Migration Tools

Ch 29: PostgreSQL Upgrades

  •  Upgrade Options
  •  Minor vs Major Upgrade
  •  pg_upgrade Tool
  •  Post-upgrade Validation

Ch 30: Monitoring & Reporting

  •  Grafana Integration
  •  pg_stat_statements
  •  pgBadger Reports
  •  Real-Time Monitoring

Ch 31: Migration to
PostgreSQL

  •  Manual SQL Migration
  •  pg_dump & restore
  •  Migration via DMS Tools
  •  3rd Party Migration Tools

Ch 32: PostgreSQL Upgrades

  •  Upgrade Options
  •  Minor vs Major Upgrade
  •  pg_upgrade Tool
  •  Post-upgrade Validation

Ch 33: Monitoring &
Reporting

  •  Grafana Integration
  •  pg_stat_statements
  •  pgBadger Reports
  •  Real-Time Monitoring

Ch 34: Azure Cloud Fundamental

  •  Cloud Concepts (IaaS, PaaS)
  •  Azure Subscriptions
  •  Azure Services for DBAs
  •  Deployment Models

Ch 35: PostgreSQL in Azure

  •  Benefits of Azure Platform
  •  Cost & Security Advantages
  •  High Availability Features
  •  Scalability Options

Ch 36: PostgreSQL Deployment Options

  •  Azure VM-based PostgreSQL
  •  Azure DB for PostgreSQL (PaaS)
  •  Azure Kubernetes with PG
  •  Decision Making: When to Use What

Ch 37: CRUD in Azure PostgreSQL

  •  Create & Drop DB/Users
  •  CRUD Query Syntax
  •  Access Control
  •  pgAdmin in Azure

Ch 38: Migration to Azure

  •  Azure DMS Setup
  •  ADF for Data Transfer
  •  Manual vs Tool-base Migration
  •  3rd-Party Tool Integration

Ch 39: Azure Backups

  •  Azure Native Backup Options
  •  Enabling Auto Backups
  •  Snapshot Configurations
  •  Backup Retention Policies

Ch 40: Restore in Azure

  •  PITR Setup in Azure
  •  Manual Restore via Portal
  •  Using pg_restore in Azure
  •  DR Restore Scenarios

Ch 41: Performance Tuning
in Azure

  •  Query Tuning Tools
  •  PostgreSQL Server Parameters
  •  Auto-Scaling Best Practices
  •  Monitoring Metrics

Ch 42: Azure High
Availability

  •  HA Deployment Architectures
  •  Azure Built-in HA Services
  •  Third-party HA Tools
  •  Failover Config & Testing

Ch 43: Azure Disaster
Recovery (DR)

  •  DR Architecture & Strategies
  •  PITR & Backup DR Use
  •  Azure DR Tools
  •  DR Automation Best Practices

Ch 44:
Real-time
Project

Ch 45:
Resume
Guidance,
Mock
Interview
Questions

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

DBA Full Stack Training FAQ's

What is a DBA Full Stack Job Role?

A DBA Full Stack professional is a hybrid expert who manages end-to-end database administration across multiple platforms (on-premises & cloud) and combines it with performance tuning, security, automation, and DevOps practices. This role includes working with Oracle, SQL Server, Azure SQL, PostgreSQL, MySQL, and cloud-native DB services (like AWS RDS, Azure DBs, GCP Cloud SQL), ensuring that databases are reliable, secure, scalable, and optimized.

What are the Job Roles of a DBA Full Stack Professional?

💼 Top Job Roles:

1️⃣ Install, configure, and manage multiple database engines
2️⃣ Monitor performance, optimize queries, and tune database configurations
3️⃣ Implement high availability (RAC, AlwaysOn, Data Guard, Replication)
4️⃣ Handle backups, restores, and disaster recovery strategies
5️⃣ Ensure security with access control, encryption, and auditing
6️⃣ Automate DBA tasks using scripts, tools, and DevOps pipelines and more..!

What does our DBA Full Stack Training course contains?

The course is carefully curated with below module:
👉🏻Module 1: SQL DBA
👉🏻Module 2: Oracle DBA
👉🏻Module 3: PostgreDBA

Who can join this course?

  • Freshers aiming to become expert-level DBAs across multiple platforms

  • Traditional DBAs upskilling to cloud and full stack DBA roles

  • System admins and DevOps engineers handling database infrastructure

  • Data engineers / architects needing deep DBA capabilities

  • Anyone preparing for high-paying DBA roles in hybrid environments

No prior coding experience is required. All concepts are taught from scratch

What training modes are available?

Option 1:        LIVE Online Training  (100% Interactive, step by step, assignments)

Option 2:        Self Paced Videos (100% practical, step by step with concept wise assignments)

You may choose any one of these options, same curriculum!

I (Trainer) shall be available for doubts and clarifications, assignment check and review.

Why should I choose SQL School for DBA Full Stack training?

👉🏻 Every session is Practical, Step by Step with Concept wise FAQs !!

👉🏻 100% results with on-time practice.  Daily Tasks for every session.

👉🏻 Concept wise tasks be submitted before next class for Job Waiters / Starters.

👉🏻 Concept wise tasks due for submission by Weekends for Working Professionals.

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance