#AI-900 Training

✅ Introduction to Artificial Intelligence & Azure AI Services
✅ Understanding Machine Learning Concepts & Models
✅ Overview of Azure Machine Learning Studio
✅ Exploring Computer Vision & Image Processing with Azure
✅ Building Intelligent Apps with Azure Cognitive Services
✅ Speech Recognition, Synthesis & Translation with Azure AI
✅ Natural Language Processing & Text Analytics
✅ Conversational AI with Azure Bot Services
✅ Responsible AI, Ethics & Fairness in AI Models
✅ Preparing for the AI-900 Certification Exam

SQL DBA Schedules

S No	Time	Free Demo	Start Date	Trainer
1	6 AM - 7 AM	Aug 6th	Aug 7th	Mr. Sai Phanindra
2	9 AM -10 AM	July 11th	July 14th	Mr. Sai Phanindra
2	6 PM - 7 PM	Aug 11th	July 23rd	Mr. Sai Phanindra
4	8 PM - 9 PM	July 22nd	July 23rd	Mr. Sai Phanindra

Azure SQL DBA Schedules

S No	Time	Start Date
1	7:00 AM - 8:30 AM	Aug 2nd (W)

Module 1: Database Concepts, SQL Server Basics

Ch 1: SQL Database Job Roles

Introduction to Databases
DBA Job Roles
Routine DBA Activities
Emergency DBA Activities
SQL DBA Job Scope, Job Growth

Ch 2: Database Intro & Installations

Database Types (OLTP, DWH, ..)
DBMS: Basics
SQL Server 2025 Installations
SSMS Tool Installation
Server Connections, Authentications
Installation Issues, Solutions

Ch 3: SQL Basics

SQL Basics (DDL, DML, .)
Creating Databases
Creating Tables, Columns
Data Inserts (SQL)
SELECT Queries

Ch 4: SQL Basics V2 (Commands, Operators)

DDL: Create, Alter, Drop, Add, modify, .
DML: Insert, Update, Delete, select into, .
DQL: Fetch, .. Select, etc..
SQL Operations: LIKE, BETWEEN, IN, .
Special Operators

Ch 5: Data Types

Integer Data Types
Character, MAX Data Types
Decimal & Money Data Types
Boolean & Binary Data Types
Date and Time Data Types
SQL_Variant Type, Variables

Ch 6: Excel Data Imports

Data Imports with Excel
SQL Native Client
Order By: Asc, Desc
Order By with WHERE
TOP & OFFSET
UNION, UNION ALL

Ch 7: Schemas & Batches

Schemas: Creation, Usage
Schemas & Table Grouping
Real-world Banking Database
2 Part, 3 Part & 4 Part Naming
Batch Concept & “Go” Command

Ch 8: Constraints, Keys & RDBMS

Null, Not Null Constraints
Unique, Primary Key Constraints
Foreign Key & References
Default, Check Constraints
DB Diagrams & ER Models
Normal Forms

Ch 9: Joins & Audits

Joins: Table Comparisons
Inner Joins & Matching Data
Outer Joins: LEFT, RIGHT
Full Outer Joins & Aliases
Cross Join & Table Combination
Joining more than 2 tables

Ch 10: Views & RLS

Views: Realtime Usage
Storing SELECT in Views
DML, SELECT with Views
RLS: Row Level Security
WITH CHECK OPTION
Important System Views

Ch 11: Stored Procedures

Stored Procedures: Realtime Use
Parameters Concept with SPs
Procedures with SELECT
System Stored Procedures
Metadata Access with SPs
SP Recompilations
Stored Procedures, Tuning

Ch 12: User Defined Functions

Using Functions in MSSQL
Scalar Functions in Real-world
Inline & Multiline Functions
Parameterized Queries
Date & Time Functions
String Functions & Queries
Aggregated Functions & Usage

Ch 13: Transactions & ACID

Transaction Concepts in OLTP
Auto Commit Transaction
Explicit Transactions
COMMIT, ROLLBACK
Checkpoint & Logging
Lock Hints & Query Blocking
READPAST, LOCKHINT

Ch 14: CTEs & Tuning

Common Table Expression
Creating and Using CTEs
CTEs, In-Memory Processing
Using CTEs for DML Operations
Using CTEs for Tuning
CTEs: Duplicate Row Deletion

Ch 15: Linked Servers

QL Server Instances
Linked Server : Creation
Linked Server : Testing
Scripting Linked Servers
Realtime Usage @ DBA
Remote DB Access
Remote Joins

Module 2: Core SQL DBA

Ch 16: Server Architecture

Database Engine Components
Parser, Compiler & Optimizer
Protocols and Query Processing
MDAC and CLR Components
Parsing and Compilation
Memory Manager & IO Managers
SQL OS Components, MDAC

Ch 17: DB Architecture (VLDB)

Planning Large Databases
Primary, Secondary Data Files
Filegroups, Spacing and Sizing
Log File: Usage and Precautions
Creating Tables with Filegroups
Pages and Extents for Storage
VLF, MiniLSN & Checkpoint

Ch 18: Backups

Database Backups & Types
DB, Filegroup, File Backups
Copy Only Backups, Usage
Partial Backups, Split Backups
Mirror Backups
Backup Verifications
Checksum, ContinueOnError

Ch 19: Restores

DB, Filegroups, File Restores
GUI Restores: Limitations
Restoring & Online States
FILELISTONLY
MOVE Options with Restores
Standby Mode Restores
Point-In-Time (PITR) Restores

Ch 20: Jobs, Maintenance

SQL Server Agent Service
Job Steps & Schedules
MSDB: Job History
Backup Maintenance
Job Verifications, Scripts
Common Errors, Solutions

Ch 21: DB Mail & Alerts

SMTP Concepts
Creating Email Profile
Default, Public Profiles
Creating SMTP Accounts
Alert System : Agent Settings
Creating Operators
Job Failures & Notifications

Ch 22: Security Management

Security Objects, Logins
Users, Roles & Principals
Schema Level Security
Object, Column Level Security
Security Audit, Logon Failures
Keys & Certificates
Encryptions & Data Security

Ch 23: DB Migrations

Creating Credentials
Creating SSIS Proxies
Creating CDW Packages
Database Detach – Attach
SMO Migration Method
DB Migration Schedules
Detect, Fix Orphan Users

Ch 24: Tuning: Audits, AM Tool

Activity Monitor Tool
Perfmon Tool & Counters
Query Audits: DMVs, DMFs
Plan Handle, Execution Time
Long Running Queries
Query Store & Buffer Cache

Ch 25: Tuning : Indexes

Indexes : Sort Locations
Clustered & Online Indexes
Non Clustered, Column Store
Included Indexes in Realtime
Filtered Indexes & Usage
Covering Index & Selectivity
Indexed Views (Materialized)

Ch 26: Tuning: Partitions

Partitions: Performance Tuning
Partition Functions & Schemes
Partition Un-partitioned Tables
Compressions: ROW, PAGE
Auditing Partitions
Partitions Limitations in OLTP
Partitions with DWH

Ch 27: Statistics & Tuning

Statistics: Realtime Usage
Index & Column Statistics
Statistics & Key Purpose
Verifying, Using Stats
Statistics Versus Indexes
Stats Updates on Tables
Stats Updates on Views

Ch 28: Index Management

Index Management Options
Index Rebuilds, Re-Organize
Database Maintenance Plans
Page Count and Index Conditions
Degree Of Parallelism Settings
Resumable & Online Indexes
PAUSE, RESUME in Rebuilds

Ch 29: Tuning Tools

Tuning Tools: Workload Files
Profiler Tuning, Events
DTA, Profiler Options
Physical Design Structures
PDS Recommendations
Query Execution Cache
Tuning Tools: Precautions

Ch 30: Execution Plans

Execution Plan Analysis
IO Cost and CPU Cost
SubTree & Operator Cost
NUMA Nodes, Processor Affinity
Thread Count, DOP
Table & Index Scan, Index Seek
Index Selectivity & Tuning

Ch 31: Lock Management

Open Transactions in Realtime
Open Transaction, Blocking
LOCKS: Types & Audits
S, X, IX, U and MD Locks
Sch-M and Sch-S Locks
SP_WHO2, SP_LOCK
sysprocesses & Lock Waits

Ch 32: Isolation Levels

Lock Hints and Isolation Levels
Read Committed, Uncommitted
Serializable, Repeatable Read
Snapshot Isolation, Versioning
Read Committed Snapshot
sysprocesses & sp_who2
Choosing Correct Isolation Level

Ch 33: Deadlocks, LIVE Locks

Deadlocks in Real-world
Profiler Tool & Deadlocks
Lock Management: Deadlocks
Deadlock Graphs & Events
Deadlock Avoidance, Prevention
Deadlock Prevention
sysprocesses & sp_who2

Ch 34: Recovery Models

Recovery Models
Database Properties
Full Recovery Model
Simple & Bulk Logged
Realtime Uses
Backups Versus Recovery Models

Ch 35: HA DR @ Replication – 1

Replication : Realtime Usage
Distributor Configurations
Publisher and Subscriber
Replication Types: Snapshot
Transactional Replication
Log Reader Agent & Usage
Replication Monitor, Alerts

Ch 36: HA DR @ Replication – 2

Merge Replication & Usage
Peer – Peer Replication
Push & Pull Subscriptions
Conflict Detection, Avoidance
Scripting Replication Agents
Limitations with Replication
Common Errors, Solutions

Ch 37: HA DR @ Log Shipping

Log Shipping Configurations
Primary, Secondary Servers
Working with Network Shares
Jobs: Backup, Copy, Restore
NORECOVERY, STANDBY
Manual Failover Process
Common Errors, Solutions

Ch 38: HA DR @ DB Mirroring

Database Mirroring Concepts
Configuring Principal, Mirror
Configure Witness, EndPoint
Synchronous, Asynchronous
Automated Failover Process
Manual Failover, Monitoring
Common Errors, Solutions

Ch 39: DB Health Checks, Repairs

DBCC Commands in Realtime
DBCC for Audits, Repairs
MSDB Suspect Pages
User Database Repairs
Single User Mode
Emergency Mode
Recovery & Restoring Modes

Ch 40: Issues & Solutions

Log Space Issues, Solutions
TempDB Issues, Solutions
Memory Issues, Solutions
Health Check Strategies
Healthy Backups
Maintenance Plans
Database States

Ch 41: Updates (Patches)

Planning for Updates
Pre-Maintenance Checklist
Edition Checks
Updates Process
Edition Comparisons
History Tracking
Updates Rollback

Ch 42: Upgrades, Licensing

Planning for Upgrades
Pre-Maintenance Checklist
Upgrades Process (In-Place)
Cautions & Maintenance
Version Comparisons
History Tracking
Upgrades Rollbacks

Ch 43: System DB Rebuilds, DAC

Command Line Installations
System DB Rebuilds
Server Down Issues
Service Startup Issues
DAC: Dedicated Admin Console
Login Failure Issues
SQL CMD : Secondary Logins

Ch 44: SQL DBA Project

Routine DBA Activities
Emergency DBA Activities
Maintenance DBA Activities
SLA – OLA Process
Ticketing Tools
3^rd Party Tools
Common Errors & Solutions

Ch 45: SQL DBA Project

Login Failure Errors
Slow Database Issues
Network Errors
Security Strategies
HA DR Strategies
Common Error Codes
Need for Azure Cloud

Module 3: Azure SQL DBA

Ch 46: Cloud Basics, Azure Funda

Cloud Fundamentals
Cloud Concepts, Benefits
IaaS, PaaS, SaaS Cloud Types
Azure Cloud Concepts
Azure Resources & Usage
Azure Services & Purpose
Azure Account & Subscription

Ch 47: Azure SQL Deployments

Azure SQL Services
Azure SQL Server Creation
Azure SQL Databases
Azure Firewall : Rules
Test Connections from SSMS
SSMS Tool : Test Connections
ADS Tool : Installation, use

Ch 48: Azure SQL DB Licensing

Azure SQL DB Licensing
Per Database Licensing
DTUs: Basic, Standard Types
VPU and Plan Types
DTU Versus VPU Licensing
Elastic DTUs (eDTU) Usage
Elastic Query Processing

Ch 49: Azure SQL DB Migrations

SQL DB Migration Options
Data Migration Assistant: DMA
DMA Tool, Migration Options
On-Premises DB Export
Azure SQL Database Import
Azure Storage Account
Linking SSMS with Azure

Ch 50: Azure SQL DB Metrics

Azure SQL DB Metrics
CPU, Memory, Log Metrics
Data File Metrics, Alerts
Action Groups & Emails
Query Performance Insight
Automated Tuning Options
Query Recommendations

Ch 51: Azure SQL DB Tuning, AI

Server Level Tuning
Database Level Tuning
Built-In Intelligence
AI Search Service, Tuning
AI Indexes, Practical Use
Watermark Columns

Ch 52: Azure Backups, Restores

Azure SQL DB Backups
Backup Retention Options
LTR Backups, Log Backups
Automated Backups
LTR, PITR Restores
Backup Versus Export
Restore Versus Import

Ch 53: HA DR @ Replication

Azure HA DR Mechanisms
Geo Replication
Primary & Secondary
Manual Failover
Automated Failover
DMVs For Replication
Testing Read Only Databases

Ch 54: HA DR @ Server Failover

Multi Database Replication
Configure Server HADR
Adding Replica Databases
Replica DB: Capacity
Replica DB: Status
Automated Failover
Manual Failover

Ch 55: Azure Security

Logins & Users in Azure
Grant, With Grant
Dynamic RLS
Dynamic Data Masking
Creating AD Users & IAM
Implementing RBAC
MFA Authentication

Ch 56: Azure Virtual Machine

Azure IaaS Implementation
Configure Disk, Network
Configure SQL Security
CPU, Processor & IO
IP & RDP Connections
Testing SSMS Connections
Migrating SQL 2025 to VM

Ch 57: Azure VM Clusters

Azure Active Directory
Azure AD DS Services
Azure Networking Options
Availability Groups, Usage
Listeners and Realtime Use
FSW: File Share Witness

Ch 58: SQL Clusters, Always-On

Creating SQL Clusters
Testing SQL Clusters
Configure Always-On
Testing, Using Always-On
AOAG Implementation
AOAG Monitoring
Comparing Paas & IaaS

Ch 59: PowerShell

Azure PowerShell
Az and get Commands
Creating Resources
Lists & Validations
Password Resets
Firewall Config
Resource Cleanups

Ch 60: Azure Managed Instance

Azure MI Implementation
Network Entities for MI
Capacity Entities
Cloud Azure MI Access
Azure MI Implementation
Azure MI Migrations

Module 4: DP 300, Resume

👉🏻 Realtime Project For your Resume: End to End Project

👉🏻 CoPilot Integrations For DB Administration

👉🏻 Resume Guidance (1:1)

👉🏻 Mock Interview, DP 300 Exam Guidance

All sessions are practical, step by step. Kindly ensure on-time practice for best results.

Brochure Download Request a Callback

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL Server, T-SQL, SQL Server DBA and MSBI (SSIS, SSAS, SSRS) Courses. All our training services are completely practical and real-time. CREDITS of SQL School Training Center

We are Microsoft Partner. ID# 4338151
ISO Certified Training Center
Completely dedicated to Microsoft SQL Server
All trainings delivered by our Certified Trainers only
One of the few institutes consistently delivering the trainings for more than 20+ Years online as inhouse
Real-time projects in
- Healthcare
- Banking
- Insurance
- Retail Sales
- Telecom
- ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

Will you provide the Software required for the Training and Practice?

Yes, during the free demo session itself.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last 20+ years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even after the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

Why Choose SQL School

100% Real-Time and Practical
ISO 9001:2008 Certified
Weekly Mock Interviews
24/7 LIVE Server Access
Realtime Project FAQs
Course Completion Certificate
Placement Assistance
Job Support