Skip to main content
  • 4.7
  • 5.0

Official Learning Partner

Course Highlights

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 (DP 300) and Real-time Projects for your Resume. Versions: SQL Server 2014, 2016, 2017 and 2019.

  • Queries, Joins
  • Query Tuning
  • Excel Imports
  • Excel Pivots
  • Complex joins
  • Complex SPs
  • Tuning Tools
  • Dynamic SQL
  • CTEs, TVPs
  • In-Memory Tables
  • Azure SQL Concepts
  • Azure DB Migrations
  • Azure DB Tuning
  • Azure DB Deployments

Course Content

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

Course 1: SQL DBA Training Content [For Plans A, B, C]

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Ch 1: DATABASE INTRO & SQL DBA

  • Data, Databases and RDBMS Software
  • Database Types : OLTP, DWH, OLAP
  • Microsoft SQL Server Advantages, Use
  • Versions and Editions of SQL Server
  • SQL : Purpose, Real-time Usage Options
  • SQL Versus Microsoft T-SQL [MSSQL]
  • Microsoft SQL DBA: Job Roles
  • Routine SQL DBA Activities in Realtime
  • Emergency SQL DBA Activities, Job Work
  • Maintenance SQL DBA Activities
  • SQL Server Components and Usage
  • Database Engine Component and OLTP
  • 24 x 7 Online Lab for Remote DB Access
  • Software Installation Pre-Requisites

Ch 2: SQL SERVER INSTALLATIONS

  • System Configuration Checker Tool
  • Versions and Editions of SQL Server
  • SQL Server and SSMS Installation Plan
  • SQL Server Pre-requisites : S/W, H/W
  • SQL Server 2022 / 2019 Installation
  • SQL Server 2017 Installation
  • Instance Name and Server Features
  • Instances : Types and Properties
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Windows Logins and SQL Logins
  • FileStream and Collation Properties

Ch 3: SSMS Tool, SQL BASICS – 1

  • SQL Server Management Studio
  • Local and Remote Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • Creating Databases : Files [MDF, LDF]
  • Creating Tables in User Interface
  • Data Insertion & Storage. Limitations
  • SQL : Purpose and Real-time Usage
  • SQL Versus T-SQL : Basic Differences
  • DDL, DML, SELECT, DCL and TCL
  • Creating Tables using SQL Scripts
  • Data Storage, Inserts – Basic Level
  • Table Data Verifications with Select
  • SELECT Statement for Table Retrieval

Ch 4: SQL BASICS – 2

  • Creating Databases & Tables in SSMS
  • Single Row Inserts, Multi Row Inserts
  • Rules for Data Insertion Statements
  • SELECT Statement @ Data Retrieval
  • SELECT with WHERE Conditions
  • Batch Concept and Go Statement
  • AND and OR Operators Usage
  • 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
  • ADD, ALTER and DROP Columns

Ch 5: SQL Basics – 3, T-SQL INTRO

  • Database Objects : Tables and Schemas
  • 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 Retreival 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

Ch 6 : 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 Sorting and Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes – working with Keys

Ch 7: JOINS & LINKED SERVERS

  • 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 – Realtime Scenarios
  • Join Queries with “ON” Conditions
  • CROSS JOIN and CROSS APPLY
  • One-way, Two way Data Comparisons
  • Linked Servers Configurations
  • Linked Servers: RPC Settings & Tests
  • Linked Servers, Remote Joins in TSQL
  • Multi Server Connections, DB Access
  • 2 Part, 3 Part, 4 Part Name Conventions

Ch 8: VIEW, SPs, FUNCTIONS BASICS

  • Database Objects: Overview & Usage
  • Views: Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Functions: Types, Usage in Real-time
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Using Parameters in SQL Server
  • Dynamic Joins for Database Audits
  • 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

Ch 9: Triggers & Transactions

  • Triggers – Purpose, Real-world Usage
  • FOR/AFTER Triggers – Real time Use
  • INSTEAD OF Triggers – Real time Use
  • INSERTED, DELETED Memory Tables
  • Using Triggers for Data Replication
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommit
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Open Transaction Scenarios & Cause
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

Ch 10: DB Architecture & Group By

  • Database Architecture: Data Files
  • Database Architecture: Log Files
  • Primary and Secondary Data Files
  • Log Files Creation and Realtime Use
  • Creating and Using Filegroups
  • Linking Tables with Filegroups
  • Scripting Database and Objects
  • GROUP BY: Importance, Realtime Use
  • GROUP BY Queries and Aggregations
  • Group By Queries with Having Clause
  • Group By Queries with Where Clause
  • Using WHERE and HAVING in T-SQL
  • Using Group By in Data Audits
  • Using Group By with Joins, Audits

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Ch 11: BACKUPS & MANAGEMENT

  • 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 Backups Errors, Solutions

Ch 12: 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 Backups Errors,Solutions

Ch 13: 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 & Transfer Size
  • DB Mail Configurations and Alert System
  • DB Mail Profiles, SMTP Email Accounts
  • Operators : Creation and Real-time Use
  • Linking Jobs with Operators, Notifications

Ch 14: RECOVERY, DB SNAPSHOTS

  • Database Recovery Models, Logging
  • Database Log File Architecture
  • Full Recovery Mode, Real-time Usage
  • Simple Recovery Mode, Real-time Use
  • Bulk Logged Recovery Model, Imports
  • Recovery Models & Selectivity
  • Limitations with Simple Recovery Model
  • Database Snapshots : Creation, Use
  • Creating & Testing DB Snapshots
  • Read and Write Operations
  • Querying Database Snapshots
  • DB Snapshots: Page Versioning
  • Database Snapshots: Realtime Use
  • Comparing DB Backups & Snapshots

Ch 15: SECURITY MANAGEMENT

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

Ch 16: DATABASE MIGRATIONS

  • Creating Credentials @ Server Security
  • Creating Proxies & Agent Security
  • Linking Credentials and Proxies
  • Scritping Credentials, Proxies
  • Realtime Usage of Proxies
  • Using Proxies for DB Migrations
  • 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
  • SSMS Connections & Containment

Ch 17: SERVER ARCHITECTURE, AUDITS

  • SQL Server Architecture : Protocols
  • Named Pipes, TCP IP; Storage Engine
  • Query Processor: Parser, Optimizer
  • File Manager and Database Files
  • Transaction Services, Buffer Manager
  • CLR, WAL, Lazy Writer, Checkpoint
  • Lock Manager, IO Manager, MDAC
  • 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

Ch 18: PAGE ARCHITECTURE, INDEXES

  • Database Data Files and Pages
  • Data Pages, Mixed / Uniform Extents
  • Database Log Files and Pages
  • Virtual Log Files (VLF) and LSN
  • MINI LSN and Log File Usage Report
  • Database Files : Size and Location
  • 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
  • Database Properties & Query Store

Ch 19: TUNING: INDEX MANAGEMENT

  • PARTITIONS : Advantages, Performance
  • Table Partitions : Creation & Advantages
  • Partition Functions & Partition Schemes
  • Partitioning Un-partitioned Tables: GUI
  • Verifying / Auditting Partitioned Tables
  • Partition Compression: ROW and PAGE
  • Auditing Table Partitioned Structures
  • Statistics: Real-time Use, Performance
  • Statistics: Manual & Auto Creations
  • Internal and External Fragmentation
  • Index Rebuilding Process and Audits
  • Database Maintenance Plans Jobs
  • Last Used, Page Count, Fragmentation
  • Index Page Count, Degree Of Parallelism

Ch 20: TUNING TOOLS, EXEC PLANS

  • Tuning Tools: Workload Files, .trc Files
  • Profiler Tuning Template, SP Events
  • DTA, Profiler Trace : Recommendations
  • PDS: Physical Design Structures
  • Index, Stats, Partition Recommendations
  • DTA with Query Execution Cache
  • Perfmon Tool : Usage, Permon Counters
  • Real-time Tracking: CPU, Memory, IO
  • 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
  • Stored Procedure Recompilations

Module III: Advanced SQL DBA

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

Ch 21: REPLICATION For HA – Level 1

  • Replication Architecture and Topology
  • Publication Types – Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • Distributor and Distribution Database
  • Replication Topologies and HA DR Plan
  • Replication Jobs: Types and Usage
  • One Way and Two Way Replication
  • PUSH and PULL Subscriptions
  • Snapshot Publication: Creation, Filters
  • Snapshot Replication and Repl Agents
  • Log Reader Agent – Configuration, Keys
  • Transactional Replication Configuration
  • Security Options with Log Reader Agent
  • Replication Monitor – Tracer Tokens
  • Replication Monitor – Warnings, Alerts

Ch 22: REPLICATION For HA – Level 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Subscription Reinitialization & Expiry
  • Server Subscription & Client Subscription
  • Scripting Snapshot Replication
  • Scripting Transactional Replication
  • Limitations with Traditional Replication
  • Peer – Peer Replication : Realtime Usage
  • Configure Peer-Peer Replication
  • Multi Master Replications & Node IDs
  • Peer-Peer Replication Connections
  • Replication Conflicts and Priority Settings
  • Disabling, Cleaning Replication Topology
  • Replication: Load Balancing Topologies
  • Common Replication Errors, Solutions

Ch 23: 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
  • Comparing Replication Vs Log Shipping
  • Limitations of Log Shipping For HA DR
  • Log Shipping Errors and Solutions

Ch 24: 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
  • Database Mirroring Advantages
  • Common Mirroring Errors, Solutions

Ch 25: HEALTH CHECKS & ERRORS

  • Alerts : Creation and Notifications
  • DB Suspect Event Alerts (023)
  • Important Perfmon Counters, Alerts
  • Log Space, Memory, Tempdb Alerts
  • DBCC CHECKDB : DB Health Checks
  • Allocation Errors, Consistency Errors
  • DBCC ShowContig, 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

Ch 26: LOCK MANAGEMENT

  • LOCKS : Types and Isolation Levels
  • S, X, IX,U, MD, Sch-M and Sch-S
  • Lock Audits : SP_WHO2 & SP_LOCK
  • sysprocesses and Lock Waits : Audits
  • Open Transactions, Query Blocking
  • Lock Hints and Isolation Levels
  • Read Committed, Read Uncommitted
  • Serializable and Repeatable Read
  • Snapshot Isolation, Page Versioning
  • Read Committed Snapshot Row Version
  • Choosing Correct Isolation Level
  • Profiler Tool and Lock Templates
  • Profiler Filters, Column Selections
  • Deadlock Audits and Deadlock Graphs

Ch 27: 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
  • Verifications, Smoke Test and Rollbacks
  • Multi Instance Updates & Port Changes
  • 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

Ch 28: SLA, OLA PROCESS FOR DBA

  • SLA and OLA Process, Ticketing Tools
  • Realtime Job Environment: SLA
  • Ticketing and Process; KB Articles
  • 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
  • Edition Upgrades & Precuations
  • Command Line Installations
  • Version Checks & Edition Checks
  • Build Numbers, Server Configurations
  • Client Protocols, Ports & Server Aliases

Ch 29: 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

Ch 30: SQL DBA PROJECT – Level 2

  • Server Down Issues and Solutions
  • Database Down Issues and Solutions
  • Data Missing Issues and Solutions
  • Hot CPU and Resource Allocations
  • Port Level Issues and Solutions
  • Online & Offline Backups, Certificates
  • Ticketing Tools : SLA & OLA Concepts
  • Incident Management and Ticketing
  • Immediate, High and Medium Priority
  • Levels of Support for Production DBA
  • 3rd Party Tools and Real-time Use
  • Automated Backups, Log File Readers
  • Licensing and Pricing Options, CALs
  • Device CALs and User CALs
  • Multiplexing with Server Licenses

Course 2: Azure DBA Training Content [For Plans B, C]

Ch 31: CLOUD INTRO, AZURE CONFIG

  • Introduction to Cloud & Advantages
  • Cloud Architecture: IaaS, PasS and SaaS
  • Microsoft Cloud Advantages, Azure
  • Azure Products and SQL Services
  • Database Implementations in Azure
  • Comparing PaaS & IaaS Implmentations
  • Paas Implementations For SQL Server
  • IaaS Implementations For SQL Server
  • Logical, Virtual Machine, Azure MI
  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscription
  • Azure Resources: Resource Groups
  • Azure Active Directory: User & Groups
  • Azure Active Directory Authentication

Ch 32: AZURE SQL SERVER CONFIG

  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscriptions
  • Azure SQL Server (Logical Server)
  • Azure SQL Server Logical Server Firewall
  • Firewall Rules – IP for Remote Access
  • Server Properties and Status Format
  • Password Resets in Azure SQL Server
  • Azure SQL Databases & Pricing Tiers
  • Azure SQL Database Access from SSMS
  • Elastic Scaling with Azure Databases
  • General Purpose and Business Critical
  • Basic, Standard and Premium Plans
  • vCore Based Purchasing : Gen 4, Gen 5
  • Resource Groups For Azure SQL Server

Ch 33: ELASTIC DTUs, MIGRATION

  • Azure Storage: Creation & Containers
  • LRS, GRS, RA-GRS Storage Accounts
  • Storage Containers, Explorer Tool
  • Data and Database Migration in Azure
  • Data Migration Assistant (DMA) Tool
  • DB Migrations To Azure SQL Databases
  • Database Exports and Imports in Azure
  • Migration Scopes: Schema and Data
  • Schema Generation, Data Migration
  • Data Migration Verification, Row Count
  • DTU: Data Transaction Unit
  • Bounding Box Model, Elastic Pool
  • eDTUs, Elastic Pool. Per DB Settings
  • Performance Recommendations

Ch 34: AZURE SQL DATABASE TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Tuning Options
  • Automated Tuning and Peak-Loads
  • Force Plan, Create Index and Drop Index
  • Query Insight and Recommendations
  • IO Metrics, CPU & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic Queries
  • Query Recommendations, Query Costs
  • Azure Search Service and Pricing Tiers
  • Suggester and Analyzer Modes for Tuning
  • Retrievable, Facetable, Facetable Indexes
  • Change Tracking & Watermark Columns

Ch 35: ALERTS, BACKUPS / RESTORES

  • Azure SQL Server Activity Log and Options
  • Events, Operations and Event Categories
  • Quick Insights from Events and Filters
  • Events Exports to Event Hub, Log Analytics
  • Log Analytics Workspace, Alert Rules
  • Email / SMS Notifications and Schedules
  • Log Analytics Settings and Azure Storage
  • Activity Logs and Audit Reports, Insights
  • Azure SaaS Notifications System Options
  • Automated Backups in Azure SQL DBs
  • Long Term, Automated Backup Retentions
  • Backups – Retentions, Audits. LTR Policy
  • Restore Points and Database Recovery
  • Geo-Redundant Backups and Restores

DP 300 – Exam Samples, Guidance

Ch 36: HA-DR : GE REPLICATION, SYNC

  • Failover Groups, Active Geo-Replication
  • Read-Write Policy & Automated Failover
  • Geo Replication Configuration in Azure
  • Primary-Secondary and Read / Write
  • GeoReplication Monitor, Forced Failover
  • Azure Server Failover Process, Strategies
  • Automated, Manual and Forced Failover
  • Backup Errors, Geo Replication Errors
  • SQL Data Sync Service and Sync Groups
  • HUB, MEMBER and SYNC DATABASE
  • Sync Direction, Sync Schema & Interval
  • bi-directional Load Balancing and Failover
  • Conflict Resolutions with HUB, MEMBER
  • Cloud to Cloud, OnPremise Synchronizatio

Ch 37: SECURITY MANAGEMENT, RLS

  • Firewall & Virtual Network Configurations
  • Server Firewall, Database Firewall Rules
  • System Procedures for Firewall Settings
  • Logins, Users and Roles Permissions
  • GRANT, DENY, REVOKE, WITH GRANT
  • Role Level and Schema Level Security
  • Threat Detection,Transparent Encryption
  • Vulnerability Assessment, Data Masking
  • Implementing RLS – Row Level Security
  • SECURITY Schema for RLS Functions
  • Creating Security Predicates and Filters
  • Security Policies for Row Level Security
  • EXECUTE AS option & STATE for RLS
  • Dynamic Masking with Azure SQL DB

Ch 38: POWERSHELL, AZURE VMs

  • Azure Virtual Machines Deploy, Configure
  • Configure Windows Server, Redhat Linux
  • Azure Storage Blades and Pricing Options
  • Azure VM Settings, Access & DB Creation
  • On-Premise & Azure VMs: Similarities
  • SQL Server Instance, Agent in Azure VM
  • Azure SQL Database in VM to SQL Cloud
  • Azure SQL Database in VM to on-Prem
  • Deployment Automation Scripts in Azure
  • Azure Cloud Shell – PowerShellGet
  • Power Shell Scripts for Configurations
  • Power Shell Scripts for Job Schedules
  • Power Shell Scripts for Firewall, ARM
  • Azure CLI – Purpose, Real-time Use

Ch 39: WINDOWS CLUSTERS SETUP

  • Windows Clusters For HA and DR
  • Virtual Networks, Subnets and Ips
  • Availability Sets and Availability Zones
  • Fault Domains and Update Domains
  • DC Deployment & Configurations
  • Active Directory Domain Services
  • SAN [Storage Area Network] and LUN
  • DNS Server, DSRM and Private IP
  • Windows Level Clusters, MSCS Service
  • Active-Active, Active-Passive Clusters
  • DNS Tools, Actions & Adding AA Hosts
  • SQL Clustering Service & RAID Levels
  • SQL Cluster Groups, Domain Accounts
  • Quorum and MSDTC Disks. LUN Grows

Ch 40: ALWAYS-ON WITH SQL Server

  • SQL Server VMs and File Share Witness
  • Joining Machines to Domain Network
  • Install Accounts to Active Directory
  • Install Failover Cluster (FCI) Features
  • Firewall Configurations, Port Exceptions
  • FSW File Shares and Usability Options
  • Need for Always – On Availability (AAG)
  • Always On Availability Group [AOAG]
  • Multi-Database Replication Options
  • Backup Preferences, Automated Seeding
  • Synchronous and Asynchronous Modes
  • Data Synchronization for AOAG
  • AOAG Dashboards & Automated Failover
  • Need for Azure Managed Instances

Resume, Course Participation Certificate, Mock Interview

Course 3: ETL Admin Content [For Plans C]

Above course curriculum applicable for registrations from Apr 23rd, 2022

SQL DBA (with Server, T-SQL, Azure SQL DBA) Training Course Pricing

Plan A

Core DBA

Plan B

Core DBA +
Azure DBA

Plan C

Core DBA +
Azure DBA +
ETL Admin
Course Duration6 Weeks9 Weeks16 Weeks
Course ContentCh 1 to Ch 30Ch 1 to 40Ch 1 to 86
Completely Practical, Real-time
Routine SQL DBA Activities
Emergency SQL DBA Activities
SQL Server, DB Maintenance
DB Repairs, Security Management
Migrations, Patches, Upgrades
HA-DR : Replication, Log Shipping
HA-DR : Mirroring, Common Errors
Clustering, Always-On Availability
Tuning Tools, Execution Plans
Ticketing Tools, 3rd Party Tools
SLA-OLA, Incident Management
Azure SQL Database Migration
Azure SQL DB Security, HA-DR
Azure Always-On, PowerShell
Azure Virtual Machines (VM)
DP 300 Exam : Guidance
ETL Admin
ADE: Azure Synapse
ADE: Azure Storage
ADE: Stream Analytics
ADE: Azure Databricks
Total Course Fee*INR 20000USD 300INR 28000USD 400INR 50000USD 630

Schedules for SQL DBA (Ch 1 to 30)

S NoTime (IST, Mon - Fri)Start DateRegister
16 AM - 7 AMApr 2ndRegister
210:30 AM - 11:30 AMApr 15thRegister
39 PM - 10 PMApr 22ndRegister

Schedules for Azure DBA [Chapters 31 to 40]

S NoTime (IST, Sat & Sun)Start DateRegister
16 AM - 7:30 AMMar 30thRegister
27 PM - 8:30 PMMar 30thRegister

Azure Data Engineer Training Schedules

S NoTime (IST, Mon - Fri)Start DateRegister
17 AM - 8 AMApr 3rdRegister
27 PM - 8 PMApr 9thRegister
CURRICULUM

"*" indicates required fields

Courses*

SQL SCHOOL

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

Technical FAQs

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL ServerT-SQLSQL Server DBA and MSBI (SSISSSASSSRS) Courses. All our training services are completely practical and real-time.CREDITS of SQL School Training Center

  • We are Microsoft Partner. ID# 4338151
  • ISO Certified Training Center
  • Completely dedicated to Microsoft SQL Server
  • All trainings delivered by our Certified Trainers only
  • One of the few institutes consistently delivering the trainings for more than 8+ Years online as inhouse
  • Real-time projects in
    • Healthcare
    • Banking
    • Insurance
    • Retail Sales
    • Telecom
    • ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last EIGHT years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even aftrer the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register.html. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

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
×