SQL DBA Classroom Training (LIVE, Instructor-Led)

This SQL DBA 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 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 PLAN C
SQL DBA Job Profile Core DBA Core DBA +
Azure DBA 		 Core DBA +
Azure DBA +
Power BI
SQL DBA Course Duration 6 Weeks 8 Weeks 12 Weeks
Course Contents Ch 1 to Ch 27 Ch 1 to Ch 38 Ch 1 to Ch 56
Completely Practical, Real-time Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Routine SQL DBA Activities Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Emergency SQL DBA Activities Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Server, DB Maintenance Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
DB Repairs, Security Management Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Migrations, Patches, Upgrades Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
HA-DR : Replication, Log Shipping Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
HA-DR : Mirroring, Common Errors Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Clustering, Always-On Availability Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Tuning Tools, Execution Plans Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Ticketing Tools, 3rd Party Tools Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SLA-OLA, Incident Management Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Database Migration ❌ Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure SQL DB Security, HA-DR ❌ Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Always-On, PowerShell ❌ Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Virtual Machines (VM) ❌ Croos-symbol-for-Yes Check-Symbol-for-Yes
MCSA Exams : Guidance ❌ Croos-symbol-for-Yes Check-Symbol-for-Yes
Azure Data Access for Analysis ❌ ❌ Check-Symbol-for-Yes
Basic to Advanced Analytics ❌ ❌ Check-Symbol-for-Yes
Report Design, Modeling, Security ❌ ❌ Check-Symbol-for-Yes
Power BI Cloud, Gateways ❌ ❌ Check-Symbol-for-Yes
Report Server Administration ❌ ❌ Check-Symbol-for-Yes
Gateway Management, Admin ❌ ❌ Check-Symbol-for-Yes
Total Course Fee (Payable in installments) INR 10,000 INR 15,000 INR 22,000

** Course Fee payable in Installments.

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

S. No Timings (IST) Start Date  
Schedules for Chapter 1 to 27 (For Core SQL DBA)
1 6:15 AM - 7:15 AM Mar 31st Register
2 10:30 AM - 11:30 AM Apr 28th Register
3 8 PM - 9 PM Started Register
Schedules for Chapters 28 to 38 (For Azure DBA)
4 6:30 AM - 8 AM (W) Apr 4th Register
5 10 AM - 12 PM (W) Apr 18th Register

If the above schedules does not work, Then please opt for SQL DBA Video Training

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

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

Course Curriculum

Register Today

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Module III: Advanced SQL DBA

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

Ch 1: 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 Pre-requisites : 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

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

Ch 19: 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
  • Replication Monitor - Tracer Tokens
  • Replication Monitor - Warnings, Alerts
  • Replication Monitor - Usage and Options
  • Replication Scripts, Adding Articles
  • Replication Warnings and Agent Alerts

Ch 2: SSMS Tool, SQL BASICS - 1

  • 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

Ch 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

Ch 20: 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 Conflicts and 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 Errors and Solutions

Ch 3: SQL BASICS For DBAs - 2

  • 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

Ch 12: 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
  • 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

Ch 21: 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
  • Disconnections and Delay in Restores
  • 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 Errors and Solutions

Ch 4: 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 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
  • Session Level, Connection Level Use

Ch 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
  • Login, User, Server Principal Audits

Ch 22: 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 Errors and Solutions

Ch 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
  • Relationships Verification and Links
  • Indexes : Basic Types and Creation
  • Index Sort Options, Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes - working with Keys

Ch 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

Ch 23: 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
  • 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)

Ch 6: 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 - Realtime 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

Ch 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

Ch 24: ALWAYS ON AVAILABILITY

  • 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 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
  • AAA Hosts, Forward Lookup Zones

Ch 7: 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, Perrformance Benefits
  • System Objects for Metadata Access

Ch 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

Ch 25: 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
  • 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
  • Service Startup Issues and Solutions

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

Ch 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

Ch 26: 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 9: 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

Ch 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

Ch 27: 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 and Offline Backups - Issues
  • 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

Module IV : AZURE SQL DATABASE

Module V : AZURE SQL DBA

Ch 28: AZURE CLOUD INTRO, CONFIGURATION

  • 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
  • SQL Database Implementations in Azure Platform
  • Logical Servers, Virtual Machines, Managed Instance
  • Installing SSMS and Azure Data Studio (ADS) Tools
  • Creating Azure Account and Free Subscriptions
  • Creating Azure SQL Server (Logical Server)
  • Firewall Settings for Azure SQL Server (Logical Server)
  • Adding Firewall Rules - IP for Remote Access
  • Server Properties and Status Check. Server Name Format
  • Password Resets and Azure SQL Server Name Format
  • Creating Azure SQL Databases and Pricing Tiers
  • Azure SQL Database Access from SSMS Tool

Ch 33 : HA - DR LEVEL 1

  • 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
  • Azure Server Failover Process, Strategies
  • Automated Failover , Manual & Forced Failover
  • Backup Errors, Geo Replication Errors - Solutions
  • 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 / On-Premise Synchronization
  • Hub to Member and Member to Hub Sync Policies

Ch 29 : DTU, ELASITC QUERIES, MIGRATIONS

  • Azure Storage : Types, Creation & Containers
  • LRS, GRS and RA-GRS Azure Storage Accounts
  • Storage Containers, Storage Explorer Tool Usage
  • Data Migration and Database Migration in Azure
  • Data Migration Assistant (DMA) Tool, Assessment
  • Data / Database Migrations To Azure SQL
  • Database Exports and Imports in Azure with bacpac
  • Migration Scopes : Schema, Data, Schema & Data
  • Schema Generation and Compatibility For Migration
  • Data Migration Verification and Row Counts
  • DTU : Data Transaction Unit, Resource Allocations
  • Basic, Standard and Premium Plans For SQL DB
  • vCore Based Purchasing : Gen 4 and Gen 5 Types
  • General Purpose and Business Critical Plans
  • Compute Tier : Provisioned and Serverless
  • Bounding Box Model, Elastic Pools & Queries
  • eDTUs and Elastic Pool, per Database Settings
  • Elastic Scaling with Azure SQL Databases

Ch 34 : HA - DR LEVEL 2

  • Azure AlwaysOn with SQL Server Clusters
  • Primary Node and Secondary Node Clusters
  • SQL Server Virtual Machines and Settings
  • Domain Controller (DC) Virtual Machines
  • Witness File Share (WFS) Settings in DC
  • Azure Server Failover Process, Strategies
  • Adding Databases to Failover Group
  • Always On Health Check Reports (AOAG)
  • Configuring and Using Azure Always-On
  • Load Balancing with Azure Always-On
  • Azure Cloud Shell - PowerShellGet, Versions
  • 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 telemetry Commands and Usage
  • Help, Show, Create and Firewall Commands

Ch 30 : AZURE SQL DATABASE TUNING

  • 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, Recommendations
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic 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
  • Full Text Search : Performance Advantages

Ch 35 : SECURITY MANAGEMENT, RLS

  • 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, WITH GRANT Permissions
  • Role Level and Schema Level Security in Azure
  • Threat Detection, Transparent Database Encryption
  • Vulnerability Assessment, Dynamic Data Masking
  • Implementing RLS - Row Level Security
  • Creating Users with and without Logins
  • Using SECURITY Schema for RLS Functions
  • Creating Security Predicates and Filters
  • Security Policies for Row Level Security
  • EXECUTE AS options for RLS. STATE ON/OFF
  • Dynamic Data Masking with Azure SQL Database
  • Implementing DDM with Azure Portal & T-SQL

Ch 31 : XEL GRAPHS, STRETCH DATABASES

  • SQL Traces : Creation and Audits. Limitations
  • SQL Traces : Event Class, Category, Filter, Conditions
  • Extended Events Package, Target, Action, Session
  • TSQL and SP Debug Events with Global Fields
  • XE Objects : Catalog & Dynamic Management Views
  • XE Profiler - Templates for Event Profiling (Audits)
  • Comparing XE Profiler with SQL Profiler Tool
  • Comparing Azure SQL Database with On-Premise
  • 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
  • Geo Backup Of Tables and Hybrid Cloud Settings
  • Remote Data Archive Configuration in Azure
  • Database Master Key [DMK], Cold Data Migration
  • Real-time Advantages of Stretch Databases

Ch 36 : AZURE VIRTUAL MACHINE - WINDOWS

  • IaaS, Azure VM. Install Azure Virtual Machines
  • Install/Configure Windows Server, Redhat, Ubuntu
  • SQL Server 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, DB Creation in Azure VM
  • On-Premise & Azure Virtual Machines: Similarities
  • SSMS, SQL Server Instance, Agent 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
  • Public Access with SQL Server Instance, Security

Ch 32 : 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 Database
  • Long Term & Automated Backup Retentions (bacpac)
  • Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Geo-Redundant Backups and Advantages in Azure
  • Restore Options and DB Creations with LTR
  • Azure Storage Explorer Tool using Backups
  • Disaster Recovery (DR) Advantages in Azure

Ch 37 : LINUX VM, MANAGED INSTANCES

  • 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
  • RHEL Clusters for SQL Server on LINUX
  • Failover Mode and Node Majority - TCP
  • Deployment Models and Azure Resource Manager
  • RHEL Cluster Resource Manager Settings
  • Pacemaker and SQL Server Nodes in AG
  • SQL Database Managed Instance - TDE
  • Native Virtual Networks and Scalability
  • Lift - Shift LOB Applications, PaaS Infrastructure
  • Frictionless Migration for On-Premise
  • vCore Purchasing Model for Azure SQL DB
  • Gen 4 and Gen 5 Logical CPUs, Resource Limits
  • Managed Instances Vs AWS & Google Cloud
  • Cell Level Encryption and Always-Encrypted

Chapter 38 : MCSA Certification Guidance with Resource Governor, Policy Based Management, Real-time Project for your Resume, Job Work

Above course curriculum applicable for registrations from March 6th, 2020

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.

 
Trainer Profile
Reviews
Course Curriculum
Training Details
Free Demo
Register Today
 

SQL DBA Online Training- Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • 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
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses