Course Includes

1. Azure SQL DB Architecture
2. Migrations
3. HA – DR
4. Security
5. LINUX
6. PowerShell
7. Virtual Machines

Learning Outcome

• Suitability for relational databases
• Configuration for Azure SQL database
• Introduction to Azure Virtual Machines (VM) and Stretch Databases
• How to use Azure Cloud Shell
• Azure Power Shell
• Azure HA-DR
• Security Management

Modules

Module 1: AZURE CLOUD INTRODUCTION

1. Introduction to Cloud & Advantages
2. Cloud Architecture: IaaS, PasS, and SaaS
3. Microsoft Cloud Advantages, Azure Platform
4. Azure Products and Services – MarketPlace
5. Database Implementations in Azure Platform
6. Comparing PaaS and IaaS Implementations; Paas
   Implementations For SQL Server
7. IaaS Implementations For SQL Server; Logical, Virtual Machine, Managed Instance
8. Installing SSMS and Azure Data Studio; Azure Account and Free Subscription
9. Azure Resources: Resource Groups Usage
10. Azure Active Directory: User & Groups
11. Azure Active Directory Authentication

Module 2: AZURE SQL SERVER CONFIGURATION

1. Installing SSMS and Azure Data Studio
2. Azure Account and Free Subscriptions
3. Azure SQL Server (Logical Server)
4. Azure SQL Server Logical Server Firewall
5. Firewall Rules – IP for Remote Access
6. Server Properties and Status Format
7. Password Resets in Azure SQL Server
8. Azure SQL Databases & Pricing Tiers
9. Azure SQL Database Access from SSMS
10. Elastic Scaling with Azure Databases
11. General Purpose and Business Critical
12. Basic, Standard and Premium Plans: Gen 4, Gen 5

Module 3: DATABASE MIGRATIONS, DTU, ELASTIC QUERIES

1. Data Migration and Database Migration in Azure
2. Azure Storage: Creation & Containers LRS,GRS, and RA-GRS Azure Storage Accounts
3. Storage Containers, Storage Explorer Tool
4. Data Migration Assistant (DMA), Assessment
5. Migrations To Azure SQL; DB Exports & Imports with bacpac
6. Schema Generation & Compatibility
7. DTU: Data Transaction Unit, Resource Allocations
8. Basic, Standard & Premium Plans For SQL DB
9. vCore Based Purchasing: Gen 4 and Gen 5 Types
10. General Purpose & Business Critical Plans
11. Compute Tier: Provisioned and Serverless
12. Bounding Box Model, Elastic Pools & Queries
13. eDTUs and Elastic Pool, per DB Settings
14. Elastic Scaling with Azure SQL Databases

Module 4: AZURE SQL DATABASE TUNING

1. Azure SQL Server Level Tuning Options
2. Azure SQL Database Level Tuning Options
3. Automated Tuning Options and Peak-Loads
4. Force Plan, Create Index and Drop Index
5. Query Performance Insight, Recommendations
6. IO Metrics, CPU Metrics & Query Statistics
7. Data File IO, Log File IO, Custom Reports
8. Query Level Recommendations
9. Azure Search Service
10. Azure Search
11. Suggester and Analyzer Index Modes for Tuning
12. Retrievable, Filterable Indexes
13. Facetable and Searchable Indexes for Tuning
14. Change Tracking Options, Watermark Columns

Module 5: XEL GRAPHS, STRETCH DATABASES

1. SQL Traces Creation
2. SQL Traces: Event Class, Category, Filter, Conditions
3. Extended Events Package, Target, Action, Session
4. TSQL and SP Debug Events with Global Fields
5. XE Objects: Catalog & Dynamic Management Views
6. XE Profiler – Templates for Event Profiling
7. Comparing XE Profiler with SQL Profiler Tool
8. Stretch Databases in Azure SQL Databases
9. Stretch Databases
10. Table Level Migrations
11. Performance Levels and DSU Pricing
12. Data Storage and Snapshots
13. Geo Backup Of Tables and Hybrid Cloud Settings
14. Remote Data Archive Configuration in Azure
15. Database Master Key [DMK], Cold Data Migration
16. Real-time Advantages of Stretch Databases

Module 6: ALERTS, AZURE BACKUPS & RESTORES

1. Azure SQL Server Activity Log and Options
2. Events, Operations, and Event Categories
3. Quick Insights from Events and Filters
4. Events Exports to Event Hub, Log Analytics
5. Log Analytics Workspace, Alert Rules
6. Email / SMS Notifications and Schedules
7. Log Analytics Settings and Azure Storage
8. Activity Logs and Audit Reports, Insights
9. Automated Backups; Long Term & Automated Backup Retentions (bacpac)
10. Backups – Retentions, Audits. LTR Policy
11. Restore Points, Database Recovery
12. Geo-Redundant Backups in Azure
13. Azure Storage Explorer For Backups
14. Disaster Recovery (DR) Advantages in Azure

Module 7: HA – DR: Geo-Replication, DB Sync

1. Failover Groups and Active Geo-Replication
2. Read-Write Failover Policy, Automated Failover
3. Geo-Replication Configurations – Azure Locations
4. Primary-Secondary and Read / Write Modes
5. Geo-Replication: Monitoring and Forced Failover
6. Azure Server Failover Process, Strategies
7. Automated SQL Data Sync Service and Sync Groups
8. HUB, MEMBER and SYNC DATABASE
9. Sync Direction, Sync Schema and Sync Interval
10. bi-directional Load Balancing and Failover
11. Conflict Resolution Policy

Module 8: SECURITY MANAGEMENT, RLS

1. Firewall and Virtual Network Configurations
2. Server-level Firewall & Database Firewall Rules
3. System Stored Procedures for Firewall Settings
4. Logins, Users, Roles and Permissions using T-SQL
5. Creating Logins without Logins. Containment Users
6. GRANT, DENY, REVOKE, WITH GRANT Permissions
7. Threat Detection, Transparent Database Encryption
8. Vulnerability Assessment, Dynamic Data Masking
9. Implementing RLS – Row-Level Security
10. Creating Users with & without Logins
11. Using SECURITY Schema for RLS Functions
12. Creating Security Predicates and Filters
13. Security Policies for Row Level Security
14. EXECUTE AS options for RLS. STATE ON/OFF

Module 9: POWERSHELL, AZURE VMs

1. Azure Virtual Machines: Deploy, Configure
2. Configure Windows Server, Redhat Linux
3. Azure Storage Blades and Pricing Options
4. Azure VM – Settings, Access & DB Creation
5. On-Premise & Azure VMs: Similarities
6. SQL Server Instance, Agent in Azure VM
7. Azure SQL Database in VM to SQL Cloud
8. Azure SQL Database in VM to OnPrem
9. Deployment Automation Scripts in Azure
10. Azure Cloud Shell – PowerShellGet
11. Power Shell Scripts for Configurations
12. Power Shell Scripts for Job Schedules
13. Power Shell Scripts for Firewall, ARM
14. Azure CLI – Purpose, Real- time Use

Module 10: Windows Clusters with Azure VM

1. Windows Clusters For HA and DR
2. Virtual Networks, Subnets, and IPs
3. Availability Sets and Availability Zones
4. Fault Domains and Update Domains
5. DC Deployment & Configurations
6. Active Directory Domain Services
7. SAN [Storage Area Network] and LUN
8. DNS Server, DSRM and Private IP
9. Windows Level Clusters, MSCS Service
10. Active-Active, Active-Passive Clusters
11. DNS, AA Hosts
12. SQL Clustering & RAID Levels
13. SQL Cluster Groups, Domain Accounts
14. Quorum and MSDTC Disks. LUN Grows

Module 11: Always-On with SQL Server Clusters

1. SQL Server VMs and File Share Witness (FSW)
2. Joining Machines to Domain Network (AD)
3. Adding Install Accounts to Active Directory
4. Install Failover Cluster (FCI) Features
5. Firewall Configurations and Port Exceptions
6. FSW File Shares and Usability Options
7. Need for Always – On Availability (AAG)
8. Always On Availability Group [AOAG]
9. Multi-Database Replication Options
10. Backup Preferences, Location Options
11. Synchronous and Asynchronous Modes
12. Synchronization, Automated Seeding
13. Data Synchronization for AOAG
14. AOAG Dashboards & Automated Failover
15. Failover Connection Tests

Module 12: MCSA 70-765 certification guidance, Materials, and Sample Questions