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 3 Weeks 8 Weeks
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 8000/- INR 15000/-

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

S. No Timings (IST) Start Date  
Schedules for Chapters 26 to 37 (For Azure DBA)
1 6:30 AM - 8:30 AM (W) Jan 19th Register
2 10 AM - 12 PM (W) Feb 1st Register
Schedules for Chapter 1 to 25 (For Core SQL DBA)
1 6:15 AM - 7:15 AM Jan 21st Register
2 8:15 AM - 9:15 AM Feb 18th Register
3 10:30 AM - 11:30 AM Feb 11th Register
4 7:30 PM - 8:30 PM Feb 10th Register

If above schedules does not work, 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

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

Part 1 : SQL DBA with SQL Server, Security, HA-DR, Errors & Solutions

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: INTRO, SQL DBA JOB ROLES

  • Introduction to Databases, DBMS
  • Data Types : OLTP, DWH, OLAP
  • HTAP Databases, SQL DBA Job Roles
  • Microsoft SQL Server : Advantages, Use
  • Versions and Editions of SQL Server
  • Basic Differences between Versions
  • SQL Server Pre-requisites : S/W, H/W
  • SQL DBA Job Roles, Responsibilities
  • Routine SQL DBA Activities in Prod
  • Maintenance SQL DBA Activities
  • Emergency SQL DBA Activities
  • Azure Cloud For SQL DB Admins
  • Azure Virtual Machines (VMs)
  • SQL Server on Windows, LINUX

Ch 9: 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 Backups Errors & Solutions

Ch 17: 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: SQL SERVER INSTALLATIONS

  • System Configuration Checker Tool
  • WMI and MS XML Components
  • SQL Server 2019/2017/2016 Installation
  • Instances : Types and Properties
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Windows Logins and SQL Logins
  • FileStream, Collation Properties
  • DBEngine and Replication Components
  • Adding Firewall Rules : Security
  • Firewall Configuration in Real-time
  • SQLServr.exe and SQLBrowser.exe

Ch 10: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • RECOVERY, NORECOVERY Options
  • STANDBY and REPLACE in Restores
  • File, File Group & Metadata Restores
  • Backup Verifications using GUI, Scripts
  • VERIFYONLY : Backup Verification
  • STATS, UNLOAD, STOPAT and INIT
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backup Usage in Real-time
  • Restores using GUI and T-SQL Scripts
  • MOVE Options for File Level Restores
  • Point-In-Time Restore, Checkpoint LSN
  • Standby Restores and Read-Only State
  • Common Backups Errors & Solutions

Ch 18: 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 Backups Errors & Solutions

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

Ch 11: JOBS, MAINTENENCE PLANS

  • SQL Server Agent Service & Agent XPs
  • SQL Agent Jobs - GUI, Script Creations
  • Job Steps - Creation, Edits and Parse
  • Job Executions, Disable/Enable Options
  • Job History Purge. Job Activity Monitor
  • Database Maintenance - Backup Jobs
  • Scheduling Database Maintenance Plans
  • Backup Cleanup & History Cleanup Jobs
  • Backup Strategies For Minimal Data Loss
  • Backup Options: Block Size, Transfer Size
  • DB Mail Configurations and Alert System
  • DB Mail Profiles, SMTP Email Accounts
  • Operators : Creation, Job Notifications

Ch 19: LOG SHIPPING (HA - DR)

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

Ch 4: 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
  • ALTER & DROP Table Statements

Ch 12: 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 20: DB MIRRORING (HA - DR)

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

Ch 5: Server, DB Architecture

  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • 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 13: 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 21: 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 : CONSTRAINTS, JOINS

  • Constraints and Keys - Null, Not Null
  • UNIQUE KEY, PRIMARY KEY Constraint
  • FOREIGN KEY Constraint, References
  • CHECK Constraint Usage & Conditions
  • DEFAULT Constraint Usage and Rules
  • Identity Property : Seed & Increment
  • Database Diagrams (E R), Relations
  • JOINS & Queries For Audits
  • 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
  • CROSS JOINs and Cross Apply

Ch 14: Tuning 1 - INDEXES, AUDITS

  • 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 22: 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, SPs, 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
  • When to use Which Database Objects

Ch 15: Tuning 2 - INDEX MANAGEMENT

  • 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
  • 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

Ch 23: 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 16: 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, CPU Cost
  • Query Costs: SubTree & Operator Cost
  • NUMA Nodes and IO Affinity
  • Processor Thread Counts and DOP
  • LOCKS : Types, Isolation Levels
  • S, X, IX,U, MD, Sch-M, Sch-S
  • Lock Audits : SP_WHO2, SP_LOCK
  • sysprocesses and Lock Waits
  • Deadlock Audits, Deadlock Graphs
  • XDL Files, Deadlocks Prevention

Ch 24: ALERTS, ISSUES, SOLUTIONS

  • Alerts : Creation and Notifications
  • DB Suspect Event Alerts (023)
  • Perfmon Counters for 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 25: REAL-TIME PROJECT (With Solution : For your Resume)

Our SQL DBA Video Training Course includes one Real-time Project on E-Commerce Database. This project involves Routine SQL DBA Activities, Emergency DBA Activities and Maintenance Activities with Solutions.

ROUTINE SQL DBA ACTIVITIES : * Audit Login Failures : Server Logs * Monitoring Connectivity Issues * DB Refresh, MSDTC, Adhoc MDMP Files * PLE (Page Life Expectancy) Issues * Object Refresh and Recompilations * 3rd Party Tools : Realtime Use * Server Registrations and Operations * Log File Audits and Data Recovery * Restore Schedules and Backup Reads

EMERGENCY SQL DBA ACTIVITIES : * Server Down Issues, Solutions * Database Down Issues, Solutions * Replication @ HA-DR Issues, Solutions * Hot CPU and Processor Node, Priority * Important Events, Errors & Solutions * Service Startup Issues, Solutions * DAC (Dedicated Admin Access) Issues * Always-On (AOAG): Issues & Solutions

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

Module IV : AZURE SQL DATABASE

Module V : AZURE SQL DBA

Ch 26: 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 32 : BACKUPS / RESTORES, HA-DR Level 1

  • 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
  • Azure Storage Explorer Tool using Backups
  • Disaster Recovery (DR) Advantages in Azure
  • 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

Ch 27 : LICENSING, DTU ARCHITECTURE

  • Basic, Standard and Premium Plans For SQL DB
  • vCore Based Purchasing Options and Data Size
  • General Purpose and Business Critical Plans
  • Compute Tier : Provisioned and Serverless
  • Compute Generation : Gen 4 and Gen 5 Types
  • DTUs Allocation for Database Size, Cost Models
  • DTU : Data Transaction Units : Architecture, Pools
  • DTU - Memory and IO Resources for Reads & Writes
  • Bounding Box Model for Optimal Performance
  • Static Pools (DTU) and Elastic Pools (eDTU)
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Configuring Elastic Pools for Azure SQL Databases
  • Elastic Pools & Tier Selection - Recommendations

Ch 33 : HA-DR: Level 2, Azure Always-On

  • 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
  • Azure Server Failover Process, Strategies
  • PRIMARY, SECONDARY, FAILOVER POLICY
  • Automated Failover , Manual Failover
  • Adding Databases to Failover Group
  • Normal Failover and Forced Failover
  • Configuring and Using Azure Always-On
  • Load Balancing with Azure Always-On

Ch 28 : AZURE STORAGE, MIGRATIONS

  • Azure Storage : Purpose, Azure BLOB Data
  • Azure Storage Account Types and Creation
  • LRS, GRS and RA-GRS Azure Storage Accounts
  • Classic Deployment Model Instances in Azure
  • SQL Storage Management (SMB), Azure Storage
  • Azure Data Lake Storage (ADLS) : File System
  • Storage Containers, Storage Explorer Tool Usage
  • Database Migrations To Azure SQL
  • Database Migrations From Azure SQL
  • Database Exports and Imports in Azure
  • Data Migration Assistant (DMA) Tool
  • Migration Scopes : Schema, Data, Schema & Data
  • Schema Generation and Compatibility For Migration
  • Compatibility Checks and Assessment Checks

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

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

Ch 35 : 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
  • 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
  • Azure telemetry Commands and Usage
  • Help, Show, Create and Firewall Commands

Ch 30 : 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
  • Comparing XE Profiler with SQL Profiler Tool
  • 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

Ch 31 : ALERTS, ON-PREMISE DIFFERENCES

  • Azure SQL Server Architecture Differences
  • Network Protocols and DB Engine Differences
  • File Structure and Filegroup Allocations
  • Secondary Files and FileStream Differences
  • Query Processing Differences with TDS Packets
  • Query Monitoring and Resources - Dashboards
  • Unsupported Commands with T-SQL Queries
  • On-premise Versus Azure : Advantages
  • On-premise Versus Azure : Limitations
  • 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

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

MCSA 70 - 764 Certification : Guidance, Sample Papers, Material


MCSA 70 - 765 Certification : Guidance, Sample Papers, Material

Above course curriculum applicable for registrations from Jan 1st, 2020.

24x7 Suport with Real-time Database Training. Course includes ONE Real-time Project. 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

Job-Oriented Real-time Training @ SQL School Training Institute

SQL Server, SQL DBA, MSBI, Azure SQL Dev, Azure SQL DBA, Power BI Training