Azure SQL Database Video Training

Azure SQL Database is a cloud-based, elegant technology for creating and using databases in Microsoft Cloud. Easy UI and Faster, reliable deliverables with SQL Server Cloud. We at SQL School offer complete real-time and practical on SQL Azure Trainings.

AZURE SQL Database Video Training - How it works?


Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance. 

 

Pre-requisites: Participant should have knowledge on SQL Server T-SQL &/ Admin Concepts to attend this Azure SQL Database Dev / DBA Course.

Arrange Callback from the Trainer

Trainer : Mr. Sai Phanindra T (12+ Yrs Exp)


Course Fee : INR 9000/- (USD 150). Payable in TWO installments

COURSE HIGHLIGHTS
Azure SQL Development Azure SQL DB Admin
Performance Insights, Tuning DB Migrations, Deployments
Azure SQL DB Security Geo Replication, DB Sync
DR Drills, Threat Detections HD Insight, Azure DataLake

Azure SQL Database Training Course Contents:

Module I: AZURE SQL DATABASE (Dev)

Module II: AZURE SQL Admin (DBA)

Video 1: AZURE CLOUD INTRO

  • Introduction to Cloud. Need for Cloud, Advantages
  • Cloud Architecture Basics - Iaas, PasS and SaaS
  • Operational Advantages of Cloud, Cloud Providers
  • Advantages of Microsoft Cloud - Azure Platform
  • Service Models, Private and Public Clouds
  • SQL Databases in Microsoft Azure and Advantages
  • Azure SQL & Databases - Need, Importance
  • Azure Sources - Types, Microsoft Market Place
  • Azure SQL Database, Azure SQL Data Warehouse
  • Azure Analysis Services, BLOB and TABLE Storage
  • Virtual Machines and Apps, Programs in Azure
  • Azure Cloud Architecture for OMS, Shell, Vaults
  • Advantages of Azure SQL Databases & Tools
  • Comparing Azure with AWS and Google Cloud
  • Microsoft Azure Price Tiers & Subscription
  • Course Plan and Examples. Cloud Account Config.

Video 7: AUTOMATED DB RECOVERY, GEO REPLICATION

  • Automated Backups in Azure SQL Database
  • Cloud Shell Storage and Creating Containers
  • Blob Data and File Data Uploads into Azure Storage
  • Long Term Backup Retentions. Backup cost, Frequency
  • Recovery Service Vaults, Policies with RA-GRS
  • Automated Backups - Retentions, Audits. LTR Policy
  • Restore Points and Azure SQL Database Recovery
  • Failover Groups and Active Geo-Replication
  • Read-Write Failover Policy, Automated Failover
  • Geo Replication Configurations - Azure Locations
  • Primary-Secondary and Read / Write Modes
  • Upgrading / Downgrading Primary Database
  • Perform Disaster Recovery (DR) Drills
  • Performance Dashboard and Database Level Failover
  • Power Shell For Geo Replication and Failback Options
  • Backup Errors, Geo Replication Errors - Solutions

Video 2: AZURE CLOUD CONFIGURATIONS

  • Azure Cloud Subscription, Azure Portal Options
  • Azure Resources, Marketplace and Dashboards
  • Azure SQL Database Architecture Components - in detail
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • Isolated Price Trier - Advantages, Performance
  • Creating SQL Servers in Azure and in Virtual Machines
  • Elastic Pools and Configuration Options - Advantages
  • DTU : Data Transaction Units : Architecture, Pools
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Azure Services, Resource Groups and Pricing
  • Azure SQL Databases : Technical Features, Benefits
  • Built-In Intelligence and Scalability, Tools For Usage
  • Advanced Security Compliance, ARM and ASM Topologies
  • Need for OSM Workspace - Operations Management Suite

Video 8: DATABASE SYNCHRONIZATION

  • SYNCHRONIZATION with Azure SQL Databases
  • SQL Data Sync Service and Sync Groups
  • bi-directional data transfer with Azure SQL DBs
  • Sync Schema, Sync Direction and Sync Interval
  • Conflict Resolution Policy with HUB and MEMBER
  • Metadata Database and Synchronization Topologies
  • Real-time Advantages of Azure DB Synchronization
  • LOAD BALANCING & Automated FAILOVER with DB Sync
  • Cloud to Cloud and Cloud to On-Premise Synchronization
  • HA - DR with Geo Replication & Database Synchronization
  • Azure Database Integration. Elastic Query Plans
  • Requirements &a,p; Limitations with Database Synchronization
  • Azure Dashboards and Report Pins. Server Health Reports
  • SQL Server Stretch Databases and Purpose
  • Configuring, Using, Monitoring Stretch Databases in Azure

Video 3: AZURE SQL DATABASE CONFIGURATION

  • Creating Azure SQL Server Instances
  • Creating Azure SQL Databases, Price Tiers
  • SQL Database – Cloud Database as a Service
  • Subscription Options and Database Sources
  • Elastic Pools & Tier Selection - Recommendations
  • Database Name Identifiers, Naming rules & restrictions
  • Server Names - Locations, Admin Users, Passwords
  • Firewall Rules, IP Configuration Ranges
  • Azure Dashboard - Metrics, Notification Options
  • Azure SQL Database Collation, Connection Options, Tools
  • SQL Server Management Studio (SSMS) & Visual Studio
  • SQL Server Data Explorer Tool in Azure Cloud
  • .NET, PHP, Node.js, Java, Ruby, Python Connections
  • Creating Azure SQL Databases in SSMS Tool
  • T-SQL Scripts for Azure SQL Database

Video 9: SERVER FAILOVER AND OMS

  • Azure SQL Server Level Failover and Recovery
  • Auto Failover Settings and Geo Configuration
  • Auto-Failover Group Capabilities
  • Active Geo Replication and Always-On
  • Read Committed Snapshot Isolation (RCSI)
  • Best practices of building highly available service
  • Upgrading or downgrading a primary database
  • Preventing the loss of critical data
  • Manage SQL database failover using Transact-SQL
  • Manage SQL database failover using PowerShell
  • Manage SQL database failover using the REST API
  • DB Migration, Application Upgrades with Azure SQL DB
  • Configuring OMS (Operations Management Suite)
  • Log Analytics and Azure Service Auditting
  • Azure SQL Server and Database Properties

Video 4: PERFORMANCE TUNING in AZURE SQL DB

  • Manage database workload in SQL Server
  • Scaling Options - Horizontal and Vertical
  • Sharding Technique for Performance Tuning
  • SaaS approach with single / multi user tenants
  • Shard Maps & Shardlets: List Mapping, Range Mapping
  • Shard Map Manager and Data Dependent Routing
  • Query Routing and Shard Querying. Elastic Tools
  • Using DMVs and DMFs in Azure Databases
  • Monitor Azure SQL Database Query Plans
  • Split-Merge Tool and Split Merge Service
  • Performance Monitoring Counters For Azure SQL DB
  • CPU, DTU Limits. Data IO and Size Factors
  • In-Memory OLTP Tables and Performance Impact
  • Active Recommendations, Tuning History
  • FORCE PLAN, CREATE, DROP INDEX. ON, OFF INHERITS
  • Azure Search Service and Indexer Operations
  • Indexing Types and Real-time Usage. Indexing Schedules
  • Automated Tuning Options in Azure Database Cloud

Video 10: AUDITS and THREAT DETECTION

  • Activity Logs and OMS Server Configuration
  • OMS Workspace and Log Analytics. Operational Logs
  • Instance Audits and Threat Detection Process
  • Audit Storage Configuration, Service Tiers with Azure
  • LRS, GRS, and "RA - GRS" Storage Modes in Azure
  • Azure Resource Manager (ARM) Scripts with Power Shell
  • Threat Detection Types : SQL Injection & Vulnerability
  • Audit Types: Server Audits and Database Audits
  • Events, Principals, Types and Action Parameters
  • DMVs and DMFs for Audits (T-SQL). Power Shell Scripts
  • Merging and Reading Audit Files. Analyzing Audit Reports
  • Vulnerability Assessment (VA) Reports, Notifications
  • Security Risk Reports and Summaries : HIGH/MEDIUM/LOW
  • Azure SQL Database Recovery from Availability Groups
  • Azure SQL Database Recovery from Deleted Databases
  • Manage SQL database auditing using Azure Power Shell
  • Manage SQL database auditing using REST API

Video 5: AZURE SQL DATABASE MIGRATIONS

  • Database Scripting Wizard in SSMS
  • Scripting On-Premise Databases in T-SQL
  • Data Migration Assistant (DMA) Tool
  • Schema Generation and Compatability Issues
  • Generating Data Scripts, Assessment, Schema Options
  • Prepare and Deploy Fixes. Database Snapshots
  • Resolving Database Migration Compatibility Issues
  • Partially Supported and Unsupported Functions
  • non SQL Server Database Migrations : MS Access, Oracle
  • SQL Server Migration Assistant (SSMA) Tool
  • Import from a BACPAC file using Azure portal
  • Import from a BACPAC file using SQLPackage
  • Import from a BACPAC file using PowerShell
  • Data Discovery and Classification Options. Locks

Video 11: SECURITY MANAGEMENT - AZURE SQL DB

  • SQL Server Firewall & SQL Database Firewall with T-SQL
  • Authorization and Authentication Techniques
  • Owner, Contributor and Reader Roles in Azure SQL Server
  • Logins, Users, Roles and Permissions using T-SQL
  • GRANT, DENY, REVOKE and WITH GRANT using T-SQL
  • SQL Database Auditing and SQL Database Threat Detection
  • Transparent Database Encryptions (TDE) & Security
  • Service Keys and TDE for Security, AD Authentication
  • Row Level Security (RLS) and Security Roles
  • User Functions and Security Policies for RLS
  • Azure IAM Controls, Manage SMB File Shares in Azure
  • Dynamic Data Masking (DDM) and Encryption Functions
  • T-SQL Scripts & Portal to Implement Data Mask Functions
  • Data Discovery and Classification Feature - Real-time Use

Video 6: POWERSHELL WITH AZURE SQL DATABASE (Dev)

  • PowerShell - Purpose, Vocabulary and Configuration
  • Azure Power Shell - Install and Configure
  • Installing and Scripting with Power Shell
  • cmdlets and Azure Resource Manager (ARM)
  • PowerShellGet and Version Paths
  • Cloud Shell to run the Azure Power Shell
  • Linux (BASH) Commands @ Power Shell
  • Powershell Operations for Azure RM & PSSQL
  • Powershell Operations for Azure SQL Database
  • Azure SQL Database Tables, Views in Excel
  • Excel Pivot Tables and Chart Reports with Azure SQL DB
  • Connection Drivers in Azure Cloud - Options
  • Azure SQL Database Query Batching - Advantages

Video 12: AZURE CLI & POWERSHELL WITH SQL DATABASE

  • PowerShell for Disaster Recovery and DB Management
  • PowerShell for Schedules & Routine Maintenance Tasks
  • Windows Virtual Machines with PowerShell
  • Important ARM Commands for DB Admins in PowerShell
  • Plan for IaaS, Azure VM. Install Azure Virtual Machines
  • Azure SQL Database in VM to SQL Cloud
  • Power Shell Scripts to Implement DDM - MASK / UNMASK
  • SQL Databases in Google Cloud, AWS Cloud
  • Azure CLI Integration & Configuration
  • Azure CLI with Azure Portal. Telemetry, ASM, ARM
  • SQL Server Creation, DB Creation with Azure CLI
  • MFA and Virtual Machines in Azure. REST API
  • Power BI Workspace with Azure SQL Database

Video 13: SQL Server Virtualization (Azure Virtual Machines)

Azure Virtual Machines : Virtualisation @ Linux, Virtualisation @ Windows, Configuration Reset, Password Reset, Load Balancing, Auto-Scaling Azure VM Licensing : Pay as you go, Reserved Virtual Machine Instances, Virtual Machine "image", VM Licensing for SQL Server, Regular SQL Server Licensing, BYOL (BUY YOUR OWN LICENSE), Licensing and Pricing Charts, RHEL, SLES, LTX Linux Prices. Azure VM Properties: VM SIZE, DS1_V2, D2S_V3, DS_V3. MAXIOPS, MEMORY, DISK SUPPORT, Availability Zone , Managed Disks, Remote Disks, Version Controls, Fault Tolerance, Automated Error Correction, Subnet Masks, Storage Accounts, Version Controls, Fault Tolerance, AutoShutdown, Monitoring, Diagnstic Disk. Virtualisation @ SQL Server : SQL Server Configuration, Version, Edition, Storage (Data, Log), Enabling SQL Authentication, Port & Connectivity Settings, Managed Service Identity, Register with Azure Active Directory, IP based connections to SQL Server VM, Data Migrations on On-premise, Using DMA Tool; Project Assessment, Deploy Schema and Data, DB Migrations from Azure to VM.

This SQL Azure Training course includes MCSA 70-473 Certification Material and Guidance
 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today
 

Azure SQL Database Video Training from SQL School. Azure SQL Database Development Videos, Azure SQL Database Administration Videos, Azure Database Training Videos, Azure Database Training Videos from SQL School. Register Today

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer : Mr. Sai Phanindra T