SQL DBA Online Training (LIVE, Instructor-Led)

This SQL DBA Online 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.

This SQL DBA Online Training also includes practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters , LINUX Clusters and Real-time Azure SQL DBA activities. Additionally, this SQL DBA Training Course includes complete guidance for your Job Profile, Study Material, MCSA SQL DBA Certification (70-764 & 70-765) and Real-time Projects for your Resume. Versions: SQL Server 2014, 2016, 2017 and 2019. Download SQL DBA Curriculum Here

SQL DBA (with Server, T-SQL, Azure SQL DBA)

  PLAN A PLAN B
SQL DBA Job Profile Core DBA Core DBA + Azure DBA
SQL DBA Course Duration 6 Weeks 8.5 Weeks
Number of Chapters 33 Chapters 44 Chapters
Real-time Issues, Solutions Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server, DB Architecture Check-Symbol-for-Yes Check-Symbol-for-Yes
Query Tuning and Plan Analysis Check-Symbol-for-Yes Check-Symbol-for-Yes
HA - DR, Issues, Troubleshooting Check-Symbol-for-Yes Check-Symbol-for-Yes
DB Repairs, Security Management Check-Symbol-for-Yes Check-Symbol-for-Yes
Migrations, Updates (CU), Upgrades Check-Symbol-for-Yes Check-Symbol-for-Yes
Errors & Troubleshooting Check-Symbol-for-Yes Check-Symbol-for-Yes
Events, Traces, Encryptions Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server on Windows Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server on LINUX Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
Always-On Availability Groups Check-Symbol-for-Yes Check-Symbol-for-Yes
SLA, OLA, Licensing Plans Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL DB Migration to Azure Croos-symbol-for-No Croos-symbol-for-Yes
Azure SQL Database Admin Croos-symbol-for-No Croos-symbol-for-Yes
Azure SQL DB: HA-DR Croos-symbol-for-No Croos-symbol-for-Yes
Common Errors, Solutions Croos-symbol-for-No Croos-symbol-for-Yes
Azure Virtual Machines, XEL Croos-symbol-for-No Croos-symbol-for-Yes
Azure PowerShell, Azure CLI Croos-symbol-for-No Croos-symbol-for-Yes
MCSA 70-764 Certification Croos-symbol-for-No Croos-symbol-for-Yes
MCSA 70-765 Certification Croos-symbol-for-No Croos-symbol-for-Yes
Total Course Fee
*Course fee payable in 2 equal installments
INR 18,000
INR 20,000
INR 24,000
INR 26,000

SQL DBA Training Schedules - Trainer : Mr. Sai Phanindra T

S. No Timings (IST) Demo Date Start Date  
Schedules for Chapter 1 to 33 (For SQL DBA Plan A)
1 6:30 AM - 7:30 AM Sep 4th Sep 6th Register
2 10:15 AM - 11:15 AM Sept 23rd Sept 24th Register
3 7:30 PM - 8:30 PM Aug 21st Aug 22nd Register
Schedules for Chapters 34 to 44 (For SQL DBA Plan A, B)
4 6:30 AM - 8:30 AM (W) Aug 31st Sep 1st Register
5 10:00 AM - 12:00 PM (W) Sep 21st Sep 22nd Register

SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ HA - DR Issues ✔ Azure Migrations
✔ XEL Graphs ✔ DAC, PBM ✔ Stretch Databases
✔ DB Migrations ✔ Licensing Plans ✔ Azure HA - DR
✔ In-Memory Tables ✔ DMA Tool ✔ POCs, RCA
✔ Ticketing Tool ✔ Tuning Tools ✔ Updates, Rollbacks
✔ Always-On ✔ SLA / OLA ✔ Upgrades, Rollbacks
✔ Lite Speed ✔ Windows Clusters ✔ Managed Instance
✔ Realtime Errors ✔ Linux (RHEL) ✔ Virtual Machines
✔ Capacity Planning ✔ Power Shell ✔ Service Startup Modes
✔ Shard Keys ✔ BLOB Storage ✔ Azure Storage Keys
✔ DBA Checklists ✔ Azure RM, eDTU ✔ MCSA 70-764 Guidance
✔ Rebuilds, Repairs ✔ Managed Instances ✔ MCSA 70-765 Guidance

All Trainings are completely Practical and Real-Time. Curriculum Download

Chapter wise FAQs with Answers, Real-time Project are part of this SQL DBA Online Training Course Register

SQL DBA Training (with SQL Server, Azure DBA) Course Contents:

Part 1 : SQL DBA with SQL Server, T-SQL Basics

Module I: SQL Server & T-SQL

Installation, Architecture, Indexes, Tuning

Module II: Basic SQL DBA

Backup-Restores, Jobs, Tuning, Security, Migrations

Module III: Advanced SQL DBA

HA-DR, Errors & Solutions, Always-On, RHEL

Day 1: SQL DBA - JOB ROLES, INTRO

  • Need for Databases & RDBMS Software
  • Need for Database Administrators (DBA)
  • SQL DBA : Job Roles and Responsibilities
  • Routine, Emergency Maintenance DBA Roles
  • Database Types: OLTP, OLAP, DWH, HTAP
  • MS SQL Server - Technical Advantages
  • SQL Server @ OnPremise: Windows, Linux
  • SQL Server @ Cloud: Azure, AWS, G Cloud
  • Versions and Editions of SQL Server
  • SQL Server and SSMS Installation Plan
  • SQL Server 2019 : Installation [Overview]
  • System Configuration Checker (SCC) Tool

Day 12: BACKUPS - DB, File, Filegroup

  • Database Backups, Filegroup Backups
  • Log File Backups, COPY_ONLY Backups
  • Mirror Backups, Split Backups, FORMAT
  • Partial Backups and Backup Media Files
  • UNLOAD, INIT, FORMAT, VERIFY, SKIP
  • Compression,Checksum,RetainDays,Stats
  • ContinueOnError and Backup Validations
  • Backup History Tables in MSDB - Joins
  • Backup Audits. HOT and COLD Backups
  • Backup Devices - Creation and Usage
  • Database Recovery Models - DB Logging
  • Common Backups Errors & Solutions

Day 23: REPLICATION For HA - LEVEL 1

  • Replication Architecture and Topology
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • Distribution DB Configuration, Snapshots
  • Snapshot Replication and Repl Agents
  • Adding Articles to Existing (LIVE) Replica
  • PUSH, PULL Subscriptions. N/W Shares
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Tracer Tokens Latency, Ranking Options
  • Replication Monitor - Usage and Options
  • Replication Warnings and Agent Alerts

Day 2: INSTALLATIONS [DETAILED]

  • SQL Server 2016 Installation, Guidance
  • SQL Server 2017 Installation, Guidance
  • Instance Types: Default & Named Instances
  • SQL Server Services : Database Engine
  • SQL Server Agent and Full Text Search
  • SQL Browser Service and Collation
  • System Databases: Master, Model, MSDB
  • TempDB and Resource Database Locations
  • SQL Server Authentication Modes
  • Windows Login & SQL Server Login Types
  • "sa" System Account, File Stream Property
  • SQL Server Management Studio. SSMS Tool
  • Local Server & LIVE Online Lab Connections
  • Common Installation Errors, Solutions

Day 13: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • RECOVERY and NORECOVERY Options
  • STANDBY, REPLACE Options in Restores
  • File, File Group and Meta Data Restores
  • Backup Verifications using GUI, Scripts
  • FILELISTONLY and VERIFYONLY Options
  • HEADERONLY, STATS, UNLOAD, STOPAT
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backups. UNDO, REDO Phases
  • 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 Backups Errors & Solutions

Day 24: REPLICATION For HA - LEVEL 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Subscription Reinitialization, Expiry Setting
  • Server Subscription & Client Subscription
  • Peer-Peer Replication Connections, Nodes
  • NodeID and Conflict Detection Options
  • Replication Options on Conflicts: sp_MSRepl
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Priority Settings
  • Replication Verify - Rowcount, Checksum
  • Disabling, Cleaning Replication Topology
  • Replication Strategies for HA and DR Plan
  • Replication for Load Balancing Topologies
  • Common Backups Errors & Solutions

Day 3: DATABASE & SQL BASICS

  • SQL : Purpose, Usage for SQL DBAs
  • DDL, DML, SELECT, DCL and TCL
  • Creating Databases with SQL Scripts
  • Creating Tables. Integer, Character Types
  • Single Row Inserts, Multi Row Inserts
  • SELECT. WHERE Conditions, Operators
  • AND, OR, NOT, Mathematical Operators
  • IN, NOT IN, BETWEEN, NOT BETWEEN
  • Creating Databases, Tables in GUI
  • Data Inserts, Edits, T-SQL Scripts
  • Utilities : Excel Imports and Exports
  • Excel Sheet Data into SQL Tables
  • SELECT TOP (n) Queries from GUI

Day 14: JOBS, MAINTENENCE 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
  • 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

Day 25: LOG SHIPPING (HA - DR)

  • Log Shipping Topology for HA and DR
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor, Jobs and Alerts
  • NORECOVERY Mode - Configuration
  • STANDBY Mode Configuration & Jobs
  • Log Shipping Jobs and Manual Failover
  • Log Shipping Mode Changes - cautions
  • Re-Restoring Log Backups for Recovery
  • LSBackup, LSCopy & LSRestore Jobs
  • LS Job Audits, Dashboards (Reports)
  • TUF Files and Standby Options in LS
  • Broken Log Shipping Chains & Issues
  • Common Backups Errors & Solutions

Day 4: DB CREATION, DDL, DML

  • Database Logical, Physical Implementation
  • Creating Databases with User Interface
  • Database Data Files in Real-time [mdf, ndf]
  • Database Log Files (T-LOG) For Audits [ldf]
  • CHAR Versus VARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • SELECT Statement. IS NULL, NOT NULL
  • LIKE, NOT LIKE Operators. & and _
  • DISTINCT, TOP, FETCH, ORDER BY
  • UNION, UNION ALL and Auto Orders
  • UPDATE : With / Without Conditions
  • DELETE Versus TRUNCATE Statements
  • ALTER, DROP, ADD, MODIFY Statements
  • DDL, DML : Real-time Use for SQL DBAs

Day 15: SECURITY MANAGEMENT - 1

  • Authentication Types & Modifications
  • Windows Logins : Creation and Usage
  • SQL Server Logins : Creation, Usage
  • Password Policies; User Creations
  • Logins - Users Mapping, DB Access
  • Server Roles and Database Roles - Usage
  • Password Resets and Security Policies
  • Logon Failures & Server Management Logs
  • Configure Log Archives for Login Failures
  • Object Level Security & Column Security
  • Schema Level Security & Built-In Schemas
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • EXECUTE, REFERENCES, View Definition

Day 26: DB MIRRORING (HA - DR)

  • DB Mirroring Architecture For HA & DR
  • Log Shipping Versus Database Mirroring
  • TCP Endpoints, TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Automatic Fail-Over Procedures, Tests
  • PARTNER OFFLINE Conditions, Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • DB Mirroring and Port Configurations
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • Mirroring Monitor Jobs - Real-time Usage
  • Common Backups Errors & Solutions

DAY 5 : CONSTRAINTS, INDEXES Basics

  • 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
  • Indexes : Basic Types and Creation
  • Index Sort Options, Search Advantages
  • Automated Indexes, Manual Indexes
  • Clustered & NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Comparing Keys, Indexes for Performance
  • Need for Indexes - working with Keys

Day 16: SECURITY MANAGEMENT - 2

  • Data Encryption: Keys and Certificates
  • Encrypting Passwords : ENCRYPTBYCERT
  • Certificate Backups and Realtime Use
  • Job Security : Credentials and Proxies
  • Using Proxies for SSIS Jobs, Repl Jobs
  • Detecting and Resolving Orphan Users
  • Orphan Users : Prevention Mechanism
  • Containment Database Settings, PARTIAL
  • Containment Databases Authentication
  • Security Scripts and Documentation
  • Scripting Logins, Users & Permissions
  • DMVs for Security Audits, Orphan Users
  • Scripts: Server Principals and Logins
  • Scripts: Database Principals and Users
  • Audit: Logins - Roles - User Permissions

Day 27: CLUSTER CONFIGURATION

  • Windows Clusters For HA and DR
  • Domain Controller (DC) Configuration
  • Active Directory (AD) Accounts, Use
  • SAN [Storage Area Network] and LUN
  • Public IP Address, Private IP Address
  • Windows Level Clusters, MSCS Service
  • Need for DNS Hosts - Server Manager
  • DNS Tools, Actions & Adding AA Hosts
  • SQL Clustering Service & RAID Levels
  • RAID Levels for Data Files & Log Files
  • SQL Cluster Groups, Domain Accounts
  • Active-Active, Active-Passive Clusters
  • Quorum and MSDTC Disks. LUN Grows
  • MSCS Service Startup Options, Drains
  • Need for Always - On Availability (AAG)

DAY 6: Joins, Audits and Temp Tables

  • JOINS - Types & Audits for SQL DBAs
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - Examples, WHERE, ON
  • Left Outer Joins, Right Outer Joins
  • FULL Outer Joins and Advantages
  • MERGE, LOOP, HASH Join Options
  • Big Table Vs Small Table Joins
  • Tuning Options with Join Queries
  • CROSS JOIN and CROSS APPLY
  • Join Types Versus Join Options
  • Using Joins for Metadata Audits
  • Using Joins on Foreign Key Columns
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables

Day 17: Tuning 2 - AUDITS, PARTITIONS

  • Audit Long Running Queries : DMVs, DMFs
  • Activity Monitor Tool, Query Statistics
  • Logical & Physical I/O, DB IO, Waits
  • Recent and Active Expensive Queries
  • Server Dashboards and Built-In Reports
  • Memory Usage Reports, IO Statistics
  • DB Query Store : PAUSE, MAX_DURATION
  • Partition Mechanism : Database Filegroups
  • Partition Functions & Partition Schemes
  • Aligned / Indexed Partitions - Importance
  • Partition SPLIT and MERGE, NextUsed
  • Partition Compression : ROW, PAGE
  • Data Archival and Partition SWITCH
  • Partitioned Views Performance Benefits

Day 28: ALWAYS ON AVAILABILITY (AAG)

  • Always On Availability Group [AOAG]
  • Synchronous and Asynchronous Modes
  • Policy Based Management for AOAG
  • Facets and Conditions for Policies
  • Backup Preferences & Location Options
  • Synchronization & Automated Seeding
  • Data Synchronization Settings for AOAG
  • Port Settings, Backup Strategies in AAG
  • AOAG Verifications and Dashboards
  • Adding Availability Replica, Database
  • Adding Availability Listeners and DNS
  • Automated Failovers, Manual Failovers
  • Always-On Availability Groups Health
  • AOAG AAA Hosts, Forward Lookup Zones

DAY 7: Views, Functions, Procedure Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views, Audits
  • Listing Databases, Tables, Indexes
  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Variables & Parameters in SQL Server
  • Procedures : Types, Usage in Real-time
  • User Defined, System Defined Procedures
  • Procedures : Precompilation Advantages
  • System Predefined Procedures, Audits
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys, sp_rename
  • sp_depends, sp_who and sp_who2

Day 18: Tuning 3 - FTS, STATISTICS

  • Full Text Search (FTS) - Architecture
  • StopWords, Stemmer, Thesaurus For FTS
  • Indexer, Query Processor & Compilation
  • Full Text Catalogs and Filter Daemon
  • FDHost.Exe and Daemon Threads for FTI
  • Full Text Indexes (FTI), Crawler Threads
  • Change Tracking (CT) and Data Population
  • CONTAINS(), FREETEXT() with SELECT
  • In-Memory Tables : Creation, Tuning
  • Memory Snapshots at DB and Table Level
  • FileStream Files and MOT Filegroups
  • MEMORY_OPTIMIZED_ELEVATE Snapshot
  • Stats Updates : FullScan, NoRecompute
  • Temporal Tables Usage & History Tracking
  • Statistics : Index and Column Statistics

DAY 29: FIREWALL, DB MIGRATIONS

  • Firewall Issues - Exceptions, Solutions
  • SQLServer.exe & SQLBrowser.exe Files
  • Using SQL Configuration Manager Tool
  • Network Configurations, Client Settings
  • Network Protocols and Client Connections
  • Server Aliases and Port Configurations
  • Static Ports and Dynamic Ports, IPs
  • Version, Editions Differences - Chart
  • CDW : Copy Database Wizard @ SSMS
  • Database Detach and Attach Options
  • FORATTACH, sp_single_file_attach_db
  • SMO Method and Database Scripting
  • CDW SSIS Packages, SSIS Proxies Use
  • Scheduling Database Migration Jobs
  • Database Migrations & Orphan Users

Day 8: Triggers, Transactions, DTC

  • Triggers - Purpose, Real-world Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommits
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints
  • Linked Server, Remote Database Access
  • Remote Data Access, RPC, RPC Out
  • Distributed Transactions in Real-time

Day 19: Tuning 4 - INDEX MANAGEMENT

  • Index Management : Performance Tuning
  • Internal and External Fragmentation
  • Fragmentation Audits : DMFs, Thresholds
  • Proactive, Reactive Approach For Indexes
  • Index Reorganization Process, Audits
  • Index Rebuilding Process and Audits
  • Resumable Indexes: ONLINE, RESUME
  • PAUSE & RESUME Options : Index Rebuilds
  • Database Maintenance Plans (DMP) Jobs
  • Proactive Index Reorganization Process
  • Index Page Count and Index Condition
  • Degree Of Parallelism [DOP] Settings
  • DOP Settings with Index Management
  • Recently Used Indexes and Statistics
  • Fast, Detailed Scans. Statistics Updates

Day 30: PATCHES, UPGRADES, CUs

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • DB Backups, Scripting and Services
  • Service Packs and Patch/Hotfix Activities
  • Cumulative Updates (CU), Hotfix Process
  • Instance Selectivity for Updates, Cautions
  • Verifications, Smoke Test and Rollbacks
  • SERVER Upgrades, VERSION Changes
  • Silent Installation & Installation Repairs
  • Verifications, Smoke Test and Rollbacks
  • System Database REBUILDs using CMD
  • Silent Installation & Installation Repairs
  • SQLCMD Tool and Instance Connections
  • DAC : Dedicated Administration Console

DAY 9: SQL SERVER ARCHITECTURE

  • TCP IP, Named Pipes, Shared Memory
  • Query Processing and Storage Engines
  • Parse, Compile, Optimize & Execute
  • Query Optimizer (QO) and SQL Manager
  • Database Manager, Memory Manager
  • Buffer Manager, Buffer Pool - Use
  • Transaction, File and Lock Managers
  • Buffer Manager, WAL, Lazy Writer
  • Lock Managers - Storage & SQL OS
  • Synchronization Services in MSSQL
  • SQL OS Components, MDAC & CLR
  • Schemas : Grouping Tables and Usage
  • Schema - Table Migrations & TRANSFER
  • 2Part, 3Part, 4Part Naming Convention

Day 20: Tuning 5 - TUNING TOOLS

  • Tuning Tools : Workload and Trace Files
  • SQL Profiler Tool - Tuning Template, Events
  • DTA Tool with Profiler : Recommendations
  • DTA with Procedure Cache & .SQL Files
  • Execution Plans - Internals. Spooling
  • Estimated, Actual, LIVE Execution Plan
  • Query Costs : IO Cost and CPU Cost
  • Query Costs : SubTree Cost, Operator Cost
  • Numa Nodes, Boost Priority, Thread Count
  • Perfmon Counters - Important Counters
  • Log Space Issues : Cause and Solutions
  • TempDB Space Issues : Cause & Solutions
  • Memory Issues : Solutions, Memory Leaks
  • Important DMVs, DMFs for Resource Audits
Day 31 - 33: SQL DBA REAL-TIME PROJECT
SQL DBA - ROUTINE DBA ACTIVITIES :
  • Audit Login Failures : Server Logs
  • Monitoring Connectivity Issues
  • Auditing Long Running Queries
  • Memory Issues and Solutions
  • PLE (Page Life Expectancy) Issues
  • MSDTC and Remote Connections
  • Job Monitoring and Precautions
  • Monitoring HA & DR Mechanisms
  • Database Refresh, Schema Refresh
  • Creating Dump Files and Audits
  • Idle Sessions and Precautions
  • Index Management and Integrity
  • Deadlock : Monitoring, Prevention
  • Monitor Server Health, Dashboards
SQL DBA - EMERGENCY DBA ACTIVITIES :
  • Server Down : Issues, Solutions
  • Database Down : Issues, Solutions
  • Data Synchronization : Issues, Solutions
  • Slow Running Queries : Issues, Solutions
  • Database Response : Issues, Solutions
  • Slow Replication : Issues, Solutions
  • Replication @ HA-DR : Issues, Solutions
  • Important Events and Errors, Solutions
  • Hot CPU and Processor Node, Priority
  • CPU Thread Counts and Windows Fibers
  • Contained Databases and Orphan Users
  • Memory Dump Files and Solutions
  • Firewall Issues and Solutions
  • Service Startup Issues and Solutions
  • Trace Flags and Real-time Usage
  • Always-On (AAG): Issues and Solutions
WHAT YOU GET FROM THIS COURSE?
  • 300+ Interview FAQs with Answers
  • 200+ Errors and Solutions
  • 10+ POCs for DBA Strategies
  • 2 Case Studies and Solutions
  • 1 Real-time Project
  • 24 x 7 LIVE Online Lab Access
  • Chapter Wise Mock Interviews
  • Weekly Revision and Doubts
  • 100% Real-time, Practical
  • Resume Building and Support
  • DBA Job Placement Support
  • 1 - 1 Mock Interview
  • Career Guidance

Day 10: SQL DATABASE ARCHITECTURE

  • Database Architecture - In Detail
  • Data File, Log Files and FileStream
  • Primary File [MDF] : Real-time Usage
  • Secondary File [NDF] : Real-time Usage
  • Transaction Log File [LDF] and LSN
  • VLF: Virtual Log File and Commands
  • Pages, Extents and Checkpoint Process
  • Write Ahead Log (WAL) Process
  • Filegroups : Creation and Usage
  • Read Only and Default Filegroups
  • Initial size, Maxsize, FileGrowth
  • Add Files, Filegroups to Existing DB
  • DBCC Commands and Table Page Count
  • DB States: Online, Emergency, SingleUser

Day 21: Tuning 6 - LOCKS, ISOLATIONS

  • LOCKS : Types, Concurrency Control
  • Lock Types and Lock Escalations
  • X, S, IS, IX,U, MD, Sch-M, Sch-S
  • Lock Audits : SP_WHO2, SP_LOCK
  • sysprocesses and Lock Waits
  • Auditting and Avoiding Blocking
  • Deadlock Simulation and Prevention
  • Deadlock Audits & Events in Profiler
  • Deadlock Graphs and XDL Files
  • Isolation Levels and Query Blocking
  • Row Versions and Page Versions
  • ReadComitted, UnComitted, Snapshot
  • Repeatable Reads and Phantom Reads
  • Read Comitted Snapshot Isolations

DAY 11: Tuning 1: INDEX ARCHITECTURE

  • Indexes: Architecture and Index Types
  • B Tree Structure, IAM Page [Root]
  • Clustered Indexes: Architecture, Usage
  • NonClustered Indexes: Architecture, Usage
  • Included Indexes and Index selectivity
  • COLUMNSTORE Indexes for Unique Values
  • FILTERED Indexes and Query Conditions
  • UNIQUE Indexes and ONLINE Indexes
  • COVERING Indexes and Index Seek Plans
  • Composite Indexes and Composite Keys
  • Indexed Views / Materialized Views
  • Index Selectivity with Optimizer
  • Execution Plan Types: Table Scan
  • Index Scan and Index Seek Plans
  • Fill Factor, Pad Index & Sort Options
  • Sort_In_Tempdb ON / OFF Options

Day 22: Alerts, Health Checks, Issues

  • Alerts : Creation and Real-time Use
  • Alerts Configuration for Notifications
  • Database Health Check Commands
  • Allocation Errors, Consistency Errors
  • DBCC ShowContig, Extent Fragmentation
  • DBCC for Databases & Object Integrity
  • EstimateOnly, NoInfoMsgs with Tempdb
  • DDBC Page: GAM,SGAM,PFS,ML,Bitmap
  • Database Suspect Errors : Solutions
  • Consistency Errors : Cause and Solutions
  • Allocation Errors : Cause and Solutions
  • Service Startup and Configuration Modes
  • SLA and OLA Process for SQL DBA
  • Immediate, High and Normal Priorities
  • Ticketing Tools : Priority and RCA
  • Ticket Escalations, De-Escalations

REAL-TIME PROJECT (With Solution : For your Resume)

Our SQL DBA Online Training Course includes one Real-time Project on E-Commerce Database. This project involves Real-time DBA Issues and Solutions including the usage of Ticketing Tools, 3rd Party Tools. We deal with Routine SQL DBA Activities, Emergency DBA Activities and Maintenance Activities with Solutions. Also include 200+ Errors and Solutions , Database Migrations, Upgrades, Always-On Availability Groups Implementation in a Clustered Environment. This Real-time Project gives greater in-depth insight on Real-world SQL DBA Job Work and can also be used in your Resumes. Click Here to download SQL DBA Curriculum

Part 2: Azure SQL DBA [Applicable for Plan B]

Module I: AZURE SQL DATABASE

Module II: AZURE SQL DBA

Day 34: AZURE CLOUD & AZURE SQL DATABASE

  • Introduction to Cloud. Need for Cloud, Advantages
  • Cloud Architecture Basics - Iaas, PasS and SaaS
  • Advantages of Microsoft Cloud - Azure Platform
  • Azure Products and Azure Services - MarketPlace
  • Comparing Azure with Google Cloud for SQL Server
  • Comparing Azure with AWS Cloud for SQL Server
  • Azure Sources - Types, Microsoft Market Place
  • SQL Database Implementations in Azure Platform
  • Logical Servers, Virtual Machines, Managed Instances
  • Lab Plan; Install Azure Data Studio (ADS) Tool
  • Creating Azure Account, Adding Subscription
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server (Logical Server)
  • Azure Regions Selection, Pricing Calculator
  • Firewall Settings for Azure SQL Server (Logical Server)
  • Adding Firewall Rules - IP for Remote Access
  • Password Resets, Azure SQL Server Formats, Status
  • Azure Server Access from SSMS, ADS and Portal

Day 40: AZURE STORAGE, BACKUPS, RESTORES

  • Azure Storage : Purpose, Azure BLOB Data
  • Azure Storage Account Types and Creation
  • LRS, GRS and RA-GRS Azure Storage Accounts
  • Azure Resource Manager (ARM) Storage Instances
  • Classic Deployment Model Instances in Azure
  • Advanced Options with Azure Storage Accounts
  • Encrypted Data Transfer. Virtual Networks
  • Data Protection and Azure DataLake Storage
  • Azure Storage Explorer Tool Usage, File Uploads
  • Azure Storage Container and BLOB Data Options
  • Automated Backups in Azure SQL Database
  • Long Term & Automated Backup Retentions (bacpac)
  • Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Database Level Exports and Imports : SSMS
  • Database Migrations from On-Premise to Azure
  • Backups and Exports using Azure Storage
  • Azure Storage Explorer Tool using Backups

Day 35: AZURE SQL DATABASES & ON-PREMISE

  • Creating Azure SQL Databases and Pricing Tiers
  • Creating Azure SQL Databases using Portal
  • Creating Azure SQL Databases using SSMS Tool
  • Free, Basic, Standard, Premium Plans
  • Service Level Objective (SLO) in SSMS
  • Editions and Versions. Compatibility Settings
  • Virtual Core (vCore) Purchasing Options
  • General Purpose, Hyperscale, Business Critical
  • Gen 4 and Gen 5. Provisioned and Serverless
  • Collation Settings and DB Creation Scripts
  • Azure SQL Server Architecture Differences
  • Network Protocols and DB Engine Differences
  • File Structure and Filegroup Allocations
  • Secondary Files and FileStream Differences
  • Table Architecture for Partitions, Full Text Queries
  • Query Processing Differences with TDS Packets
  • Query Monitoring and Resources - Dashboards
  • Unsupported Commands with T-SQL Queries

Day 41 : HA-DR: GEO REPICATION, FAILOVER

  • Failover Groups and Active Geo-Replication
  • Read-Write Failover Policy, Automated Failover
  • Geo Replication Configurations - Azure Locations
  • Primary-Secondary and Read / Write Modes
  • GeoReplication : Monitoring and Forced Failover
  • Perform Disaster Recovery with (DR) Drills
  • Azure Server Failover Process, Strategies
  • PRIMARY, SECONDARY, FAILOVER POLICY
  • Automated Failover , Manual & Forced Failover
  • SQL Data Sync Service and Sync Groups
  • HUB, MEMBER and SYNC DATABASE
  • Sync Direction, Sync Schema and Sync Interval
  • bi-directional Load Balancing and Failover
  • Conflict Resolution Policy with HUB and MEMBER
  • Cloud to Cloud and Cloud to On-Premise Synchronization
  • Hub to Member and Member to Hub Sync Policies
  • Common Errors and Solutions - POC

Day 36 : AZURE DATABASE MIGRATIONS

  • Data Migration Assistant (DMA) Tool
  • DMA Tool : Installation and Real-time Usage
  • DMA Assessment Projects & Migration Projects
  • On-premise to Azure SQL Database Migration
  • Schema Generation and Compatibility For Migration
  • Generating Data Scripts & Assessment Reports
  • Generate and Validate Schemas. Migrations
  • Migration Scopes : Schema, Data, Schema & Data
  • Compatibility Checks and Assessment Checks
  • Resolving Database Migration Compatibility Issues
  • Stretch Databases in Azure SQL Databases
  • Stretch Databases - Tuning Benefits, Cautions
  • Table Level Migrations with Azure SQL Databases
  • Compute Performance Levels and DSU Pricing
  • Data Storage and Azure Database Snapshots
  • Remote Data Archive Configuration in Azure
  • Database Master Key [DMK] and Cold Data Migration

Day 42: SECURITY MANAGEMENT, ROW LEVEL SECURITY

  • Firewall and Virtual Network Configurations
  • Server-level Firewall & Database Firewall Rules
  • System Stored Procedures for Firewall Settings
  • Logins, Users, Roles and Permissions using T-SQL
  • Creating Logins without Logins. Containment Users
  • GRANT, DENY, REVOKE and WITH GRANT using T-SQL
  • Dynamic Data Masking, Transparent Database Encryptions
  • Data Masking Functions and Column Level Security
  • Vulnerability Assessment (VA) and Threat Detections
  • Implementing RLS - Row Level Security
  • Creating Users with & without Logins
  • Using SECURITY Schema for RLS Functions
  • Creating Security Predicates and Filters
  • Creating Security Policies for RLS
  • EXECUTE AS options for RLS. STATE ON/OFF
  • Data Level Encryption and Connection Encryption
  • Troubleshoot Encryption Errors in Azure SQL DB

Day 37: AZURE SQL DATABASE ARCHIECTURE

  • DTU : Data Transaction Units : Architecture, Pools
  • DTU - Memory and IO Resources for Reads & Writes
  • Bounding Box Model for Optimal Performance
  • Static Pools (DTU) and Elastic Pools (eDTU)
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Configuring Elastic Pools for Azure SQL Databases
  • Elastic Pools & Tier Selection - Recommendations
  • Elastic Scale for Azure SQL Database - Strategies
  • Vertical Partitioning and Horizontal Partitioning
  • Elastic Database Tool Libraries for Elastic Queries
  • Sharding - Topology for Elastic Query Processing
  • Split-Merge Service for SaaS Software Applications
  • Elastic Database Features - ShardMap, ShardKey
  • MultiShard Queries and Elastic Transactions
  • LOOKUP, HASH and RANGE Strategies for Sharding

Day 43: AZURE POWER SHELL, AZURE CLI

  • Azure Cloud Shell - Concepts, Architecture
  • Azure Power Shell - Install and Configure
  • Installing and Scripting with Power Shell
  • PowerShellGet and Version Paths
  • Cloud Shell to run the Azure Power Shell
  • Power Shell Scripts for Configurations
  • Power Shell Scripts for Job Schedules
  • Power Shell Scripts for Firewall, ARM
  • Azure CLI - Purpose, Real-time Use
  • Command Line Interface for Automations
  • Azure CLI - Downloads and Installations
  • Azure CLI - Command Prompts, Azure Login
  • Command Line Interface for Automations
  • Authorization Code, CLI Communication
  • Azure telemetry Commands and Usage
  • Help, Show, Create and Firewall Commands

Day 38: Azure SQL DATABASE TUNING - 1

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index and Drop Index
  • Query Performance Insight, Intelligence
  • Index Recommendations with CPU and IO
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Identify Long Running Queries, Intensive Queries
  • Query Level Recommendations and Query Costs
  • Azure Search Service - Configuration, Pricing Tiers
  • Azure Search for Data Import and Indexer Options
  • Suggester and Analyzer Index Modes for Tuning
  • Retrievable, Facetable, Filterable Indexes
  • Facetable and Searchable Indexes for Tuning
  • Change Tracking Options, Watermark Columns

Day 44: AZURE VIRTUAL MACHINE - WINDOWS

  • Plan for IaaS, Azure VM. Install Azure Virtual Machines
  • Install/Configure Windows Server, Readhat, Ubuntu
  • SQL Server on Azure VM - Config Settings, Elastic Pools
  • Resource Groups, Resource Pools and eDTUs
  • Verify SQL Instances in Azure VM. sysadmin Account
  • Azure Storage Blades and Pricing Options
  • Azure VM - Settings, Power Shell Scripts
  • Azure SQL Database Creation in Azure VM
  • Azure Virtual Machines ; Security Options
  • Azure SQL Database in VM to SQL Cloud
  • Azure SQL Database in VM to on-Prem
  • Deployment Automation Process, Automation Scripts
  • SQL Database in AWS and Google Cloud
  • Azure Virtual Machine Configuration Settings
  • Azure SQL Database Advantages in Virtual Machines

Day 39: Azure SQL DATABASE TUNING - 2

  • SQL Traces : Creation and Audits. Limitations
  • Extended Events and Traces for T-SQL Query Analysis
  • Extended Events Packages, Targets, Actions, Sessions
  • TSQL and SP Debug Events with XEL Files for EventInfo
  • Global Fields and Event Filters with XEL Files @ Traces
  • XE Profiler - Default Templates for Event Profiling
  • Important System Views For Azure SQL Queries
  • Important System Functions for Azure SQL Queries
  • Selection of Correct Service Tier (SLO)
  • CPU, IO and Query Analysis in Azure SQL Databases
  • Notifications Center, Activity Logs and Dashboards
  • Custom Logs (Audits) and Query Performance Impact
  • Transparent Data Encryption (TDE) and Performance
  • TDE Settings and Server Level and Database Level

Day 45: AZURE VIRTUAL MACHINE - LINUX

  • SQL Server on LINUX - RHEL (Red Hat Linux)
  • Advantages of LINUX RHEL Over Windows
  • LINUX RHEL Security Management, Firewall
  • Storage, vCores and Storage Options in VM
  • Deployment Models and Azure Resource Manager
  • LINUX Images, Resources and Virtual Machines
  • Change Type, Authentication, SSH Keys, RSA
  • Public Inbound Ports, BASH and PuTTY
  • SQL Server on LINUX - RHUBUNTU
  • Advantages of LINUX Ubuntu Over Windows
  • LINUX Ubuntu Security Management, Firewall
  • Storage, vCores and Storage Options in VM
  • Deployment Models and Azure Resource Manager
  • LINUX Images, Resources and Virtual Machines
  • Change Type, Authentication, SSH Keys, RSA
  • Public Inbound Ports, BASH and PuTTY

Day 46: SQL SERVER @ LINUX (ON-Premise)
Understanding LINUX OS Environment; LINUX OS Components - Kernel, Daemons; BootLoader, Shell and Desktop Env; SQL Server Options on LINUX Platform; Installing SQL Server on RHEL Cluster; su and sudo Commands in LINUX Cluster; Creating Linux Packages, REPO Files; Installing mssql-server Packages; Service Enable and Activation Options; Firewall Configurations, sa Passwords; Installing SQL Server Tools in LINUX; ms-sqltools Installation: SQLCMD, BCP; UNIXODBC Packages Installation, Verify; Running Test Connections and Queries;


MCSA 70-764 and MSA 70-765 : Exam Guidance, Material, Latest Papers

Above course curriculum applicable for registrations from July 9th, 2019.

24x7 Suport with Real-time Database Training. Course includes ONE Real-time Project. Register Today

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.

 
 

SQL DBA Online Training- Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • 100% Realtime and Practical Concepts
  • Chapter Wise Mock Interviews, Solutions
  • Certification & Interview Guidance
 
  • Detailed SQL Server Architecture, DB Repairs, Migrations
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA, DMA, SSMA Tools
  • SQL Clusters, Always-On. SQL DBA in Azure Cloud
  • Azure Virual Machines (VM) and Stretch Databases
  • Azure Power Shell,Azure HA-DR, Security Management
 
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses