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.

Trainer : Mr Sai Phanindra T (11+ Yrs Exp)


Course Fee : INR 6000/- (USD 100). 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 Insigh, Azure DataLake

Azure SQL Database Training Course Contents:

Module I: AZURE SQL DATABASE (Dev)

Module II: AZURE SQL Admin (DBA)

DAY 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 & 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
  • Azure Cosmos DB, Data Lake, DH Insight, Spark
  • Virtual Machines and Apps, Programs in Azure
  • Azure SQL Variants and Service Tiers
  • Advantages of Azure SQL Databases & Tools
  • Comparing Azure with AWS and Google Cloud
  • Microsoft Azure Price Tiers & Subscription

DAY 8: AUTOMATED DB RECOVERY, GEO REPLICATION

  • Automated Backups in Azure SQL Database
  • 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
  • Power Shell For Geo Replication and Failback Options
  • Manage SQL database failover using Transact-SQL
  • Manage SQL database failover using Power Shell
  • Manage SQL database failover using the REST API
  • Backup Errors, Geo Replication Errors - Solutions

DAY 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
  • Resource Groups and Resource Pools in Azure SQL
  • 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

DAY 10: SECURITY MANAGEMENT - AZURE SQL DB

  • Firewall and Virtual Network Configurations
  • Server-level Firewall Rules in the Azure portal
  • Database-level Firewall Rule using SSMS
  • Connection strings and Security Options
  • 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), Security Roles
  • Impacted Databases and Security Options
  • 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
  • Power Shell Scripts to Implement DDM - MASK / UNMASK

DAY 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
  • S1/S2/S3 DTU bands and Performance, Storage
  • Add-On Storage Options. Database Provisioning
  • 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
  • Creating Azure SQL Databases in SSMS Tool
  • T-SQL Scripts for Azure SQL Database

DAY 9: 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

DAY 4: DEVELOP AZURE SQL DATABASE

  • Executing T-SQL Scripts in Azure
  • Creating Tables and Defining Constraints
  • Cascades, Constraint Rules and Index Rules
  • Clustered Indexes in Azure SQL Database Tables
  • Programming Objects: Stored Procedures in Cloud
  • Automated Recompilations, Complex Stored Procedures
  • Triggers and Memory Tables Architecture in Cloud
  • CTE : Common Table Expressions and Performance
  • User Defined Functions and Views for Data Reporting
  • Differences between On-Premise and Cloud SQL Databases
  • Executing T-SQL Scripts in Azure SQL Database
  • Linked Servers with On-Premise and Cloud
  • SSMS "Generate Script" Options, Advanced Options
  • Azure SQL Database JSON Features, Data Imports
  • Azure SQL Database In-Memory Tables - Advantages
  • Temporal Tables, In-Memory OLTP Tables with Azure SQL DB
  • Excel Reporting Options from Azure SQL Database
  • Data Explorer Options with Azure SQL Databases
  • XML Data Storage & Reports. BLOB Data Storage

DAY 11: PERFORMANCE TUNING in AZURE SQL DB

  • Manage database workload in SQL Server
  • Elastic Scale for Azure SQL Database
  • Service Tier and Edition Selection
  • Scaling Options - Horizontal, 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
  • Moving data between scaled-out cloud databases
  • 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. Resource Governor
  • FORCE PLAN, CREATE / DROP INDEX. ON / OFF INHERITS
  • Automated Tuning Options in Azure Database Cloud

DAY 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
  • Migrate Stored Procedures, In-Memory Tables

DAY 12: 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
  • Update Triggers and Delete Triggers - Azure Instance
  • Azure Database Integration. Elastic Query Plans
  • Requirements and Limitations with Database Synchronization
  • Azure Dashboards and Report Pins. Server Health Reports

DAY 6: INTEGRATING with AZURE SQL DATABASE

  • Azure SQL Database Tables, Views in Excel
  • Excel Pivot Tables and Chart Reports with Azure SQL DB
  • Azure & Excel ODC Connections. Pivot Reports
  • ADO.NET, JDBC and ODBC Connections. Data Mashups
  • Connection Drivers in Azure Cloud - Options
  • Azure Portal Email Configurations, Triggers
  • Azure SQL Database Query Batching - Advantages
  • Azure Cloud Shell - Concepts, Architecture
  • Azure Power Shell - Install and Configure
  • Installing and Scripting with Power Shell
  • PowerShellGet and Version Paths
  • Cloud Shell to run the Azure Power Shell
  • Linux Virtual Machines with Power Shell
  • Windows Virtual Machines with Power Shell

DAY 13: AZURE VIRTUAL MACHINE, OTHER CLOUDS

  • Plan for IaaS, Azure VM. Install Azure Virtual Machines
  • Install/Configure Windows Server, Readhat, Ubuntu
  • SQL Server on Azure VM - Config Settings, Elasitc Pools
  • Resource Groups, Resource Pools and eDTUs
  • Verify SQL Instances in Azure VM. sysadmin Account
  • 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
  • Real-time Considerations and Bacpac File Security
  • Azure HD Insight Configuration and Power Shell
  • Azure DataLake and Integration with Azure SQL Database
  • Power BI Workspace with Azure SQL Database

DAY 7: MCSA Certifications

Guidance and Mock Certification for 70-762 (SQL Dev)- If Required

 

Guidance and Mock Certification for 70-473 (Azure SQL) - Mandatory

DAY 14: MCSA Certifications

Guidance and Mock Certification for 70-765 (SQL DBA)- If Required

 

Guidance and Mock Certification for 70-473 (Azure SQL) - Mandatory

This AZURE Training Course includes one Real-time Project (Starbucks Cloud)

Deployments to SQL Azure Azure Database Integration Azure Cloud Versus AWS Cloud Azure Cloud Versus Google Cloud Pricing and Server Tiers Elastic Pools and Config Elastic Query Plans Geo Replication Issues Azure Interview FAQs Resume Preperation Mock Interviews

 
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