SQL DBA Video Training (On-demand, 24 x 7)

This SQL DBA Video Training from Real-time, Certified Trainers includes Basic to Advanced Database Administration activities : Capacity Planning, Query Tuning, Index Management, DB Maintenance, High Availability (HA), Disaster Recovery (DR), Query Store, In-Memory Tables, Database Repairs, Page Repairs, Jobs, Alerts, Resource Management, Security Management, Upgrades. Additionally includes Azure SQL DBA Activities including Azure Active Directory, Azure SQL DB Migrations, Azure SQL DB Tuning, XEL, Azure DB Sync, Server Failover, Geo Replication, Azure Virtual Machines and Azure HA-DR.

This SQL DBA Video Training also includes practical implementation of Always-On Availability Groups [AOAG] in Windows Clusters, LINUX Clusters and Real-time Azure SQL DBA activities. Additionally, this SQL DBA Training Course includes complete guidance for your Job Profile, Study Material, MCSA SQL DBA Certification (DP 300) and Real-time Projects for your Resume. Versions: SQL Server 2016, 2017 and 2019. Download SQL DBA Curriculum Here

SQL DBA (with Server, T-SQL, Azure SQL DBA)

	PLAN A	PLAN B	PLAN C
SQL DBA Job Profile	Core DBA	Core DBA + Azure DBA	Core DBA + Azure DBA + Azure DevOps
No of Videos	Videos 1 to 27	Videos 1 to 39	Videos 1 to 57
Completely Practical, Real-time	✔	✔	✔
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 SQL Database Migration	✖	✔	✔
Azure SQL DB Security, HA-DR	✖	✔	✔
Azure Always-On, PowerShell	✖	✔	✔
Azure Virtual Machines (VM)	✖	✔	✔
DP 300 Exam : Guidance	✖	✔	✔
70-764, 70-765 Exams : Guidance	✖	✔	✔
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 18,000 USD 244	INR 27,000 USD 365	INR 39,000 USD 527

Trainer : Mr. Sai Phanindra T

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 SQL DBA Online Training Course Register

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

Course Curriculum

Register Today

Course 1: SQL DBA Training Content [For Plans A, B, C]

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

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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Course 2: Azure DBA Training Content [For Plans B, C]

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 39: Project Work, DP 300 Exam

Real-time Project

DP 300 Certification Guidance

Course 3: Azure DevOps Training Content [For Plans C]

Module I: Azure Funda & DevOps Basics	Module II: Azure DevOps Service - 1	Azure DevOps Service - 2 Az DevOps Server
Video 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	Video 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	Video 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
Video 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	Video 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	Video 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
Video 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	Video 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	Video 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
Video 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	Video 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	Video 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
Video 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	Video 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	Video 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
Video 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	Video 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	Video 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

Module I: Azure Funda & DevOps Basics

Module II: Azure DevOps Service - 1

Azure DevOps Service - 2
Az DevOps Server

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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

Video 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 Dec 2nd, 2020

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

All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and Mock Tests.

Trainer Profile

Reviews