Azure SQL DBA (Admin) - Classroom Training

Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to Azure SQL Database Administration (Azure SQL DBA) activities including On-premise to Azure Azure Database Migrations, Troubleshooring, Security Management, Geo Replication, Azure Server Failover, Storage Management, Virtual Machines, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, and SQL Managed Instances. This Azure SQL DBA course also includes One Real-time Project with Routine DBA Activiteis and Emergency DBA Activities.

Azure SQL DBA (with SQL Server, Azure SQL DB Admin)

  PLAN A PLAN B
Azure SQL DBA - Job Profile Azure SQL DBA Complete DBA
Applicable For Experienced DBA Starters
Course Duration 10 Hours 40 Hours
Azure SQL Migrations Check-Symbol-for-Yes Check-Symbol-for-Yes
Query Tuning in Azure SQL DB Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure Search & Sharding Check-Symbol-for-Yes Check-Symbol-for-Yes
Built-In Intelligence Check-Symbol-for-Yes Check-Symbol-for-Yes
TDE, DDM, PITR & RLS Check-Symbol-for-Yes Check-Symbol-for-Yes
Stretch Databases in Azure Check-Symbol-for-Yes Check-Symbol-for-Yes
HA - DR in Azure SQL Databases Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure Virtual Machines Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure PowerShell, Azure CLI Croos-symbol-for-Yes Croos-symbol-for-Yes
SQL Server, DB Architecture Check-Symbol-for-No Check-Symbol-for-Yes
Query Tuning and Execution Plans Check-Symbol-for-No Check-Symbol-for-Yes
HA and DR Stategies Check-Symbol-for-No Check-Symbol-for-Yes
DB Maintenance, Repairs Check-Symbol-for-No Check-Symbol-for-Yes
Security, Locks Check-Symbol-for-No Check-Symbol-for-Yes
Errors, Issues & Solutions Check-Symbol-for-No Check-Symbol-for-Yes
Clustering & Always-ON Check-Symbol-for-No Check-Symbol-for-Yes
AAG in Windows & LINUX Check-Symbol-for-No Check-Symbol-for-Yes
Real-time Project with Solution Check-Symbol-for-No Check-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 INR 6000/- INR 15000/-

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

S. No Timings (IST) Free Demo Start Date  
Schedules for Azure SQL DBA Training
1 6:00 AM to 7:30 AM (W) Recently Started Register
2 10:30 AM to 12:30 PM (W) Apr 27th Apr 28th Register
Schedules for Core DBA Training
1 6:30 AM to 7:30 AM Apr 23rd Apr 25th Register
2 10:15 AM to 11:15 AM Apr 29th May 1st Register
3 7:30 PM to 8:30 PM May 13th May 15th Register

 

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

 

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 (RHEL)
✔ BLOB Storage ✔ Power Shell ✔ Google Cloud
✔ Virtual Machines ✔ Azure CLI ✔ AWS Cloud

Register Today for Azure SQL DBA Training

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

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

Part 1 : SQL DBA with SQL Server, T-SQL [Applicable for Plan 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

  • 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
  • 3rd Party Tools, Ticketing Tools for DBA
  • SQL DBA Roles @ Windows, Linux Clusters

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 and Precautions
  • SQL Server on Windows Versus LINUX
  • WMI : Windows Management Instrumentation
  • MSXML Parser and Associated Frameworks
  • WOW64 Components & OS Pre-Requisites
  • Instances : Concept, Types and Usage
  • Default and Named Instances : Ports
  • Windows Authentication Type and its Use
  • Mixed Mode Authentication Type and Use
  • SQL Server Services and Service Accounts
  • File Stream, Collation, SSMS Client Tool
  • Installation Error Codes and Solutions

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 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
  • 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
  • NodeID and Conflict Detection Options
  • Replication Options on Conflicts: 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
  • Replication for Load Balancing Topologies

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
  • MDAC and CLR Components, Checkpoints
  • 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
  • Full Text Catalogs and Filter Daemon
  • FDHost.Exe and Daemon Threads for FTI
  • 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
  • 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
  • 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 & JOINS

  • 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
  • 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, LOOP JOIN, HASH JOIN
  • Query Tuning with JOIN OPTIONS

DAY 16: Tuning 4 - INDEX MANAGEMENT

  • 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: INDEXES & TUNING - 1

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

DAY 17: 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. Plan Types
  • Query Costs : IO Cost and CPU Cost
  • Query Costs : SubTree Cost and Operator Cost
  • 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 (AAG)

  • 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
  • Always-On Availability Groups Health
  • New Hosts and AAA Hosts in AOAG
  • Forward Lookup Zones - AOAG Domain

DAY 8: 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
  • Dynamic Joins @ Functions, Performance
  • 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 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: SQL SERVER @ LINUX (RHEL)

  • 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

DAY 9: 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
  • Transactional Integrity in Database

DAY 19: DB Migrations, Orphan Users

  • Logins and User Mapping Concepts
  • Detecting / Auditting Orphan Users
  • Resolving Orphan Users in Databases
  • sp_resolve_login and Logins RPT File
  • Containment Authentication Type
  • Creating Users without Logins. Roles
  • Containment Users - Permissions
  • 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

DAY 29: SLA/OLA, RAID, PROCESS

  • Routine SQL Server DBA Activities
  • Maintenance SQL DBA Activities
  • Emergency SQL DBA Activities
  • End to End Process for SQL DBAs
  • Tiers & Levels of Production Support
  • Real-time Project Plan, Support Terms
  • Capacity Planning with SQL Server
  • SLA and OLA Process - Production
  • RAID Levels for SQL Databases
  • RAID for SQL Server Data Files
  • RAID for SQL Server Log Files
  • Bit Level and Block Level Parities
  • Speed and Safety Options with RAID
  • Database Size, RAM Capacity Options

DAY 10: LINKED SERVERS, CTEs

  • Linked Servers - Creation and Tests
  • sp_addlinkedserver System Procedures
  • Linked Server Security, Remote Logins
  • RPC and RPC Out. Data Access Modes
  • Four Part Naming Conventions - Options
  • Using Linked Servers for Remote Joins
  • Tuning Remote Join Queries, Options
  • CTEs: Common Table Expressions
  • Using CTEs for Data SELECT, FETCH
  • Using CTEs for Insert, Update, Delete
  • CTEs for In-Memory Data Storage
  • Overview of Cursors and FETCH
  • Cursor Types and KEYSET Indexes
  • SQL Browser Service & SSCM Tool

DAY 20: HEALTH CHECK, REPAIRS

  • Database Health Check : DBCC Commands
  • Allocation Errors, Consistency Errors
  • DBCC ShowContig, Extent Fragmentation
  • EstimateOnly, NoInfoMsgs with Tempdb
  • DDBC Page- GAM, SGAM, PFS, ML, Bitmap
  • DBCC Shrink, Suspect Pages and Repairs
  • Repair_Rebuild, DB States, Page Restores
  • Resource Governor : Real-time Usage
  • Resource Pools and Workload Groups
  • Query Priority and DOP, Grants
  • Classifier Function : RECONFIGURE
  • Policy Based Management (PBM)
  • Facets and Conditions for Policies
  • Database Recovery Model Policies

DAY 30: Ticketing Tools, Licenses

  • Ticketing Tools - REMEDY (Cloud)
  • IR, CR and SR (Incident Management)
  • SLA - OLA Reports and Tickets
  • Tickets : Properties, Ownerships
  • Impact, Urgency and Ticket Priority
  • Status, Events, Customers, Details
  • Incident Tickets and Resolutions
  • SQL Server Licensing Plans, Pricing
  • Device Type and Core Type Licenses
  • Device CAL and User CAL : Selections
  • CORE Licensing : Processor, Core
  • Multiplexing and Software Assurance
  • Pricing Options with SQL Server License
  • Version & Edition Comparisons

DAY 31 & 32: 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 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.

     PHASE 1 :
  • Auditing Login Failures
  • Monitoring Connectivity Issues
  • Auditing Long Running Queries
  • Memory Issues and Solutions
  • PLE (Page Life Expectancy)
  • 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 Managment and Integrity
  • Deadlock : Monitoring, Prevention
  • Monitor Server Health, Dashboards
               PHASE 2 :
  • 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
  • Log Shipping @ HA-DR : Issues, Solutions
  • Important Events and Errors, Solutions
  • Hot CPU and Processor Node, Priority
  • CPU Thread Counts and Windows Fibres
  • Contained Databases and Orphan Users
  • Memory Dump Files and Solutions
  • Always-On (AAG): Issues and Solutions

Part 2: Azure SQL DBA [Applicable for Plans A, B]

Module I: AZURE SQL DATABASE

Module II: AZURE SQL DBA

Day 33: 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 Instance
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server (Logical Server)
  • Creating Azure SQL Databases and Pricing Tiers
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • DTUs Allocation for Database Size, Cost Models
  • Firewall Settings for Azure SQL Server (Logical Server)
  • Adding Firewall Rules - IP for Remote Access
  • Password Resets and Azure SQL Server Name Format

DAY 39: AZURE DB BACKUPS, RESTORES

  • SQL Storage Management (SMB)
  • SMB File Storage and Azure Storage
  • Manage Storage Pools, Failed Storage Recovery
  • Space Availability on Data Volumes
  • Recovery Service Vaults, Policies with RA-GRS
  • Storage Accounts and Storage Containers in Azure
  • BLOB Data Storage: LRS, GRS, and "RA - GRS"
  • Cell Level Encryption and Always-Encrypted
  • Transparent Data Encryption (TDE)
  • Automated Backups in Azure SQL Database
  • Long Term Backup Retentions. Backup cost, Frequency
  • Automated Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Local Backups, BLOB Storage Backups, Restores
  • Encrypted Backups in Azure SQL Database
  • Database Level Exports in Portal, SSMS
  • Server Level Imports with Portal, Azure Studio

DAY 34: DTU ARCHITECTURE, ELASTIC QUERIES

  • DTU : Data Transaction Units : Architecture, Pools
  • DTU - Memory and IO Resources for Reads & Writes
  • Bounding Box Model for Optimial 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 - Stategies
  • 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 40 : AZURE SQL DATABASE - HA and DR

    • 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
    • System Views for Audit of GeoReplication
    • 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 data transfer with Azure SQL DBs
    • 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
    • Azure DB Sync for Load Balancing and Failover
    • Common Errors and Solutions - POC

    DAY 35 : AZURE DB MIGRATIONS, AZURE DATA STUDIO

    • Data Migration Assistant (DMA) Tool
    • On-premise to Azure SQL Database Migratration
    • Logical Server, Virtual Machine, Managed Instance
    • Schema Generation and Compatibility For Migration
    • Generating Data Scripts and Assessment
    • Generate and Validate Schemas. Migrations
    • Migration Scopes : Schema, Data, Schema & Data
    • Compatibility Checks and Assessment Checks
    • Resolving Database Migration Compatibility Issues
    • Azure Data Studio Tool for Database Connections
    • Azure Data Studio Features - Insights, Metrics
    • Comparing Azure Data Studio with SQL OPS Tool
    • SSMS Tool for Azure SQL Database Connections
    • SQLOPS Tool for Azure SQL Database Connections
    • SSDT (Visual Studio) for SQL Database Connections
    • Query Editor for Azure Database Access - in Portal
    • Azure Database Connections with Other Tools

    DAY 41: 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 36 : Azure SQL DATABASE TUNING, AZURE SEARCH

    • 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, Intesive Queries
    • Query Level Recommendations and Query Costs
    • Azure Search Service - Configuration, Pricing Tiers
    • Azure Search for Data Import and Indexer Options
    • Suggester and Analyser Index Modes for Tuning
    • Retreivable, Facetable, Filterable Indexes
    • Facetable and Searchable Indexes for Tuning
    • Change Tracking Options, Watermark Columns

    DAY 42: 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 37 : AZURE SQL DB & ON-PREMISE, EXTENDED EVENTS

    • 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
    • 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 and Dynamic Management Views

    DAY 43: 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, 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 38: STRETCH DATABASES, MANAGED INSTANCES

    • Stretch Databases in Azure SQL Databases
    • Stretch Databases - Tuning Benefits, Cautions
    • Table Level Migrations with Azure SQL Datbases
    • 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
    • SQL Database Managed Instance
    • Native Virtual Networks and Scalability
    • Lift and Shift LOB Applications
    • Fully Managed PaaS Infrastructure
    • Frictionless Migration for On-Premise
    • Managed Instances - Key Features
    • vCore Purchasing Model for Azure SQL DB
    • Gen 4 and Gen 5 Logical CPUs, Resource Limits
    • Key Differences : On-Premise Vs Managed Instances

    DAY 44: AWS, GOOGLE CLOUD For SQL SERVER

    • Comparing Azure SQL DB with AWS Cloud
    • Comparing Azure SQL DB with Google Cloud
    • RDS Implementation for SQL Server Databases
    • “License Included” licensing model of AWS
    • Amazon RDS for SQL Server in the AWS Console
    • Amazon RDS for SQL Server Pricing
    • Reserved Instances and Database Storage
    • Minor and Major Versions of SQL Server
    • Google Cloud Platform for SQL Server
    • SQL Server Virtual Machines in Google Cloud
    • Google Grade Infrastructure, DB Migrations
    • Data Transfer with in-out Policies
    • SQL Server Compute Engine in Google Cloud
    • Setting Up Windows Firewall, SQL Tools
    • SQL Server Creation and DB Creation, Access
    • SQL Server Tables Creation, Data Storage
    • SQL Server Migrations with Google Cloud
    Guidance and Mock Certification for MCSA 70-764 (Azure SQL DBA)
    Guidance and Mock Certification for MCSA 70-765 (Azure SQL DBA)

    Above course curriculum applicable for registrations from January 20th, 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
    • 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