Plan A : Azure SQL Database Development & MCSA - 70 762

Day 1: AZURE CLOUD & AZURE SQL DATABASE

  • 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 - market Place
  • Comparing Azure with Google Cloud for SQL Server
  • Comparing Azure with AWS Cloud for SQL Server
  • Azure Sources - Types, Microsoft Market Place
  • Azure SQL & Databases - Need, Importance
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server Instances
  • Creating Azure SQL Databases, Price Tiers
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • Isolated Price Trier - Advantages, Performance
  • Advantages of Azure SQL Databases & Tools

DAY 2: AZURE SQL DATABASE CONFIGURATION

  • DTU : Data Transaction Units : Architecture, Pools
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • 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
  • Firewall Rules and 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
  • Add-On Storage Options. Database Provisioning

DAY 3 : AZURE SQL DATABASE MIGRATIONS

  • Data Migration Assistant (DMA) Tool
  • Schema Generation and Compatibility Issues
  • Generating Data Scripts and Assessment
  • Generate and Validate Scheams. Migrations
  • Database Scripting Wizard in SSMS
  • Scripting On-Premise Databases in T-SQL
  • Resolving Database Migration Compatibility Issues
  • Export Data Tier and BACPAC Files Generation
  • Migration Options with BACPAC Files
  • Creating Azure Cloud Storage Account
  • BLOB Data File Uploads and DB Imports
  • Creating Storage Containers for BLOB Data
  • Partially Supported and Unsupported Functions
  • Comparing SQL DB OnPrem and Cloud Migrations

DAY 4 : Azure SQL DATABASE - QUERY TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index, Drop Index
  • Azure SQL Database Performance Insight
  • Index Recommendations and History Logs
  • IO Metrics, CPU Metrics & Query Statistics
  • In-Memory Tables and Memory Optimization
  • In-Memory Performance - TPS for P15, P12
  • Azure Search Service - Purchasing Plans
  • Indexer Program - RETREIVABLE, SORTABLE
  • FILTERABLE, FACETABLE, SEARCHABLE
  • Searchable Indexes and Index Types - Options
  • Tuning Textual Data, WaterMarks in Azure
  • Bounding Box Model and DTU Scaling Options
MCSA - 70 762 Exam Guidance
*Above course curriculum applicable for registrations from October 6th, 2018.
 
 
Sch 1: 7:30 AM to 9:30 AM (Wk)
Oct 20th - Register
Online Course Fee
Total Fee : 9000/- (USD - 150)
Pre-requisites
  • Knowledge on SQL Server T-SQL
  • Work Experience preferred
  • If you are new to SQL, then opt for SQL Server T-SQL Plan D
Highlights
  • Azure SQL Development
  • Azure SQL Deployments
  • Query Tuning, Insights
  • Dynamic Joins in Cloud
  • Azure SQL Debugging
  • Azure Search Indexes
  • DTU, Elastic Pools
  • HD Insight, Azure DataLake
 
PART B : Azure SQL DBA (also includes SQL Server in Google Cloud, AWS Cloud)

Module I: AZURE SQL DATABASE

Module II: AZURE SQL 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 7: 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 8: 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 10: 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 11: 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 12: 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
Guidance and Mock Certification for 70-473 (Azure SQL)

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

This AZURE DBA Training Course includes one Real-time Project

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 Preparation Mock Interviews Beneficial For MCSA 70-765 and 70-473 Exams

 
 
Sch 1: 7:30 AM to 9:30 AM (Wk)
Oct 20th - Register
Classroom Course Fee
Total Fee : 9000/- (USD - 150)
Pre-requisites
Highlights
  • Azure SQL Development
  • Azure SQL Deployments
  • Query Tuning, Insights
  • Dynamic Joins in Cloud
  • Azure SQL DB Admin
  • Geo Replication, DB Sync
  • Azure SQL DB Security
  • HD Insight, Azure DataLake
 

Coming Soon

 
 
EVERY SESSION IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY SESSION. Register Today
 

Azure SQL Database Online Training from SQL School. This course includes Basic to Advanced Azure SQL Database Development, Azure SQL Database Administration, Performance Insights, Geo Replication, Database Synchronization, Advanced Security with TDE and RLS (Row Level Security), DDM and Azure Virtual Machines. Register Today

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