SQL DBA Classroom Training (LIVE, Instructor-Led)

This SQL DBA Classroom 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 and Security Management.

This SQL DBA Training Classes also practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters as well as in LINUX Clusters. Additionally, this SQL DBA Training Course extents to Microsoft (Cloud) SQL Azure Migrations, Geo Replication, Azure DB Sync, Azure Database Tuning and Security Management. Study Material, MCSA SQL DBA Certification (70-764 & 70-765) with Real-time Projects for your Resume as also a part of this SQL DBA Training Course. Versions: SQL Server 2014, 2016, 2017 and 2019.

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 Weeks
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
New Features: SQL 2016,2017,2019 Check-Symbol-for-Yes Check-Symbol-for-Yes
Always-On in Windows Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
Always-On in LINUX Clusters Check-Symbol-for-Yes Check-Symbol-for-Yes
MCSA 70-764 Certification Croos-symbol-for-Yes Croos-symbol-for-Yes
MCSA 70-765 Certification Croos-symbol-for-No Croos-symbol-for-Yes
MCSA 70-473 Certification Croos-symbol-for-No Croos-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 PowerShell, Azure CLI Croos-symbol-for-No Croos-symbol-for-Yes
Google Cloud and AWS Cloud Croos-symbol-for-No Croos-symbol-for-Yes
Total Course Fee INR 10000/- INR 15000/-

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

Timings (IST) Free Demo Start Date  
6:30 AM to 7:30 AM Nov 29th Dec 3rd Register
10:15 AM to 11:15 AM Dec 18th Dec 20th Register
5:30 PM to 6:30 PM Nov 20th Nov 20th Register
7:30 PM to 8:30 PM Nov 26th Nov 27th Register
6:30 AM to 8:30 AM (Weekend) Nov 24th Nov 25th Register

If the above schedules does not work, Then please opt for SQL DBA Video Training.
All Trainings are completely Practical and Real-Time.

 

SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ HA-DR Issues ✔ In-Memory Data
✔ Graph Tables ✔ Stretch Databases ✔ DAC, PBM
✔ DB Migrations ✔ Licensing Plans ✔ VN, VPN Config
✔ DMA Tool ✔ SSMA Tool ✔ POCs, RCA
✔ Ticketting Tool ✔ PSSDIAG ✔ LiteSpeed
✔ Always-On ✔ Windows Clusters ✔ Linux Clusters
✔ BLOB Storage ✔ Power Shell ✔ Google Cloud
✔ Virtual Machines ✔ Azure CLI ✔ AWS Cloud

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

Brochure PDF-Image

Register Today

Part 1 : SQL DBA with SQL Server, T-SQL [Applicable for Plan A, B]

Module I: SQL Server & T-SQL

Installation, DB Architecture, Indexes, Tuning

Module II: Basic SQL DBA

Backups, Restores, Jobs, Tuning, Alerts, Security, Updates

Module III: Advanced SQL DBA

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

DAY 1: SQL DBA - JOB ROLES (INTRO)

  • Need for Databases & RDBMS Software
  • OLTP, OLAP, DWH and HTAP Databases
  • MS SQL Server - Technical Advantages
  • SQL Server Hosting : OnPremise (non-Cloud)
  • SQL Server Hosting in Cloud: Azure, AWS
  • Editions and Versions - Licensing Plans
  • SQL DBA Job Roles and Checklist Plan
  • Roles & Responsibilities For SQL DBA
  • SQL DBA Job : Routine DBA Activities
  • Maintenance, Emergency DBA Activities
  • Course Plan and Weekly Mock Interviews
  • Resume, MCSA Guidance, Virtual Labs

DAY 11: 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
  • 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 and Solutions

DAY 21: 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: SQL SERVER INSTALLATION

  • SQL Server 2019 Installation Guidance
  • SQL Server 2017 and 2016 Installation
  • Installation Pre-Requisites, Precautions
  • SQL Server Management Studio (SSMS)
  • SSMS Tool: Installation, Use, Connections
  • Instances, Instance Types & Instance IDs
  • Windows Authentication Type and its Use
  • Mixed Mode Authentication Type and Use
  • Default Admin Account in SQL Server : "sa"
  • SQL Server Services and Service Accounts
  • File Stream and Collation in SQL Instances
  • Installation Errors, Config.INI @ DAY 30

DAY 12: 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, VerifyOnly and HeaderOnly
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backups. UNDO, REDO Phases
  • Restores using GUI and T-SQL Scripts
  • Point-In-Time Restore, Checkpoint LSN
  • Standby Restores and Read-Only State
  • Restores from SQL Server 2017 to 2019

DAY 22: 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
  • Replication Conflicts: Options, sp_MSRepl
  • MSSQL_ENGXXXXX Errors & Solutions
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Priority Settings
  • Replication Verify - Rowcount, Checksum
  • Disabling, Cleaning Replication Topology
  • Replication Strategies for HA and DR Plan

DAY 3: BASIC SQL QUERIES - 1

  • DDL, DML, SELECT, DCL and TCL
  • Creating SQL Databases and Tables
  • CREATE, ALTER, DROP Statements
  • INSERT, UPDATE, DELETE Statements
  • Data Inserts, Values and Table Scan
  • INTEGER, CHAR, FLOAT Data Types
  • INSERT and INSERT INTO Statements
  • Single Row Inserts, Multi Row Inserts
  • SELECT Statement for Table Retrieval
  • WHERE Examples : =, !=, <,>, <=, >=
  • AND, OR, NOT, IN, NOT IN Conditions
  • BETWEEN, NOT BETWEEN Conditions

DAY 13: JOBS, MAINTENENCE PLANS

  • SQL Server Agent Service and Agent XPs
  • SQL Agent Jobs - GUI, Script Creations
  • Job Steps - Creation, Edits and Parse
  • Job Schedules and Email Notifications
  • 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
  • DB Mail Configurations and Alert System
  • DB Mail Profiles, SMTP Agent Operators

DAY 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
  • TUF Files and Standby Options in LS
  • Broken Log Shipping Chains & Issues
  • Log Shipping Jobs - Errors & Solutions

DAY 4: BASIC SQL QUERIES - 2

  • CHAR Versus VARCHAR Data Types
  • VARCHAR & NVARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • BIGINT, BIT, SQL_Variant Data Types
  • IS NULL, NOT NULL. LIKE, NOT LIKE
  • ORDER BY with ASC, DESC Options
  • DISTINCT, TOP and COUNT() Options
  • FETCH, OFFSET, NEXT ROW Options
  • UNION, UNION ALL and Sub Queries
  • Single Quotes, Double Quotes, Aliases
  • UPDATE : Conditional & Unconditional
  • DELETE and TRUNCATE Commands
  • ALTER Command   DROP Command

DAY 14: 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
  • Plan Handle Executions, Performance
  • Resumable Indexes: ONLINE, RESUME
  • PAUSE, MAX_DURATION. Query Store
  • Partition Mechanism : Database Filegroups
  • Partition Functions & Partition Schemes
  • Aligned / Indexed Partitions - Importance
  • Partition SPLIT and MERGE, NextUsed
  • Partition Compression : ROW, PAGE
  • Data Archival & SWITCH. Partitioned Views

DAY 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
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • Mirroring Monitor Jobs - Real-time Usage
  • Database Mirroring - Errors & Solutions

DAY 5: SERVER, DB ARCHITECTURE

  • Client Server Architecture, TDS Packets
  • SNAC and OLE DB Command for TDS
  • TDS Packets and SQL Query Processing
  • Protocols, SQL Native Client (SNAC)
  • Query Optimizer (QO) and SQL Manager
  • Storage Engine, File and DB Manager
  • Transaction Manager and Lock Manager
  • Buffer Manager, SQL OS and IO Buffer
  • DB Data Files (mdf) and Log Files (ldf)
  • Primary/Secondary Files (ndf), Filegroups
  • Write Ahead Log (WAL) and Lazy Writer
  • Logs, Checkpoints, Virtual Log File (VLF)
  • Log Sequence Number (LSN), Mini LSN

DAY 15: Tuning 3 - FTS, STATISTICS

  • Full Text Search (FTS) - Architecture
  • StopWords, Stemmer, Thesaurus For FTS
  • Indexer, Query Processor & Compilation
  • DB Catalogs, FDHost & Daemon Threads
  • Full Text Indexes (FTI), Crawler Threads
  • 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 25: PATCHES, UPGRADES, CUs

  • Establishing Downtime For Maintenance
  • Precautions for Maintenance Activities
  • 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
  • Planning for DB Maintenance Activities
  • System Database REBUILDs using CMD
  • Silent Installation & Installation Repairs
  • SQLCMD Tool and Instance Connections
  • DAC : Dedicated Administration Console
  • Verifications, Smoke Test and Rollbacks

DAY 6 : CONSTRAINTS & KEYS

  • Constraints, Keys - Table Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, OLTP Relational Tables
  • CHECK, DEFAULT & Identity Property
  • Normal Forms : 1 NF, 2 NF and 3 NF
  • BCNF, 4 NF, EKNF and ETNF Designs
  • Schemas - Purpose. Using DBO schema
  • User Defined Schemas & Data Transfer
  • Database Diagrams, PK-FK Base Tables
  • Local Temporary Tables - Session Level
  • Global Temporary Tables & Connections

DAY 16: Tuning 4 - Index Management, Locks

  • Index Management : Performance Tuning
  • Internal and External Fragmentation
  • Fragmentation Audits : DMFs, Thresholds
  • Index Reorganization, Index Rebuilds
  • Database Maintenance Plans (DMP) Jobs
  • Index Page Count and Index Condition
  • Fast, Detailed Scans. Statistics Updates
  • LOCKS : Types, Concurrency Control
  • X, S, IS, IX, U, MD, Sch-M and Sch-S
  • Lock Audits : SP_WHO2, SP_LOCK
  • Deadlock Simulation and Prevention
  • Deadlock Audits & Events in Profiler
  • Isolation Levels and Query Blocking
  • Choosing Isolation Levels in Real-time

DAY 26: 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
  • SQL Clustering Service & RAID Levels
  • RAID Levels for Data Files & Log Files
  • SQL Cluster Groups, Domain Accounts
  • Active-Active, Active-Passive Clusters
  • Quorom and MSDTC Disks. LUN Grows
  • MSCS Service Startup Options, Drains
  • Need for Always - On Availability (AAG)

DAY 7: JOINS AND QUERIES

  • JOINS - Types and Real-time Usage
  • JOIN Types and JOIN Options in T-SQL
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - LEFT, RIGHT & FULL
  • CROSS JOIN, "," and CROSS APPLY
  • MERGE JOIN - Joining Bigger Tables
  • LOOP JOIN - Joining Smaller Tables
  • HASH JOIN - Joining HEAP Tables
  • GROUP BY Queries and Aggregations
  • GROUP BY Queries with Having Clause
  • ROLLUP, CUBE Queries with Group By
  • Grouping () Functions in Rollup, Cube
  • Replacing Nulls: ISNULL, COALESCE

DAY 17: Tuning 5 - Perfmon, 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. Plan Types
  • Query Costs : IO, CPU, SubTree, Operator
  • Numa Nodes, Boost Priority & Thread Count
  • Perfmon Counters and Real-time Tracking
  • Processor, Disk, Memory, Database Counters
  • Perfmon for Big Query Audits. Memory
  • Longest Running Transactions amd TPS
  • Log File, Tempdb, Memory Issues. Solutions
  • Performance Tuning - Final Tuning Checklist

DAY 27: ALWAYS-ON AVAILABILITY - 1

  • Always On Availability Group [AOAG]
  • Synchronous and Asynchronous Modes
  • Replica Recommendations for Always-On
  • 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
  • New Hosts and AAA Hosts in AOAG
  • Forward Lookup Zones - AOAG Domain

DAY 8: VIEWS, INDEXES - TUNING 1

  • Indexes Architecture and Index Types
  • Clustered and Non Clustered Indexes
  • Included and ColumnStore Indexes
  • FILTERED and COVERING Indexes
  • UNIQUE Indexes and Query Optimizer
  • LIVE Online Indexes, Real-time use
  • B Tree Structures: Root, IAM Pages
  • Tuning Joined Queries and Conditions
  • Views on Tables - SCHEMABINDING
  • ENCRYPTION and CHECK OPTION
  • Orphan Views - Real-world Solutions
  • Cascaded Views and Encrypted Views
  • Metadata Access with System Views
  • Indexed Views / Materialized Views

DAY 18: SECURITY MANAGEMENT

  • Authentication Types - Windows, SQL Server
  • Windows Logins and REGEDIT with T-SQL
  • SQL Server Logins : POLICIES and EXPIRY
  • Logins, Users, Roles and Schemas Creation
  • Server Roles and Database Roles - Usage
  • Password Resets and Security Scripting
  • Object Level Security, Column Security
  • Logon Failures & Server Management Logs
  • Grant, With Grant, Deny, Revoke Settings
  • CONTROL, OWNERSHIP, Authorization
  • Keys & Certifications for Data Encryption
  • Credentials and Proxies for Job Security
  • DMVs for Security Audits, Orphan Users
  • Containment Databases - Users, Roles

DAY 28: ALWAYS-ON AVAILABILITY - 2

  • Always-On in LINUX Cluster Environment
  • Always On Availability Groups in RHEL
  • RHEL Clusters for SQL Server on LINUX
  • RHEL Cluster Resource Manager Settings
  • Pacemaker and SQL Server Nodes in AG
  • Subscription Management and Security
  • Certificate Backups & Restores in AAG
  • Failover Mode and Node Majority - TCP
  • Availability Group Listeners and VNN
  • AAG Health Events, Important DMVs
  • Always-On Availability : T-SQL Scripts
  • WSFC Warnings and Errors - Solutions
  • POCs @ Windows Clusters Configuration
  • POCs @ LINUX Clusters Configuration

DAY 9: FUNCTIONS, PROCEDURES

  • User Defined Functions in SQL Server
  • Scalar Functions, Inline Table Functions
  • Multi - Line Table Valued Functions
  • Table Variables and Table Data Type
  • Variables & Parameters in SQL Server
  • OBJECTID, OBJECTNAME Functions
  • System Functions & Metadata Access
  • Stored Procedures - Purpose, Usage
  • IF .. ELSE and ELSE IF Conditions
  • Using Stored Procs with Parameters
  • Recompilation of Stored Procedures
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys System SPs

DAY 19: DB MIGRATIONS, DMA TOOL

  • Database Migration Options with SSIS
  • 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
  • Migration Reports, Fixing Orphan Users
  • Data Migration Assistant (DMA) Tool
  • DMA Tool for DB Analysis, Upgrades
  • DMA Tool: DB Assessment, Migration
  • Security Logins and Users Transfer
  • Fixing Orphan Users, sp_resolve_login

DAY 29: SQL DBA Checklist - 1

  • Routine SQL Server DBA Activities
  • Emergency DBA Activities - Solutions
  • Logon Failures - Audits & Solutions
  • MSDTC & Distributed Transactions
  • Policy Based Management for AAG
  • Facets, Condition, Policies Evaluation
  • Memory Dump Files and Agent Logs
  • Linked Servers - Creation and Tests
  • Replication Options in Linked Servers
  • Linked Server Security, Remote Logins
  • RPC, RPC Out. Data Access Modes
  • Database Refresh Options, Strategies
  • Trace Flags and Server Startup Modes

DAY 10: TRIGGERS, TRANSACTIONS

  • 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 DDL Triggers - Usage
  • Server Level DDL Triggers - Usage
  • COMMIT and ROLLBACK Statements
  • EXPLICIT & IMPLICIT Transactions
  • Autocommit Transaction, ACID Options
  • Open Transactions and Query Impact
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

DAY 20: HEALTH CHECK, REPAIRS

  • DB Health Check: DBCC Commands
  • Allocation Errors and Consistency Errors
  • DBCC ShowContig, Extent Fragmentation
  • EstimateOnly, NoInfoMsgs with Tempdb
  • DBCC Shrink Commands, Database Files
  • MEMORY LEAKS, LATCH WAITS - PLE
  • Alerts - Events and Email Notifications
  • Performance Counter for Jobs, Alerts
  • DBCC Page Commands. Trace Flags
  • Page Repairs, Suspect Pages @ MSDB
  • DB Suspect Errors. Allocation Errors
  • Database States, Database Properties
  • Emergency Mode, SingleUser Mode

DAY 30: SQL DBA Checklist - 2

  • Command Line Installation. Config Files
  • Installation Errors & Un-Ininstallations
  • Service Startups - Minimal Logged Mode
  • Encrypted Backups, Managed Backups
  • Transparent Data Encryption (TDE)
  • Certificate Backups, File Encryptions
  • New Features in SQL Server 2016
  • New Features in SQL Server 2017
  • New Features in SQL Server 2019
  • SLA and OLA Process For SQL DBA
  • Ticketing Tools - REMEDY (Cloud)
  • 3rd Party Tools : Dell LITESPEED
  • 200 Point Error Checklist, Solutions

This SQL DBA Online Training Course includes one Real-time Project

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 u sage 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. Very much helpful to clear your Interviews and MCSA Certifications.

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

Module I: AZURE SQL DATABASE

Module II: AZURE SQL DBA

Day 31: 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 - market Place
  • Comparing Azure with Google Cloud for SQL Server
  • Comparing Azure with AWS Cloud for SQL Server
  • Azure Sources - Types, Microsoft Market Place
  • Azure SQL & Databases - Need, Importance
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server Instances
  • Creating Azure SQL Databases, Price Tiers
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • Isolated Price Trier - Advantages, Performance
  • Advantages of Azure SQL Databases & Tools

DAY 35: AUTOMATED DB RECOVERY, GEO REPLICATION

  • Automated Backups in Azure SQL Database
  • Long Term Backup Retentions. Backup cost, Frequency
  • Recovery Service Vaults, Policies with RA-GRS
  • Automated Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Storage Accounts and Storage Containers in Azure
  • BLOB Data Storage; LRS, GRS, and "RA - GRS"
  • Failover Groups and Active Geo-Replication
  • Read-Write Failover Policy, Automated Failover
  • Geo Replication Configurations - Azure Locations
  • Primary-Secondary and Read / Write Modes
  • Perform Disaster Recovery (DR) Drills
  • Backup Errors, Geo Replication Errors - Solutions

DAY 32: AZURE SQL DATABASE CONFIGURATION

  • DTU : Data Transaction Units : Architecture, Pools
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Elastic Pools & Tier Selection - Recommendations
  • Database Name Identifiers, Naming rules & restrictions
  • Server Names - Locations, Admin Users, Passwords
  • S1/S2/S3 DTU bands and Performance, Storage
  • Firewall Rules and IP Configuration Ranges
  • Azure Dashboard - Metrics, Notification Options
  • Azure SQL Database Collation, Connection Options, Tools
  • SQL Server Management Studio (SSMS) & Visual Studio
  • SQL Server Data Explorer Tool in Azure Cloud
  • Add-On Storage Options. Database Provisioning

DAY 36: SECURITY MANAGEMENT, HA-DR - Level 1

  • Firewall and Virtual Network Configurations
  • Server-level Firewall & Database Firewall Rules
  • Logins, Users, Roles and Permissions using T-SQL
  • GRANT, DENY, REVOKE and WITH GRANT using T-SQL
  • Dynamic Data Masking, Transparent Database Encryptions
  • Vulnerability Assessment (VA), Threat Detections
  • SQL Data Sync Service and Sync Groups
  • bi-directional data transfer with Azure SQL DBs
  • Sync Schema, Sync Direction and Sync Interval
  • Conflict Resolution Policy with HUB and MEMBER
  • Cloud to Cloud and Cloud to On-Premise Synchronization
  • Activity Logs and OMS Server Configuration
  • Hub to Member and Member to Hub Sync Policies

DAY 33 : AZURE SQL DATABASE MIGRATIONS

  • Data Migration Assistant (DMA) Tool
  • Schema Generation and Compatibility Issues
  • Generating Data Scripts and Assessment
  • Generate and Validate Schemas. Migrations
  • Database Scripting Wizard in SSMS
  • Scripting On-Premise Databases in T-SQL
  • Resolving Database Migration Compatibility Issues
  • Export Data Tier and BACPAC Files Generation
  • Migration Options with BACPAC Files
  • Creating Azure Cloud Storage Account
  • BLOB Data File Uploads and DB Imports
  • Creating Storage Containers for BLOB Data
  • Partially Supported and Unsupported Functions
  • Comparing SQL DB OnPrem and Cloud Migrations

DAY 37 : HA and DR - Level 2, Power Shell

  • HA - DR with Geo Replication & Database Synchronization
  • Azure Dashboards and Report Pins. Server Health Reports
  • Primary Database, Secondary Database Configurations
  • Automated Failover, Manual Failover and ForceStop
  • Sever Level Failover and Multi Database Recovery
  • Comparing Geo Replication and Server Failover Plans
  • Disaster Recovery Strategies for Azure SQL Databases
  • 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 Job Schedules
  • Power Shell Scripts for Firewall, ARM

DAY 34 : Azure SQL DATABASE - QUERY TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index, Drop Index
  • Azure SQL Database Performance Insight
  • Index Recommendations and History Logs
  • IO Metrics, CPU Metrics & Query Statistics
  • In-Memory Tables and Memory Optimization
  • In-Memory Performance - TPS for P15, P12
  • Azure Search Service - Purchasing Plans
  • Indexer Program - RETREIVABLE, SORTABLE
  • FILTERABLE, FACETABLE, SEARCHABLE
  • Searchable Indexes and Index Types - Options
  • Tuning Textual Data, WaterMarks in Azure
  • Bounding Box Model and DTU Scaling Options
  • Sharding and Shard Maps, Shardlets & Mapping

DAY 38: AZURE VIRTUAL MACHINE, OTHER CLOUDS

  • Plan for IaaS, Azure VM. Install Azure Virtual Machines
  • Install/Configure Windows Server, Readhat, Ubuntu
  • SQL Server on Azure VM - Config Settings, Elasitc Pools
  • Resource Groups, Resource Pools and eDTUs
  • Verify SQL Instances in Azure VM. sysadmin Account
  • Azure Storage Blads 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
  • Real-time Considerations and Bacpac File Security
  • Azure Virtual Machine Configuration Settings
  • Azure SQL Database Advantages in Virtual Machines
Guidance and Mock Certification for MCSA 70-473 (Azure SQL)

Guidance and Mock Certification for MCSA 70-473 (Azure SQL)

This AZURE DBA Training Course includes one Real-time Project

Deployments to SQL Azure Azure Database Integration Azure Cloud Versus AWS Cloud Azure Cloud Versus Google Cloud Pricing and Server Tiers Elastic Pools and Config Elastic Query Plans Geo Replication Issues Azure Interview FAQs Resume Preparation Mock Interviews Beneficial For MCSA 70-765 and 70-473 Exams

Above course curriculum applicable for registrations from October 20th, 2018.

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