AZURE SQL DATABASE  SYLLABUS

AZURE CLOUD INTRO, CONFIGURATION

Introduction to Cloud. Need for Cloud, Advantages
Cloud Architecture Basics – IaaS, PasS and SaaS
Advantages of Microsoft Cloud – Azure Platform
Azure Products and Azure Services – MarketPlace
SQL Database Implementations in Azure Platform
Logical Servers, Virtual Machines, Managed Instance
Installing SSMS and Azure Data Studio (ADS) Tools
Creating Azure Account and Free Subscriptions
Creating Azure SQL Server (Logical Server)
Firewall Settings for Azure SQL Server (Logical Server)
Adding Firewall Rules – IP for Remote Access
Server Properties and Status Check. Server Name Format
Password Resets and Azure SQL Server Name Format
Creating Azure SQL Databases and Pricing Tiers
Azure SQL Database Access from SSMS Tool

DTU, ELASTIC QUERIES, MIGRATIONS

Azure Storage : Types, Creation & Containers
LRS, GRS and RA-GRS Azure Storage Accounts
Storage Containers, Storage Explorer Tool Usage
Data Migration and Database Migration in Azure
Data Migration Assistant (DMA) Tool, Assessment
Data / Database Migrations To Azure SQL
Database Exports and Imports in Azure with bacpac
Migration Scopes : Schema, Data, Schema & Data
Schema Generation and Compatibility For Migration
Data Migration Verification and Row Counts
DTU : Data Transaction Unit, Resource Allocations
Basic, Standard and Premium Plans For SQL DB
vCore Based Purchasing : Gen 4 and Gen 5 Types
General Purpose and Business Critical Plans
Compute Tier : Provisioned and Serverless
Bounding Box Model, Elastic Pools & Queries
eDTUs and Elastic Pool, per Database Settings
Elastic Scaling with Azure SQL Databases

AZURE SQL DATABASE TUNING

Azure SQL Server Level Tuning Options
Azure SQL Database Level Tuning Options
Automated Tuning Options and Peak-Loads
Force Plan, Create Index and Drop Index
Query Performance Insight, Recommendations
IO Metrics, CPU Metrics & Query Statistics
Data File IO, Log File IO, Custom Reports
Query Audits with Query IDs, Dashboards
DTU Usage Reports and Elastic Queries
Query Level Recommendations and Query Costs
Azure Search Service Configuration, Pricing Tiers
Azure Search for Data Import and Indexer Options
Suggester and Analyzer Index Modes for Tuning
Retrievable, Facetable, Filterable Indexes
Facetable and Searchable Indexes for Tuning
Change Tracking Options, Watermark Columns
Full Text Search : Performance Advantages

XEL GRAPHS, STRETCH DATABASES

SQL Traces : Creation and Audits. Limitations
SQL Traces : Event Class, Category, Filter, Conditions
Extended Events Package, Target, Action, Session
TSQL and SP Debug Events with Global Fields
XE Objects : Catalog & Dynamic Management Views
XE Profiler – Templates for Event Profiling (Audits)
Comparing XE Profiler with SQL Profiler Tool
Comparing Azure SQL Database with On-Premise
Stretch Databases in Azure SQL Databases
Stretch Databases – Tuning Benefits, Cautions
Table Level Migrations with Azure SQL Databases
Compute Performance Levels and DSU Pricing
Data Storage and Azure Database Snapshots
Geo Backup Of Tables and Hybrid Cloud Settings
Remote Data Archive Configuration in Azure
Database Master Key [DMK], Cold Data Migration
Real-time Advantages of Stretch Databases

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 (bacpac)
Backups – Retentions, Audits. LTR Policy
Restore Points and Azure SQL Database Recovery
Geo-Redundant Backups and Advantages in Azure
Restore Options and DB Creations with LTR
Azure Storage Explorer Tool using Backups
Disaster Recovery (DR) Advantages in Azure

AZURE SQL DBA

HA – DR LEVEL 1

Failover Groups and Active Geo-Replication
Read-Write Failover Policy, Automated Failover
Geo Replication Configurations – Azure Locations
Primary-Secondary and Read / Write Modes
GeoReplication : Monitoring and Forced Failover
Azure Server Failover Process, Strategies
Automated Failover , Manual & Forced Failover
Backup Errors, Geo Replication Errors – Solutions
SQL Data Sync Service and Sync Groups
HUB, MEMBER and SYNC DATABASE
Sync Direction, Sync Schema and Sync Interval
bi-directional Load Balancing and Failover
Conflict Resolution Policy with HUB and MEMBER
Cloud to Cloud / On-Premise Synchronization
Hub to Member and Member to Hub Sync Policies

HA – DR LEVEL 2

Azure AlwaysOn with SQL Server Clusters
Primary Node and Secondary Node Clusters
SQL Server Virtual Machines and Settings
Domain Controller (DC) Virtual Machines
Witness File Share (WFS) Settings in DC
Azure Server Failover Process, Strategies
Adding Databases to Failover Group
Always On Health Check Reports (AOAG)
Configuring and Using Azure Always-On
Load Balancing with Azure Always-On
Azure Cloud Shell – PowerShellGet, Versions
Power Shell Scripts for Configurations
Power Shell Scripts for Job Schedules
Power Shell Scripts for Firewall, ARM
Azure CLI – Purpose, Real-time Use
Command Line Interface for Automations
Azure telemetry Commands and Usage
Help, Show, Create and Firewall Commands

SECURITY MANAGEMENT, RLS

Firewall and Virtual Network Configurations
Server-level Firewall & Database Firewall Rules
System Stored Procedures for Firewall Settings
Logins, Users, Roles and Permissions using T-SQL
Creating Logins without Logins. Containment Users
GRANT, DENY, REVOKE, WITH GRANT Permissions
Role Level and Schema Level Security in Azure
Threat Detection, Transparent Database Encryption
Vulnerability Assessment, Dynamic Data Masking
Implementing RLS – Row Level Security
Creating Users with and without Logins
Using SECURITY Schema for RLS Functions
Creating Security Predicates and Filters
Security Policies for Row Level Security
EXECUTE AS options for RLS. STATE ON/OFF
Dynamic Data Masking with Azure SQL Database
Implementing DDM with Azure Portal & T-SQL

AZURE VIRTUAL MACHINE – WINDOWS

IaaS, Azure VM. Install Azure Virtual Machines
Install/Configure Windows Server, Redhat, Ubuntu
SQL Server Azure VM – Config Settings, Elastic Pools
Resource Groups, Resource Pools and eDTUs
Verify SQL Instances in Azure VM. sysadmin Account
Azure Storage Blades and Pricing Options
Azure VM – Settings, DB Creation in Azure VM
On-Premise & Azure Virtual Machines: Similarities
SSMS, SQL Server Instance, Agent in Azure VM
Azure Virtual Machines ; Security Options
Azure SQL Database in VM to SQL Cloud
Azure SQL Database in VM to on-Prem
Deployment Automation Process, Automation Scripts
SQL Database in AWS and Google Cloud
Azure Virtual Machine Configuration Settings
Azure SQL Database Advantages in Virtual Machines
Public Access with SQL Server Instance, Security

LINUX VM, MANAGED INSTANCES

SQL Server on LINUX – RHEL (Red Hat Linux)
Advantages of LINUX RHEL Over Windows
LINUX RHEL Security Management, Firewall
Storage, vCores and Storage Options in VM
RHEL Clusters for SQL Server on LINUX
Failover Mode and Node Majority – TCP
Deployment Models and Azure Resource Manager
RHEL Cluster Resource Manager Settings
Pacemaker and SQL Server Nodes in AG
SQL Database Managed Instance – TDE
Native Virtual Networks and Scalability
Lift – Shift LOB Applications, PaaS Infrastructure
Frictionless Migration for On-Premise
vCore Purchasing Model for Azure SQL DB
Gen 4 and Gen 5 Logical CPUs, Resource Limits
Managed Instances Vs AWS & Google Cloud
Cell Level Encryption and Always-Encrypted