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 Training Plans

  PLAN A PLAN B PLAN C
SQL DBA Job Profile Azure DBA Core DBA +
Azure DBA
Core DBA +
Azure DBA +
Azure DevOps
SQL DBA Course Duration 3 Weeks 9 Weeks 13 Weeks
Course Contents Ch 28 to Ch 39 Ch 1 to Ch 39 Ch 1 to Ch 57
Azure SQL Database Migration
Azure SQL DB Security, HA-DR
Azure Always-On, PowerShell
Azure Virtual Machines (VM)
DP 300 Exam : Guidance
Routine SQL DBA Activities
Emergency SQL DBA Activities
SQL Server, DB Maintenance
DB Repairs, Security Management
Migrations, Patches, Upgrades
HA-DR : Replication, Log Shipping
HA-DR : Mirroring, Common Errors
Clustering, Always-On Availability
Tuning Tools, Execution Plans
Ticketing Tools, 3rd Party Tools
SLA-OLA, Incident Management
Azure DevOps Benefits
SDLC, Dev & Operations, DevOps
DevOps Tools, Git & GitHub
Docker, Kubernetes, AzureDevOps
Azure Boards, Azure Repos
Azure Testing, Azure Artifacts
Azure Pipelines (CI, CD)
Total Course Fee
* Payable in Installments
INR 9,000
USD 122
INR 27,000
USD 365
INR 39,000
USD 527

Trainer : Mr. Sai Phanindra T

Schedules for Azure DBA [Chapters 28 to 39]
S No Timings (IST) Start Date  
  Weekend Schedules [Sat & Sun]
1 6 AM - 8 AM Feb 27th Register
2 8 PM - 10 PM Mar 13th Register
Schedules for SQL DBA [Chapters 1 to 27]
S No Timings (IST) Start Date  
Regular Schedules [Mon - Fri]
1 6 AM - 7 AM Mar 23rd Register
2 8 PM - 9 PM Mar 3rd Register

Azure SQL DBA TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ HA - DR Issues
✔ Azure Migrations ✔ XEL Graphs
✔ DAC, PBM ✔ Stretch Databases
✔ DB Migrations ✔ Licensing Plans
✔ Azure HA - DR ✔ In-Memory Tables
✔ DMA Tool ✔ POCs, RCA
✔ Ticketing Tool ✔ Tuning Tools
✔ Updates, Rollbacks ✔ Always-On
✔ SLA / OLA ✔ Upgrades, Rollbacks
✔ Lite Speed ✔ Windows Clusters
✔ Managed Instance ✔ Realtime Errors
✔ Linux (RHEL) ✔ Virtual Machines
✔ Capacity Planning ✔ Power Shell
✔ Service Startups ✔ Shard Keys
✔ BLOB Storage ✔ Azure Storage Keys
✔ DBA Checklists ✔ Azure RM, eDTU
✔ MCSA Guidance ✔ Rebuilds, Repairs
✔ Managed Instances ✔ Foglight, Automations

All Trainings are completely Practical and Real-Time. Curriculum Download

Chapter wise FAQs with Answers, Real-time Project are part of this Azure SQL DBA Online Training Course Register

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

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Module III: Advanced SQL DBA

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

Ch 1: JOB ROLES, INSTALLATION

  • Introduction to Databases, DBMS
  • Microsoft SQL Server : Advantages, Use
  • Versions and Editions of SQL Server
  • SQL DBA Job Roles, Responsibilities
  • Routine Maintenance DBA Activities
  • Emergency SQL DBA Activities
  • SQL Server Pre-requisites : S/W, H/W
  • SQL Server 2019/2017/2016 Installation
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Firewall Configuration in Real-time
  • SQLServr.exe and SQLBrowser.exe

Ch 10: BACKUPS - DB, Filegroup, File

  • Database Backups, Filegroup Backups
  • Log File Backups and Log Truncations
  • COPY_ONLY Backups and Real-time Use
  • Mirror Backups and Split Backups
  • Partial Backups - ReadOnly Filegroups
  • Format, Compression and Checksum
  • Backup Verification, RetainDays, Stats
  • ContinueOnError and Backup Scripts
  • GUI and Script Backups: Differences
  • Backup History Tables in MSDB - Joins
  • Backup Audits. HOT and COLD Backups
  • Backup Devices - Creation and Usage
  • Using Backup Devices - Advantages
  • Common Errors and Solutions

Ch 19: REPLICATION For HA - Level 1

  • Replication Architecture and Topology
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • Distribution DB Configuration, Snapshots
  • Snapshot Replication and Repl Agents
  • Adding Articles to Existing (LIVE) Replica
  • PUSH, PULL Subscriptions. N/W Shares
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Replication Monitor - Tracer Tokens
  • Replication Monitor - Warnings, Alerts
  • Replication Monitor - Usage and Options
  • Replication Scripts, Adding Articles
  • Replication Warnings and Agent Alerts

Ch 2: SSMS Tool, SQL BASICS - 1

  • SSMS Tool Installation, Connections
  • SQL Server Management Studio
  • Single Server, Multi Server Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • SQL and T-SQL : Basic Differences
  • DDL, DML, SELECT Statements
  • Using GUI and SQL Scripts in SSMS
  • Creating Databases : Files [MDF, LDF]
  • Creating Tables in SQL Server
  • Data Storage in Tables : Inserts
  • SELECT : Data Retrieval Statement
  • Table Scans. LIVE QUERY STATISTICS
  • Limitations with SSMS GUI Options

Ch 11: RESTORES & DB RECOVERY

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

Ch 20: REPLICATION For HA - Level 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Subscription Reinitialization, Expiry Setting
  • Server Subscription & Client Subscription
  • Peer-Peer Replication Connections, Nodes
  • NodeID and Conflict Detection Options
  • Replication Conflicts and sp_MSRepl
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Priority Settings
  • Replication Verify - Rowcount, Checksum
  • Disabling, Cleaning Replication Topology
  • Replication Strategies for HA and DR Plan
  • Replication for Load Balancing Topologies
  • Common Errors and Solutions

Ch 3: SQL BASICS For DBAs - 2

  • Creating Databases in SQL Server
  • Database Connections and Usage
  • Creating Tables and Data Storage
  • Data Inserts and SELECT Statement
  • WHERE Conditions and Keywords
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • LIKE and NOT LIKE Operators
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • Logged and Non-Logged Operations
  • Table Structure Modifications
  • ADD, ALTER and DROP Columns
  • Aliases and Batch Statements

Ch 12: JOBS, MAINTENENCE PLANS

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

Ch 21: LOG SHIPPING (HA - DR)

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

Ch 4: SCHEMAS, TEMP TABLES

  • Schemas : Group Tables in Database
  • Schemas : Security Management Object
  • Creating Schemas & Batch Concept
  • Using Schemas for Table Creation
  • Data Storage in Tables with Schemas
  • Data Retrieval, Usage with Schemas
  • Table Migrations across Schemas
  • Import and Export Wizard in SSMS
  • Data Imports with Excel File Data
  • Performing Bulk Operations in SSMS
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • # and ## Prefix, Scope of Usage
  • Session Level, Connection Level Use

Ch 13: SECURITY MANAGEMENT - 1

  • Authentication Types & Modifications
  • Windows Logins & SQL Server Logins
  • Logins - Users Mapping, DB Access
  • Server Roles & Database Roles - Usage
  • Object, Column and Schema Security
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • Data Encryption: Keys and Certificates
  • Data Encryption with Stored Procedures
  • Job Security : Credentials and Proxies
  • Using Proxies for SSIS Jobs, Repl Jobs
  • Security Scripts and Documentation
  • DMVs for Security Audits, Orphan Users
  • Login, User, Server Principal Audits

Ch 22: DB MIRRORING (HA - DR)

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

Ch 5: CONSTRAINTS, INDEX Basics

  • Constraints and Keys - Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, CHECK and DEFAULT
  • Candidate Keys and Identity Property
  • Database Diagrams and ER Models
  • Relationships Verification and Links
  • Indexes : Basic Types and Creation
  • Index Sort Options, Search Advantages
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Need for Indexes - working with Keys

Ch 14: MIGRATIONS & SECURITY - 2

  • Database Migration Precautions
  • Migration Methods & Comparisons
  • CDW: Copy Database Wizard @ SSMS
  • Database Detach and Attach Options
  • SMO Method and Database Scripting
  • Creating and Using Credentials
  • Creating and Using Agent Proxies
  • SSIS Job Subsystem with Proxies
  • Copy Database Wizard: SSIS Packages
  • Scheduling Database Migration Jobs
  • Transfer of Logins & Server Objects
  • Detecting and Resolving Orphan Users
  • Containment Databases Authentication
  • Login Failure Audits & Server Logs

Ch 23: Health Checks, Issues, Solutions

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

  • JOINS - Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins - Realtime Scenarios
  • Join Queries with "ON" Conditions
  • Join Unrelated Tables in SQL Server
  • NULL, IS NULL Operators in Joins
  • CROSS JOIN and CROSS APPLY
  • CROSS JOIN Versus CROSS APPLY
  • One-way, Two Way Data Comparisons
  • Important Join Queries in T-SQL
  • Join Options: Merge, Loop, Hash

Ch 15: Tuning 1 - Audits, Indexes

  • Audit Long Running Queries : DMV, DMF
  • Activity Monitor Tool, Server Dashboards
  • Logical I/O, Physical I/O, Database I/O
  • Recent Expensive Queries, Wait Time
  • Active Expensive Queries, Statistics
  • Plan Handle, Execution Time - Audits
  • CPU, IO, Memory Consumption Reports
  • Indexes: Architecture and Index Types
  • B Tree Structure, IAM Page [Root]
  • Clustered & NonClustered Indexes
  • Included, Columnstore, Online
  • Filtered, Covering, Indexed Views
  • Fill Factor and Pad Index Options
  • Query Store - Settings and Advantages

Ch 24: 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
  • System Database REBUILDs using CMD
  • Silent Installation & Installation Repairs
  • SQLCMD Tool and Instance Connections
  • DAC : Dedicated Administration Console
  • Service Startup Issues and Solutions

Ch 7: View, Procedures, UDF Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Date and Time Functions : Getdate()
  • Variables & Parameters in SQL Server
  • Procedures : Types, Usage in Real-time
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Sp_help, Sp_helpdb and sp_helptext
  • sp_pkeys, sp_rename and sp_help
  • sp_recompile, Perrformance Benefits
  • System Objects for Metadata Access

Ch 16: Tuning 2 - INDEX MANAGEMENT

  • PARTITIONS : Advantages, Performance
  • Partition Functions & Partition Schemes
  • Partitioning Un-partitioned Tables: GUI
  • Partition Compression : ROW and PAGE
  • Auditing Table Partitioned Structures
  • Statistics : Purpose, Auto Creation
  • Statistics : Audits and Updates
  • Working with Indexes and Partitions
  • Internal and External Fragmentation
  • Index Rebuilding Process and Audits
  • Database Maintenance Plans Jobs
  • Last Used, Page Count, Fragmentation
  • Index Page Count and Index Condition
  • Degree Of Parallelism [DOP] Settings
  • Resumable Indexes: ONLINE, RESUME
  • PAUSE & RESUME in Index Rebuilds

Ch 25: ALWAYS ON AVAILABILITY

  • Always-On: Non-Clustered Environment
  • Multi Database Replication with 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: AAG
  • AOAG Verifications and Dashboards
  • Adding Availability Replica, Database
  • Adding Availability Listeners and DNS
  • Automated Failovers, Manual Failovers
  • Always-On Availability Groups Health
  • NonClustered Environment Limitations
  • Clustering with Always-On in Ch 37,38

Ch 8: Triggers & Transactions

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

Ch 17: Tuning 3 - Tuning Tools

  • Tuning Tools: Workload Files, .trc Files
  • Profiler Tuning Template, SP Events
  • DTA, Profiler Trace : Recommendations
  • PDS: Physical Design Structures
  • Index, Stats, Partition Recommendations
  • DTA with Query Execution Cache
  • Perfmon Tool : Usage, Permon Counters
  • Real-time Tracking: CPU, Memory, IO
  • Execution Plan Analysis and Internals
  • Query Costs: IO Cost and CPU Cost
  • Query Costs: SubTree & Operator Cost
  • NUMA Nodes, Processor, IO Affinity
  • Thread Count, Degree of Parallelism
  • Stored Procedure Recompilations
  • Table Scan, Index Scan, Index Seek

Ch 26: SQL DBA PROJECT - Level 1

  • Audit Login Failures : Server Logs
  • Monitoring Connectivity Issues
  • Database Refresh and MSDTC
  • Adhoc Memory Dump Files
  • PLE (Page Life Expectancy) Issues
  • Object Refresh and Recompilations
  • Server Registrations and Operations
  • Lock Monitoring Operations
  • Index Management Options
  • Open Transactions, Blocking
  • Metadata Sync-up Issues
  • Stored Procedure Recompilations
  • Backup and HA-DR Strategies
  • Db Restores and DB Repairs
  • Health Checks, Issues, Solutions

Ch 9: Server, DB Architecture

  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • File Manager and Database Files
  • Transaction Services, Buffer Manager
  • Lock Manager, IO Manager, MDAC
  • CLR, WAL, Lazy Writer, Checkpoint
  • Database Architecture - Data Files
  • Primary (mdf), Secondary Files (ndf)
  • Filegroups; File Size, Location
  • Pages, Extents. Uniform, Mixed Extents
  • Transaction Log File [LDF], LSN, VLF
  • Linked Servers and Remote DB Access
  • RPC, RPC Out and Remote Data Access

Ch 18: Tuning 4 - Lock Management

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

Ch 27: SQL DBA PROJECT - Level 2

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

Ch 28: CLOUD INTRO, AZURE CONFIG

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

Ch 32: XEL, STRETCH DATABASES

  • SQL Traces : Creation and Audits
  • Event Class, Category, Filter, Conditions
  • Extended Events, Target, Action, Session
  • TSQL, SP Debug Events with Global Fields
  • Catalog & Dynamic Management Views
  • XE Profiler - Templates for Event Profiling
  • Comparing XE Profiler with SQL Profiler
  • Azure SQL Database with On-Premise
  • Stretch Databases Tuning Benefits, Cautions
  • Table Migrations with Azure SQL Databases
  • Compute Performance Levels, DSU Pricing
  • Data Storage, Azure Database Snapshots
  • Remote Data Archive Configuration in Azure
  • Database Master Key, Cold Data Migration

Ch 36: POWERSHELL, AZURE VMs

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

Ch 29: AZURE SQL SERVER CONFIG

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

Ch 33: ALERTS, BACKUPS / RESTORES

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

Ch 37: Windows Clusters with Azure VM

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

Ch 30: ELASTIC DTUs, MIGRATION

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

Ch 34: HA - DR : Geo Replication, DB Sync

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

Ch 38: Always-On in SQL Server Clusters

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

Ch 31: 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
  • Performance Insight and Recommendations
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic Queries
  • Query Recommendations, Query Costs
  • Azure Search Service and Pricing Tiers
  • Azure Search for Data Import. Indexer
  • Suggester and Analyzer Modes for Tuning
  • Retrievable, Facetable, Facetable Indexes
  • Filterable and Searchable Indexes
  • Change Tracking & Watermark Columns

Ch 35: SECURITY MANAGEMENT, RLS

  • Firewall and Virtual Network Configurations
  • Server Firewall, Database Firewall Rules
  • System Procedures for Firewall Settings
  • Logins, Users, Roles Permissions @ T-SQL
  • Creating Users without Logins. Containment
  • GRANT, DENY, REVOKE, WITH GRANT
  • Role Level and Schema Level Security
  • Threat Detection, Transparent Data Encryption
  • Vulnerability Assessment, 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 option & STATE for RLS
  • Dynamic Data Masking with Azure SQL DB

Ch 39: Project Work, DP 300 Exam

Real-time Project

 

DP 300 Certification Guidance

 

Module I: Azure Funda & DevOps Basics

Module II: Azure DevOps Service - 1

Azure DevOps Service - 2
Az DevOps Server

Ch 1. Azure Fundamentals

  • Basics of Cloud Computing
  • Cloud Services: Advantages
  • Cloud Services: Product Models
  • Virtualization Concepts in Cloud
  • Comparing On-Premise with Cloud
  • DevOps : Introduction, Use
  • Azure Cloud : Features, Advantages
  • Azure Cloud : Services & Usage
  • Azure Cloud : Platform Components
  • Azure Resoures, Service Types
  • Azure PaaS, IaaS & SaaS
  • Azure Account Creation, Resources

Ch 7: Organizations & Projects

  • Azure DevOps: Implementation Plan
  • Creating and Using Organizations
  • Planning and Security Advantages
  • Region Specifications and Owners
  • Users and Resource Limits
  • Azure DevOps - Org Notifications
  • Azure Projects - Creation, Use
  • Public and Private Projects
  • Version Control: Git and TFS
  • Work Item Process: Agile
  • Basic, CMM and Scrum Options
  • Security, Teams, Dashboards

Ch 13: Azure Functions, App Service, Alerts

  • Azure Functions and Automations
  • Azure Event Notifications, Audits
  • Azure App Services & Webapps
  • Build, Deployment and Scaling
  • Azure App Service Migrations
  • Azure Apps Versus DevOps
  • Azure Monitoring and Alerts
  • Notification Options in Azure
  • Alert Management, Operators
  • Creating, Managing Alert Rules
  • RBAC , Continuous Monitoring
  • Smart Groups and Performance

Ch 2. Azure Services, Configurations

  • Azure Registration and Azure Portal
  • Azure Resources and Azure Services
  • Azure Resource Types, Resource Groups
  • Creating Resource Groups in Azure Portal
  • Resource Groups: Access, Advantages
  • Cost and Billing Management
  • Azure Storage Account Creation
  • Storage Account Types, Replication
  • Azure BLOB Data Storage Containers
  • Azure Storage Explorer Tool
  • Uploads, Imports, SAS and Access Key
  • Azure File Storage and On-Premise Access

Ch 8: Azure Boards

  • Azure Boards - Creation, Use
  • Work Item - Fields & Sprints
  • Kanban Boards, Item Tracking
  • Backlogs and Code Testing
  • Bugs and Feature Requests
  • Team Dashboards, Monitoring
  • Azure Boards with Agile Process
  • Azure Boards For CMMI Procces
  • Azure Boards For Scrum Procces
  • Change Column & Queries
  • Style Rules and Highlight Cards
  • Color Tag & Work Item Cards

Ch 14: Azure DevOps Resources in Portal

  • Azure DevOps Services From Portal
  • Application Insights and Logs
  • Log Analytics and Storage Account
  • API Management Services
  • API Connections in Azure
  • Azure DevOps Organizations
  • DevTest Labs From Azure Portal
  • Build Apps with Azure DevOps
  • Azure Pipelines and Samples
  • Plan and Buld Tasks in DevOps
  • Setup Azure DevOps Org Account
  • Create & Publish Azure Pipelines

Ch 3. Azure Active Directory, Monitoring

  • Azure Active Directory Service
  • Azure AD : Users, Tokens & Passwords
  • Azure AD : Groups, Members, Owners
  • Azure AD : App Registrations, Tokens
  • Service Principals and Real-time Use
  • Identity & Access Management (IAM)
  • Azure Monitoring and Metrics
  • Azure Dashboards and Counters
  • Customizations and Usage Reports
  • Azure Alerts and Conditions
  • Notifications: Push/Email/SMS
  • Log Analytics and Health Checks

Ch 9: Azure Repos

  • Azure Repository (Repo), Storage
  • Distributed Versus Centralized
  • Azure DevOps Repos: Cloning
  • Commit, Push and Pull Options
  • Branch & Branch Policies
  • Fork, Git and WorkFlow
  • Git Versus TFVC, Customizations
  • Public Projects and Pull Requests
  • Notification Options in Repos
  • Team Foundation Version Control
  • Git and TFS Projects in DevOps
  • Azure Repos with Slack

Ch 15: Azure DevOps Strarter, App Insights

  • Azure DevOps Starter Deployments
  • Migrations from Git Repository
  • Continuous Integration (CI)
  • Continuous Delivery (CD)
  • Item Pipeline and Workflow
  • Azure DevOps Pipelines
  • DevOps Starter, Github Integration
  • DevOps Starter, DevOps Integration
  • DevOps Starter Vs Azure DevOps
  • Github Actions & Azure DevOps
  • Azure DevOps to Azure VM
  • Examine CI and CD Pipelines

Ch 4. SDLC, Dev & Operations, DevOps

  • Software Development Life Cycle
  • SRS Documents and Principles
  • Design, Planning and Coding
  • Coding Techniques and Tools
  • Testing Operations, Issues
  • UAT, Production Deployment Issues
  • Need for DevOps Services
  • Life Cycle Management
  • Automations and Code Control
  • DevOps Tools and Techniques
  • DevOps : Advantages, Benefits
  • DevOps Engineers: Job Roles

Ch 10: Azure Pipelines For CI/CD - 1

  • Azure Pipelines - Architecture, Creation
  • Azure Pipeline Creation Ecosystem
  • Continious Integration (CI)
  • Continious Development (CD)
  • Build Pipeline in Azure DevOps
  • Key Concepts, Real-time Use
  • Creating Pull and Push Requests
  • Release Pipelines - Creation, Use
  • Multi Stage Release Pipelines
  • New Branch Options with Pipelines
  • Classic Release Pipelines
  • Classic Editor - Pipeline Creation

Ch 16: Power Shell & Azure DevOps

  • Azure Power Shell and DevOps
  • Power Shell Installations
  • Power Shell in Azure Portal
  • Creating Resources in Portal
  • Creating Pipelines in PowerShell
  • YAML Snippet and Arguments
  • Writing Sample Apps, Builds
  • Writing Warnings and Errors
  • Powershell with Multiple Args
  • Service Fabric Manifests
  • Publish Test Results in DevOps
  • Run Functional Test Results

Ch 5. DevOps Tools, Git & GitHub

  • DevOps Tools & Life Cycle Stages
  • Continuous Development (CD)
  • Continuous Integration (CI)
  • Planning Phase: UML Tools
  • Code: Visuaal Studio, Git
  • Build: Maveen and Gradle
  • Test: Selleinum and Junit
  • Release: Jenking, Bamboo
  • Deploy: Puppet, Chef, Ansible
  • Operate: Visual Studio Options
  • Monitor: NewRelic, Splunk
  • Git & GitHub For Code Store

Ch 11: Azure Pipelines For CI/CD - 2

  • Continous Integration Pipelines
  • PreDeployments in Azure devOps
  • WorkTeam Correlation Options
  • Azure Pipelines - Customizations
  • GitHub with Azure Active Directory
  • GitBub with DevOps Integration
  • Pipeline Creation Comparisions
  • AzurePipelines for YAML
  • Agent, Approvals and Artifacts
  • Caching, Conditions and Jobs
  • Classic Builds and Class Release
  • Dependancies, Job Deployments

Ch 17: DevOps Server - Configurations

  • Azure DevOps Server - Advantages
  • On-Premise Configurations for Server
  • Code Share, Track Work and Shipping
  • Visual Studio Team Fundation Server
  • Azure DevOps Server - Installation
  • Criterion for Azure DevOps Server
  • SQL Server Installation for DevOps
  • Database Engine, FullText Search
  • Services and Service Account, Agent
  • SSMS Tools Installation for Access
  • Server Connections, Authentication
  • Database Creation using SSMS

Ch 6. Docker, Kubernetes, AzureDevOps

  • Introduction to Docker in Azure
  • Understanding Docker Lifecycle
  • ACI Containers and Options
  • Introduction to Kubernetes in Azure
  • Kubernetes Lifecycle Implementation
  • Azure Kubernetes Containers, Options
  • Azure DevOps : Advantages
  • Azure DevOps: Services
  • Azure Boards, Azure Repos
  • Azure Pipelies and Realtime Use
  • Azure Test Plans and Artifacts
  • VSTS Versus Azure DevOps

Ch 12: Azure Testing & Artefacts

  • Azure Testing Options in DevOps
  • Manual Testing in Kanban
  • Manual Testing in Test Manager
  • UAT and Test Tracking
  • Test Case Explorer in DevOps
  • Stakeholder Feedback
  • Azure Artifacts and Feeds
  • Single Feeds & Multi Feeds
  • Nuget, npm, Maven with DevOps
  • Versions and Compatability
  • Retention Polocies with Artifacts
  • Maven Central Upstream Sources

Ch 18: DevOps Server & Visual Tools

  • Privacy Advantages with DevOps Server
  • XML Definition Files and Options
  • Build Server Configurations
  • Content Version and Projects
  • General Administration Tasks
  • Server Level Administration Tasks
  • Adding Users to Projects
  • Grant and Restrict Permissions
  • Set Code & Test Properties
  • Area and Iteration Paths
  • Adding Teams and Scaling
  • Billing Items & Monitoring

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

24x7 Suport with Real-time Database Training. Course includes ONE Real-time Project. Register Today
 
 

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