Azure SQL (DEV) Online Training (LIVE, Instructor-Led)

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 Azure SQL Database Trainings.

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. This Azure SQL Database Training course also include MCSA Certification Guidance. Register Today

Azure SQL DBA Schedules - Trainer : Mr. Sai Phanindra T

Timings (IST) Free Demo Start Date  
6:30 AM to 7:30 AM Oct 16th Oct 18th Register
10:15 AM to 11:15 AM Sep 25th Sep 27th Register
5:30 PM to 6:30 PM Oct 3rd Oct 5th Register

If above schedules does not work ? please opt for Azure SQL DBA Video Training. All Trainings are completely Practical and Real-Time.

For One-One / Custom / Weekend Trainings, Register here

Azure SQL DBA Admin Training

Course Fee & Duration

Total Course Fee: INR 15000

Total Duration: 8.5 Weeks

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

Arrange Callback from the Trainer

All Training Sessions are Completely Practical & Real-time

Azure SQL DBA (with Server, T-SQL) Course Contents:

Module I: SQL Server & Design, Queries

CHAPTER 1: SQL SERVER INSTALLATION

What is Database? Need for DB Admins Editions and Versions Of SQL Server Roles and Responsibilities For SQL DBA How to install SQL Server - Step by Step SQL Server 2016,2014,2012 Installation SQL Server Management Studio (SSMS) SSMS and SQLCMD Tool Configurations DBA Checklist - Routine DBA Activities DBA Checklist - Maintenance Activities DBA Checklist - Emergency Activities Course Plan and Free Takeaways Weekly Mock Interviews, Resume Placement Assistance and Certificates MCSA Certification Pattern - Course Plan Online Lab Access (24x7 LIVE Server)

CHAPTER 2,3: BASIC SQL: DDL and DML

Testing Installation, Server Connections SSMS Tool (Client) and Object Explorer Defining Query Sessions - Session IDs Basic SQL with Databases and Tables DDL, DML, DCL and TCL Statements Basic Table Creation - Data Types INSERT / Store Data into SQL Tables Single, Multiple Row Inserts @ NULL SELECT Query Operators: IN, AND, OR IS, UNION ALL, NOT and BETWEEN UPDATE and DELETE Statements DELETE Versus TRUNCATE. DROP SYSTEM DATABASES - Importance MSDB, TempDB, Resource and Model Local Temp Tables. Global Temp Tables Wait Times, Client Statistics @ Queries CLIENT - SERVER Architecture (TDS) SQL Native Client (SNAC) Statistics Implementing TDS @ SQL Queries

CHAPTER 4: DATABASE & TABLE ARCH

SQL Server Database Architecture SQL Server Database Design Concepts Database Properties, Storage Options Data Files : Purpose, Sizing, Options Filegroups : Placement, Usage & Options Log files : Sizing, Placement, Growth Database Creation - GUI & SQL Scripts Filegrowth, Autogrowth and MAXSIZE Planning, Designing Large Databases Capacity Advantages - Filegroups, Files Database Structure - Modifications Adding New Filegroups, Files to DB Capacity Planning, Dedicated Log Store Data File Architecture - Pages, Extents Log File Architecture - VLF, Mini LSN Routing Tables to File Groups, Usage Schemas - Purpose, Usage with Tables CHAR versus VARCHAR Differences DB Log Files - Logged and NonLogged Default Schema, Aliases for Table Design Data Types and Aliases with Schemas

CHAPTER 5: CONSTRAINTS and KEYS

Constraints and Keys - Purpose, Usage Normal Forms, Relational DB Design OLTP DB Models, BCNF - Relations NULLABILITY Property and Importance UNIQUE KEY Constraints, Importance PRIMARY KEY Constraints, Limitations FOREIGN KEY References, Relations FOREIGN KEY Constraints - Limitations Schema Level and Table Level Relations CHECK Constraints - Usage, Limitations DEFAULT Column Constraints, Usage Identity Property with PRIMARY KEY Composite Primary Keys and Usage Constraints with Naming Conventions DB Design with Constraints, Schemas Constraint Priority and DB Properties

CHAPTER 6: JOINS & SUB QUERIES

Need for Joins and Use Case Scenarios JOIN - Types, Queries & Usage Options CROSS JOIN - Examples and Scenarios INNER JOIN - Examples and Scenarios OUTER JOINS - Types and Scenarios SELF JOINS with Self References, Types Joins with / without SCHEMA References Joining Multiple Tables and Join Types Table Join across Schemas, Filegroups Basic Aggregations with Joins. Aliasing Comparing Inner Join and Outer Joins Comparing Inner Join and Cross Joins Deciding the best Join Type, Options Sub Queries and Joins. Alternate Syntax End User Access to Queries - Interfaces Sub Queries and Simple Aggregations Sub Queries with UNION, UNION ALL

CHAPTER 7, 8: VIEWS, FUNCTIONS, SUB QUERIES

Views on Tables, Security Advantages Views as Stored SELECT Statements SCHEMABINDING and ENCRYPTION Cascaded Views, WITH CHECK OPTION Orphan Views - Scenarios in Realworld Common System Views, Metadata Access sys.databases, sys.tables, sys.views INFORMATION SCHEMA, Definitions Views with Multi Level Tables - Joins Queries - GROUP BY, HAVING Conditions Queries with GROUPING() and HAVING ROLLUP Options & Column Aggregations CUBE on Table Data - Purpose & Usage HAVING Vs WHERE - Performance Query Execution Order @ ROLLUP, CUBE Functions: Types, Purpose and Usage Scalar Value Returning Functions - Usage Inline Table Value Returning Functions Multi-line Table Value Returning Functions RETURNS and RETURN Values. Options BEGIN..END and IIF Functions, CASE Function Arguments - Usage and Options Variables and Function Parameters Static Variables and Dynamic variables Table Variables, WHILE LOOP Concepts System Functions and Metadata Access Date & Time Formats, Styles, DATEDIFF CAST, CONVERT, RANK, RowNumber Views for Sub Queries and Functions Views for Aggregations and Calculations

CHAPTER 9: STORED PROCEDURES - Level 1

Stored Procedures - Purpose and Usage Execution Options and Variants, Batch Variables, Parameters in Stored Procs Stored Procedures For Data Validations Stored Procedures For Dynamic Queries Important System Procedures, Metadata Extended Procedures For App. Access IF.. ELSE, ELSE IF, IIF, IS Conditions Error Handling: TRY, CATCH, THROW Usage of THROW - Performance Issues Precompilation of Stored Procedures Cached Plans, Compiled Plans, PC Cache Need for Recompilations, Outdated Plans Dynamic SQL Parameters and Variables Default Parameter Values, Usage Types OUTPUT Parameters and Query Options RECOMPILE & ENCRYPTION Option

CHAPTER 10: STORED PROCEDURES - Level 2

Stored Procedures for Dynamic Queries Recursive Queries: OUTPUT Parameters Common Table Expressions, In-Memory Stored Procedures for CTE (Sub) Queries Using CTE for Table Data Operations CTE for DML & DDL in Stored Procedures Using Stored Procedures with Cursors FORWARD_ONLY and SCROLL Cursors STATIC, DYNAMIC Cursors. ABSOLUTE LOCAL and GLOBAL Cursor. Reusability KEYSET Cursor & Performance Options Embedding Cursors in Procedures Memory Limitations with Cursors, SPs

CHAPTER 11: TRIGGERS & TRANSACTIONS

Use of Triggers - Use and Performance FOR / AFTER Triggers - Importance INSTEAD OF Triggers - Importance INSERTED and DELETED Memory Tables Triggers for DML Audits, Data Sampling Database Level & Server Level Triggers Bulk Operations & Updatable Views ACID Properties and Transaction Types EXPLICIT Transaction Types, Advantages IMPLICIT Transactions Types, Advantages Open Transactions - Query Blocking AUTOCOMMIT Transactions - Advantages Nesting Transactions and Save Points Transactions with SET Options, Cautions Isolation Levels and Purpose. READ COMMITTED, READ UNCOMITTED SNAPSHOT, SERIALIZABLE Isolations READ COMMITTED SNAPSHOT Isolation LOCK HINTS: READPAST, NOLOCK, etc..

CHAPTER 12: SQL SERVER ARCHITECTURE

Architecture: Query Processor, Threads Architecture: Storage Engine, File System Architecture: Parser, Optimizer, Mini LSN Architecture: SQL Engine, MDAC, Buffers Architecture: SQLOS Schedules, CLR Write Ahead Log,Lazy Writer,Checkpoints Query Optimizer (QO) & Execution Plans SQL DB Architecture: Files and Filegroups Virtual Log Files & Mini LSN & DOP Query Processing and Optimizer (QO) Client - Server Architecture of SQL Server TCP / IP, Named Pipes, Shared Memory SQL Native Client, OLE DB Drivers SQL Database Architecture - RAID Levels Log Sequence Numbers (LSN), Mapping Log File Architecture - Virtual Log Files Log File Architecture - Mini LSN, Usage DB Catalogs, CLR Integration, MDAC LSN Timestamps, Background Threads SQL OS Components, Thread Scheduler Buffer Manager, IO Manager, CLR SQL Server with External Protocols

Module II: Basic SQL DBA

CHAPTER 13: QUERY TUNING (INDEXES)

Indexes Types - B Tree Architecture Clustered Indexes - Architecture NonClustered Indexes - Architecture Execution Plans & Query Optimization Table Scan, Index Scan, Index Seek SORT_IN_TEMPDB and Index Memory FILLFACTOR and PAD_INDEX Options INCLUDED Indexes, HEAP Performance COLUMN STORE Indexes - Advantages FILTERED Indexes - Query Performance ONLINE Indexes and OFFLINE Indexes Indexes with Merge and Loop Joins Bitmap Index and Execution Plans Primary Key Index, Composite Indexes Materialized Views (Indexed Views) Usage Unique Clustered, NonClustered Indexes Estimated Execution Plans and Usage Actual Execution Plans - Precautions Client Statistics and Perf. Metrics

CHAPTER 14: DATABASE BACKUPS - OPTIONS

Backups - Background Threads, MSDB Backups - Types, Importance, Options Data Backups, Checkpoints, Page Level File Backups, Filegroup Backups - Extents Log Backup Mechanism, Data Truncates Partial Backups with ReadOnly Filegroups Tuning Database Backup Operations Mirrored Backups, FORMAT, SKIP, STATS Tape Backups - LOAD, UNLOAD, ERRORS COMPRESSION, CHECKSUM, VERIFY ContinueOnError, Backup Validation Backup History From MSDB Database Backup Audits - Media Set, Media Family Remote Backups and Security Options Compatibility, Recovery Model Options COPY_ONLY Backups and Importance Important Queries for Backup Audits Backup Verification, Security KEYS Backups using GUI and T-SQL Scripts Backup Devices - Purpose, Options Real-time Errors, Solutions @ Day 37

CHAPTER 15: RESTORES AND DB RECOVERY

Data Recovery using Backups, Log Files Restore Phases - COPY, REDO, UNDO Database Restores & FILELIST Options File Restores and Filegroup Restores FILELISTONLY, VERIFYONLY, REPLACE PARTIAL & PIECEMEAL Restores - Tuning Tail Log Backups & DB Recovery Options REDO Phase with T-Log Backups, Purpose Tail Log Backup Restores, UNDO Phase Partial Backups - STATS, VERIFY Options Strategies: Piecemeal/Piecemeal Restores SQL Server 2012 to 2014,2016 Restores Choosing correct DB Recovery Model Point-In-Time Restores and Log Recovery Restores From Backup Devices & Mirrors Restores From existing Databases, Files Restores using SQL Server T-SQL Script Restores using GUI. Data & Log Options Transaction Undo Files (TUF) Purpose Restore Audits and Standby Databases Checkpoint LSN and Restore Positions Real-time Errors, Solutions @ DAY 37

CHAPTER 16: JOBS, SQL SERVER AGENT

SQL Server Agent Service, Agent XPs SQL Agent Jobs - GUI Options, MSDB Job Steps: T-SQL, SSIS, Replication Job Schedules and Frequency Options Job Schedules and Email Notifications Job Executions, Disable/Enable Options Job History and Job Activity Monitor Import & Export (SSIS) Operations OLE-DB, SQLNCLI and MS Jet Drivers SSIS Packages for Data Import/Export SSIS Package Store - File System, MSDB SSIS Jobs - Scheduling SSIS Packages Backup Strategies For Minimal Data Loss Backup Jobs and Recovery Modes - Usage Backup Limitations with Recoery Modes Startup Jobs, Onetime, Recurring Jobs Job Activity Monitor and Agent Threads

CHAPTER 17: PERFORMANCE TUNING - 1

Identifying Long Running Queries Dynamic Management Objects: DMV, DMF Audit Long Running Queries - DMV/DMF Audit Frequent Running Queries - DMF Query Audits and DMVs / DMFs with Joins Query Statistics & LIVE Execution Plans CROSSAPPLY with Dynamic Views Avoding Sub Queries and Conditions Comparing Sub Queries and Query Joins Query Tuning and Resource Optimization Common Table Expressions (CTE) & Uses Using CTE, Data Retrieval in Stored Procs CTEs for Avoiding Self Joins, Scenarios CTE Advantages and Limitations Anchor, Recursive Members, Termination HASH JOIN Examples and Precautions MERGE JOIN Examples and Precautions LOOP JOIN Examples and Precautions OUTER APPLY and Multi - Level Joins

CHAPTER 18: PERFORMANCE TUNING - 2

Table Partitions and Query Tuning Options Partition Functions and Partition Schemes Partition Ranges, Values and Sort Orders Partition Un-partitioned Tables: Indexes Aligned / Indexed Partitions - Importance Data Compression - ROW & PAGE Levels Partition Numbers & Filtered Compression Managing Partitions and Tuning Options Partition Management @ SPLIT, MERGE Partition Elements, Concolation Options STATISTICS - Purpose and Tuning Options Column Statistics - Usage Advantages Index Statistics - Auto Index Creations Manual Update of Column Statistics Statistics in Query Tuning Process STATISTICS in Indexes, Query Conditions LIVE Query Statistics, Table Statistics

CHAPTER 19: PERFORMANCE TUNING - 3

LIKE Operator - Using Wild-cards Full Text Search Service Configuration Full Text Search - Database Settings Database Catalogs (FTC) and Storage Full Text (FT) Indexes for Query Tuning Full Text Columns and Primary Key Index Full Text Index - Search Query Issues Full Population, Incremental Population CONTAINS() and FREETEXT() Functions Token Search and Inflectional Forms Performance Tuning @ Full Text Indexes CONTAINSTABLE and FREETEXTTABLE Real-world Considerations with FTS FT Index Management Options, Statistics Stop Words Management, Tuning Options New Tuning Options @ SQL 2016

CHAPTER 20: PERF. TUNING - LEVEL 4

Index Internals and Execution Plans Execution Plans, Statistics, Query Cost Index Fragmentation Issues, Performance SAMPLED and DETAILED Scans. FillFactor Index Rebuilds (Online/Offline), Tuning Index Reorganization and Advantages Page, Row Compressions with Indexes Filtered & Online Indexes, Indexes Views GAM, SGAM Pages, Metadata Info Filtered Indexes and Size Limitations Table Statistics, Query Tuning Options Heaps, Clustered, Nonclustered Indexes Fill Factor, Pad Index and Query Tuning DTA: Sequential / Parallel Query Tuning DTA Tool with Profiler, Trace Tables, Cache Workload Files & Tables in Profiler SQL Profiler Tuning and Tuning Templates Database Tuning Advisor (DTA) - Usage DTA for Procedure Cache, Recent Queries DTA Tool for Multi-Database Connections Understanding PDS Options with Indexes MORE TUNING CONCEPTS: DAYS 35, 36

CHAPTER 21: REPLICATION For HA -- LEVEL 1

Replication Architecture and Entities Replication Topology, Plan, Connections Distributor Server Configurations, Options Distribution DB Configuration, Snapshots Publication Types - Purpose, Importance DB Articles, Publications, Subscriptions PULL Subscription Options and Types Snapshot Replication and Repl Agents Configure, Secure, Schedule Snapshots Transactional Replication Configuration Log Reader Agent - Configuration, Keys Tracer Tokens - Latency and Ranking Replication Monitor - Usage and Options Read Only Subscribers & Load Balancing Replication Jobs and Verification Options Adding Articles to Existing (LIVE) Replica Adding Subscribers to Existing Replica Stopping, Starting Replication Agents Scripting Replication Jobs, Publications Disable/Enable Replication, Agent Stops Real-time Errors, Solutions @ DAY 37

CHAPTER 22: REPLICATION For HA -- LEVEL 2

Transactional Replication, Tracer Tokens Merge Replication and Merge Agent Job Replication Conflicts and ROWGUIDCOL Peer-Peer Replication Connections, Nodes Adding Peer Nodes, Node ID Conflicts Replication across Lower/Higher Versions Replication Conflicts: Options, sp_MSRepl IDENTITY Property & Schema Replication PUSH and PULL Subscriptions - Options Domain Account Security in Replication Merge, Snapshot Replication Limitations Replica Initialization with Backups, Issues Transactional Versus Snapshot Replication Peer-Peer Vs Merge Replication For HA Load Balancing Options with Replication Replica Server @ Appl Connection Strings Replication Conflicts, Errors and Solutions Replication Warnings and Agent Alerts Replication for HA and DR - Strategies Replication Errors, Solutions @ DAY 37

CHAPTER 23: LOG SHIPPING - DISASTER RECOVERY

Log Shipping Topology, Operation Modes Primary and Secondary: Recovery Plan Log Shipping Monitor Settings, Alerts NORECOVERY Configuration and Usage STANDBY Mode Configuration, Purpose Log Shipping Jobs & Restore Schedules Copy and Restore Jobs with Secondary Log Shipping Monitor Status Reports Manual Failover Process and Recovery Versioning Issues, Data Traffic. Data Loss Log Shipping Jobs - Errors and Solutions Log Shipping Reports and Data Recovery Log Shipping Standby: Delay Restores Scripting Log Shipping Configurations Standby Disconnections, Latency Options Real-time Errors, Solutions @ DAY 37

CHAPTER 24: DATABASE MIRRORING: HA / DR

DB Mirroring Architecture For HA,DR DB Mirroring Configuration Scenarios TCP Endpoints and TCP Network Security Heartbeat and Polling Concepts in DM Service Accounts Configurations, Use Automatic Fail-Over Procedures, Tests Manual Failover Options and Scenarios PARTNER OFFLINE Conditions & Options DB Mirroring Monitors and Commit Loads SYNCHRONOUS & ASYNCHRONOUS Manual Failover and HA Partner Roles Mirroring Monitor, Stop/Resume Options DR & HA with DB Mirroring Advantages Need for Always-On & Higher Availability SET PARTNER Options and Db Recovery DB Recovery without Witness. Failover DB Mirroring Errors, Solutions @ DAY 37

Real-time Project Starts

Routine DBA Activities – Checklist

Emergency DBA Activities – Checklist

Maintenance Activities - Checklist

Module III: Advanced SQL DBA

CHAPTER 25: DB HEALTH CHECKS, AUDITS

Query Resources - CPU, IO and Memory Activity Monitor (AM) Tool - CPU, Memory Database File IO, Processes, Query Stats SQL Profiler Tool Usage, Audit Trace Files SQL Profiler Templates: Standard, Tuning Event Extraction Settings, Filter Columns DB ID Filters, CPU Filters, SSID Filters Profile Trace File Rollover, Size Settings Database Health Check: DBCC Commands Allocation Errors and Consistency Errors ESTIMATEONLY, NO_INFOMSGS, Tempdb Log Space Audits and Tempdb Audits Dynamic Management Views (DMVs) Important Dynamic Management Functions Memory Usage & Disk Usage Audit DMVs Storage Allocation Issues (Page, Extent) LOCKS - Types, Impact, Monitoring Shared Locks, Exclusive Locks, WAITS Deadlock Graphs with SQL Profiler Tool DEADLOCKS - Avoidance, Prevention LIVELOCKS - Avoidance, Prevention Deadlock Graphs @ SQL PROFILER, XDL Isolation Levels For OLTP - TempDB

CHAPTER 26, 27: SECURITY MANAGEMENT

Authentication Types - WINDOWS, SQL Windows Logins and REGEIDT Settings SQL Server Logins, POLICIES, EXPIRY LOGINS: Server Level Security, Options USERS: Database Level Security, Options SCHEMAS: Object Level Security, Options System Server Roles, Database Roles GRANT, WITH GRANT, DENY, REVOKE CONTROL, OWNERSHIP, Authorization Testing Security Operations, Scripting Common Security Functions & Queries DMVs for Server and DB Security Audits KEYS, Passwords - Data Level Encryption CERTIFICATES & TRIPLE-DES Algorithm Master Passwords and Data Encryption SQL Server Credentials, Job Security Proxies - Purpose, Usage and Options SSIS Proxies for Job Level Subsytems Password Resets and Disabling Logins Scripting Logins, Users, Roles, Schemas Security Audits, Role Membership Containment Databases and Purpose Contained Database Users and Roles

CHAPTER 28: MAINTENANCE PLANS, REPAIRS

Database Maintenance Plans (SSIS) DB Maintenance Strategies & Schedules MSDB History Management Options Backup Files and Space Management Reorganizing Indexes with Maint. Plans Stats Updates (Automatic) and Jobs Modifying SSIS DB Maintenance Plans Scheduling and Maintaining SSIS Plans Log File Issues & Shrinking Operations SQL DB Engine Properties & Guidelines Service Configuration Manager Options PAGE REPAIRS - suspect pages @ MSDB FILE REPAIRS, FILEGROUP REPAIRS DATABASE REPAIRS - DB Consistency DATABASE REPAIRS - Data Allocation DB Modes, Emergency, NOWAIT Options Managed DB Backups @ SQL 2016

CHAPTER 29: DB MIGRATIONS, DMA TOOL

Database Migration Options with SSIS DB Design Audits @ File System Store Database Detach Options and Downtime Database Attach Options and Scripting Scripting: Schemas, Object, Keys, Data Scripting Security Logins, Permissions Copy Database Wizard (SSIS) Tool Usage File System, SQL Server Package Store Migration Schedules, Jobs, Alerts, Logs Corrupted Logs, FORATTACH, REBUILDS Linked Server Security, Management Server Dashboard, Connection Audits Data Migration Assistant (DMA) Tool Using DMA Tool for DB Analysis, Upgrades DMA Tool: DB Assessment, Migration

CHAPTER 30: PATCHES, SERVER UPGRADES

Establishing Downtime For Maintenance Precautions for Maintenance Activities Service Packs and Patch/hotfix Activities Instance Selectivity for Updates, Cautions Pre & Post Patch Operations. Process Verifications, SmokeTest and Rollbacks Upgrade Advisor Tool - Analysis Reports Upgrade Advisor Issues and Warnings Server Upgrades and Precautions Planning for Maintenance Activities Rebuilding System Databases & DAC Pre Database Maintenance Activities Post Database Maintenance Activities Real-world Management Considerations

CHAPTER 31: CLUSTERING CONFIGURATION

Understanding SQL Clustering Service SQL Server Clustering Architecture Windows and SQL Server Licensing Windows Server Installation Options Service Pack and Patch Installations QUORUM Options for Windows Clusters SQL Server Cluster Plan - Licensing Installing Windows MSCS Service, Tests Ping Tests and Heart-beat Checks, DC Domain Configurations, Precautions MSCS - Microsoft Cluster Services, Nodes MSCS Service Startup Options, Issues Verifying SQL Server Cluster Installation

CHAPTER 32: CLUSTERS: ACTIVE DIRECTORY

Need for Centralized Authentication Domain Controller (DC) Configuration Active Directory Settings and Usage DCPROMO Settings for Active Directory Server Configuration Manager, Options Configuration Manager - Users & Groups Working with Active Directory (AD) Edits Network Configurations and Precautions PING Configurations and DTC Options QUORUM settings and SAN Options SQL Server Cluster Installation Cluster Configurations - Active/Active Cluster Configurations - Active/Passive MS DTC Configurations (Local/Remote)

CHAPTER 33: CLUSTERS NODES, ALWAYS-ON

Install SQL Server Clusters Clustering Nodes : Install, Update Need for Always - On Availability Always-On Prerequisites, Node Config SQL Group & AD Syncup Operations SAN System for Shared Data Storage Smoke Test Procedures in Real-time Fail-Over Disk & RAID Implementation Cluster Connection Issues and Drains Installing Updates - SQL Server Clusters Add Nodes to SQL Cluster - Active/Active SQL Server Cluster Utilities & Quorum Cluster Working and Operative Modes Configuration Settings, SQL Monitors Always-On Availability Groups (AAG) Prerequisites for Always-On for HA/DR Primary & Secondary Configurations Synchronization Settings, HA Options Port Settings, Backup Strategies in AAG

CHAPTER 34: SQL CLUSTERS, ALWAYS-ON

IP Configurations & WSFC Settings Node Majority, Disk & File Share Majority Active-Passive Cluster Configurations Network Security Issues with Solutions RAID, Storage Issues with Solutions Availability Replica - Readable Secondary Active Secondary, SYNC, ASYNC (AAG) Replica Recommendations for Always-On Routine DBA Challenges for AAG - HA/DR SLA/OLA Challenges, Tickets in Always-On Temporal Tables - AAG : SQL 2016 Stretch Databases @ SQL 2016

CHAPTER 35: PERF. TUNING - LEVEL 5

Memory Optimized Tables and Filegroups Memory Snapshot Settings in Real-world Temporal Tables, SYSTEM_VERSIONING Temporal Tables For Audits, Performance In-Memory Tables and Index Options Extended Events & Performance Impact LIVE Query Statistics - Monitoring, Metrics LIVE Query Statistics - Tracing, Baselining Performance Baseline Methodologies Optimize configuration of your databases Use DMVs and DB Performance Metrics Memory Tables Versus Temp Tables/Tables LIVE Execution Statistics, Hash Plans System Versioned Temporal Tables Querying, Modifications to Temporal Tables Tuning For Bulk Inserts - Recovery Models Cached Plans and Memory Store for SPs Performance Tuning - Checklist Activities

CHAPTER 36: PERF. TUNING - LEVEL 6

PERFMON Counters and MSDTC Service Memory, IO Resources : Performance MEMORY LEAKS and PAGE WAITS LATCH WAITS and Query Performance CPU, Thread Management, Windows Fibres Working with Machine Code @ SQL Server Resource Governor - Resource Pools Resource Workload Groups, Settings LOW, HIGH, MEDIUM Priority Queries Classifier Function, Cost Based Optimize Query Priority, CPU / Memory / IO Limits Windows Fibres and Priority Boost Degree Of Parallelism (DOP) Settings Processor Settings, Counter Thresholds

CHAPTER 37: COMMON ERRORS, SOLUTIONS

ROOT CAUSE ANALYSIS STRATEGIES Common Backup Errors, Solutions Restore Errors and DB Offline Errors Replication Errors and Solutions Log Shipping Errors and Solutions Trace Flags and Usage. DBCC PAGE DB Suspect Errors and Solutions Dynamic Data Masking (DDM) Security Scenarios with DDM Feature 3rd Party Tools (Litespeed) and Usage Ticketting Tools and SLA / OLA Database Support Levels, Escalations Descalations and KB Articles

Above course curriculum applicable for registrations from Aug 1st, 2017

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 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.

DAY 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

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
  • 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

DAY 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

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
  • 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

DAY 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

DAY 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

DAY 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

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
  • Data Discovery and Classification Options. Locks

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

DAY 12: POWERSHELL WITH AZURE SQL DATABASE (Admin)

  • 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
  • Install/Configure Windows Server, Readhat, Ubuntu
  • Azure SQL Database in VM to SQL Cloud
  • Deployment Automation Process, Automation Scripts
  • SQL Databases 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
MCSA Certification Guidance: 70-473

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 Preparation Mock Interviews

24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today
 
 

Azure SQL DBA Classroom Training Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed SQL Server Architecture, DB Repairs, Migrations
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses