Azure SQL Database Training

Complete Real-time and Practical Azure SQL Database Training with Real-time Scenarios. This course includes complete practical approach to every detail of Azure SQL Database Development activities including On-premise to Azure Azure Database Migrations, Schema Migrations, Assessments, In-depth Query Tuning, Stretch Databases, Azure Shell, Power Shell, In - Memory Tables, Azure Search, Sharding, Application Connections and Azure CLI. This Azure SQL Database course also includes One Real-time Project on On-Premise to Azure Migration using DMA Tools.

Azure SQL Dev Training with Azure SQL

	PLAN A	PLAN B	PLAN C
Applicable For	Azure SQL Dev	SQL Dev + Azure Dev	SQL Dev + Azure Dev + Azure DevOps
Course Duration	2 Weeks	6 Weeks	10 Weeks
Course Content	Chapters 21 to 30	Chapters 1 to 30	Chapters 1 to 48
Completely Real-time, Practical	✔	✔	✔
Mock Interviews, Case Studies	✔	✔	✔
In-depth Query Tuning	✔	✔	✔
Performance Tools, Locks	✔	✔	✔
Complex SPs, MCSA - 70 761	✔	✔	✔
Azure SQL Database (Cloud)	✔	✔	✔
Azure SQL Database Migrations	✔	✔	✔
Stretch Databases, MCSA 70-762	✔	✔	✔
SQL Basics and Query Writing	❌	✔	✔
SQL DB Design, Table Design	❌	✔	✔
Normal Forms, Joins, Queries	❌	✔	✔
Indexes, Stored Procedures	❌	✔	✔
Excel Integration, Pivot Charts	❌	✔	✔
Advanced Stored Procedures	❌	✔	✔
CTE, PIVOT, XML and BLOB Data	❌	✔	✔
Real-time Project [Banking]	❌	✔	✔
Azure DevOps Benefits	❌	❌	✔
SDLC, Dev & Operations, DevOps	❌	❌	✔
DevOps Tools, Git & GitHub	❌	❌	✔
Docker, Kubernetes, AzureDevOps	❌	❌	✔
Azure Boards, Azure Repos	❌	❌	✔
Azure Testing, Azure Artifacts	❌	❌	✔
Azure Pipelines (CI, CD)	❌	❌	✔
Total Course Fee*	INR 8000 USD 109	INR 13000 USD 176	INR 25000 USD 338

Trainer: Mr. Sai Phanindra T

All Session Are Completely Practical & Real Time

If none of the above schedules work for you, please opt for On-demand Video Training

Azure SQL Dev Training Highlights

✔ Queries, Joins	✔ Dynamic SQL
✔ Query Tuning	✔ CTEs, TVPs
✔ Excel Imports	✔ In-Memory Tables
✔ Excel Pivots	✔ Azure SQL Concepts
✔ Complex joins	✔ Azure DB Migrations

Azure SQL Database (DEV) Training Course Contents:

Brochure:

Register Today

Module 1: SQL Server & T-SQL Dev Training Content [For Plans B, C ]

Ch 1: SQL SERVER INTRODUCTION

Data, Databases and RDBMS Software
Database Types : OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL : Purpose, Real-time Usage Options
SQL Versus Microsoft T-SQL [MSSQL]
Microsoft SQL Server - Career Options

SQL Server Components and Usage
Database Engine Component and OLTP
BI Components, Data Science Components
ETL, MSBI and Power BI Components
Course Plan, Concepts, Resume, Project
24 x 7 Online Lab for Remote DB Access
Software Installation Pre-Requisites

Ch 7: JOINS, T-SQL Queries : Level 1

JOINS - Table Comparisons Queries
INNER JOINS For Matching Data
OUTER JOINS For (non) Match Data
Left Outer Joins with Example Queries
Right Outer Joins with Example Queries
FULL Outer Joins - Realtime Scenarios
Join Queries with "ON" Conditions

Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Important Join Queries in T-SQL
Join Options: Merge, Loop, Hash

Ch 13: STORED PROCEDURES Level 2

Try..Catch & Error Handling Concepts
THROW Statement and PRINT Options
Event Handling in Stored Procedures
Copying Table Data with Transactions
Creating and Using Table Data Types
Table Valued Parameters (TVP) in SPs
ReadOnly Parameters in Stored Procs

Output Parameters, Stored Procedures
Using Cast, Convert with Stored Procs
Identity Property - Missing ID Values
Data Validations, DMLs in Stored Procs
Dynamic Data Insertions with SPs
Table Cloning, Inserts @ Table Variables
SQL Injection Attacks - Precautions

Ch 2: SQL SERVER INSTALLATIONS

System Configuration Checker Tool
Versions and Editions of SQL Server
SQL Server and SSMS Installation Plan
SQL Server Pre-requisites : S/W, H/W
SQL Server 2016 / 2017 Installation
SQL Server 2019 Installation
Instance Name and Server Features
Instances : Types and Properties

Default Instance, Named Instances
Port Numbers, Instance Differences
Service and Service Account Use
Authentication Modes and Logins
Windows Logins and SQL Logins
FileStream and Collation Properties
DBEngine and Replication Components

Ch 8: Group By, T-SQL Queries Level 2

GROUP BY Queries and Aggregations
Group By Queries with Having Clause
Group By Queries with Where Clause
Using WHERE and HAVING in T-SQL
Rollup : Usage and T-SQL Queries
Cube : Usage and T-SQL Queries
UNION and UNION ALL Operators
Comparing Where, Having Conditions

GetDate, Year, Month, Day Functions
Rollup with Having & Grouping
Date and Time Functions in T-SQL
Convert Functions with DateTime
DateTime Styles, DateAdd, DateDiff
String Functions: Trim, SubString
StringSplit, Concat, Len, Left, Right

Ch 14: STORED PROCEDURES - Level 3

Views: User Defined, System Defined
Data Retreival with Views, Conditions
DML Operations with Views, Conditions
Schema Binding, Structural Modifications
With Check Options and Data Validations
Embedd Views inside Stored Procedures
Dynamic Conditions with Views in SPs
Views: Real-world Use Cases

DML Triggers and DDL Triggers
FOR and INSTEAD OF Triggers
Magic Tables : Inserted, Deleted
ENCRYPTION and CHECK OPTION
Cascaded Views, Encrypted Views
Updatable Views, Joins with Triggers
Stored Procedures @ Triggers, Views

Ch 3: SSMS Tool, SQL BASICS - 1

SQL Server Management Studio
Local and Remote Connections
System Databases: Master and Model
MSDB, TempDB, Resource Databases
Creating Databases : Files [MDF, LDF]
Creating Tables in User Interface
Data Insertion & Storage. Limitations

SQL : Purpose and Real-time Usage
SQL Versus T-SQL : Basic Differences
DDL, DML, SELECT, DCL and TCL
Creating Tables using SQL Scripts
Data Storage, Inserts - Basic Level
Table Data Verifications with Select
SELECT Statement for Table Retrieval

Ch 9: JOINS, T-SQL QUERIES Level 3

Self Referencing Keys, Candidate Key
Adding PK to Existing Tables
Adding FK to Existing Tables
Self Joins and Table Aliases
Join Queries with Group By, Aggr
Views For T-SQL Query Store
Fetch, Offset, Next Rows, Order By

Joins with Group By, Sub Queries
Formating with IIF and CASE
Formating with Cast, Convert
Using Joins with Nested Sub Queries
Sub Queries and Alternatives to Joins
Excel Pivot Tables and Reports
Pie Charts & Data Refresh Options

Ch 15: STORED PROCEDURES - Level 4

Cursors - Benefits, Cursors in SProcs
ForwardOnly, Scroll & Local Cursors
Static, Dynamic & Global Cursors
Keyset Cursors and @@FetchStatus
Nesting of Stored Procedures - Dynamic
Data Formatting and WHILE Loops
Using Temporary Tables for Formatting

CTE : Common Table Expressions
Real-time Scenarios with CTEs - Usage
ROW_NUMBER() with CTE Queries
Using CTEs for Avoiding Self Joins
Using CTEs for Avoiding Sub Queries
Recursive CTEs and ANCHOR Element
Termination Checks in Recursive CTEs

Ch 4: SQL BASICS - 2

Creating Databases & Tables in SSMS
Single Row Inserts, Multi Row Inserts
Rules for Data Insertion Statements
SELECT Statement @ Data Retrieval
SELECT with WHERE Conditions
Batch Concept and Go Statement
AND and OR Operators Usage
IN Operator and NOT IN Operator

Between, Not Between Operators
LIKE and NOT LIKE Operators
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns
ALTER & DROP Table Statements

Ch 10: View, SPs, Function Basics

Views : Types, Usage in Real-time
System Predefined Views and Audits
Listing Databases, Tables, Schemas
Function Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
UDF: Creation, Executions with Select
Variables & Parameters in SQL Server
Implementing Dynamic Joins in T-SQL

Procedures : Types, Usage in Realtime
User & System Predefined Procedures
Using Parameters in Stored Procedures
Store, Execute T-SQL Queries in SPs
Performance Advantages with SPs
SPs on Single and Multiple Tables
Dynamic Joins & SP Recompilations

Ch 16: XML,BLOB,FUNCTIONS Level 2

Functions : Types, Real-world Usage
Scalar Value Returning Functions
Inline Table Value Functions
Multi-Line Table Value Functions
WHILE Loops and Iterations in T-SQL
Table Variables Usage in T-SQL
Data Types, Usage and Conversions
Scenario: Generating Calendar Values

Composite Keys, Computed Columns
Cascading Keys, Auto Update, EXISTS
XML AUTO, XML RAW and XML PATH
BULK INSERT, BULKCOLUMN, JSON
OPENROWSET, PIVOT and UNPIVOT
JSON Files - Data Import into SQL DB
Nested Queries, Co-related Queries

Ch 5: SQL Basics - 3, T-SQL INTRO

Database Objects : Tables and Schemas
Schemas : Group Tables in Database
Schemas : Security Management Object
Creating Schemas & Batch Concept
Using Schemas for Table Creation
Data Storage in Tables with Schemas
Data Retreival and Usage with Schemas
Table Migrations across Schemas

Import and Export Wizard in SSMS
Data Imports with Excel File Data
Performing Bulk Operations in SSMS
Temporary Tables : Real-time Use
Local and Global Temporary Tables
# and ## Prefix, Scope of Usage
Session Level, Connection Level Use

Ch 11: Triggers & Transactions

Triggers - Purpose, Real-world Usage
FOR/AFTER Triggers - Real time Use
INSTEAD OF Triggers - Real time Use
INSERTED, DELETED Memory Tables
Using Triggers for Data Replication
Enable Triggers and Disable Triggers
Database Level, Server Level Triggers
Auditting Triggers and Real World Use

Transactions : Types, ACID Properties
Transaction Types and AutoCommit
EXPLICIT & IMPLICIT Transactions
COMMIT and ROLLBACK Statements
Open Transaction Scenarios & Cause
Query Blocking Scenarios @ Real-time
NOLOCK and READPAST Lock Hints

Ch 17: Server, DB Architecture

Server Architecture and Protocols
Database Engine and Query Processor
Parser, Optimizer, SQL & DB Manager
Storage Engine Components, SQL OS
File Manager and Database Files
Transaction Services, Buffer Manager
Lock Manager, IO Manager, MDAC
CLR, WAL, Lazy Writer, Checkpoint

Database Architecture - Data Files
Database Architecture - Log Files
Primary (mdf), Secondary Files (ndf)
Filegroups Usage, ReadOnly Filegroups
Database Files : Size and Location
Pages, Extents. Uniform, Mixed Extents
Transaction Log File [LDF], LSN, VLF

Ch 6 : CONSTRAINTS,INDEXES BASICS

Constraints and Keys - Data Integrity
NULL, NOT NULL Property on Tables
UNIQUE KEY Constraints: Importance
PRIMARY KEY Constraint: Importance
FOREIGN KEY Constraint: Importance
REFERENCES, CHECK and DEFAULT
Candidate Keys and Identity Property

Database Diagrams and ER Models
Relationships Verification and Links
Indexes : Basic Types and Creation
Index Sort Options, Search Advantages
Clustered and NonClustered Indexes
Primary Key and Unique Key Indexes
Need for Indexes - working with Keys

Ch 12 : ER MODELS, NORMAL FORMS

Normal Forms for Entity Relationships
1st Normal Form and Atomocity
2 Normal Form, Functional Dependancy
3 Normal Form Multi Value Dependancy
Boycee-Codd Normal Form : BNCF
4 Normal Form Realtime Advantages
1:1, 1:M, M:1, M:M Relationship Types

MERGE Statement - Comparing Tables
WHEN MATCHED and NOT MATCHED
Incremental Loads, IIF Function
CASE Statement : WHEN, ELSE, END
ROW_NUMBER() and RANK() Queries
Dense Rank and Partition By Queries
Identify, Remove Duplicate Rows

Ch 18 - 20: REAL-TIME PROJECT (BANKING)
Includes 2500 Lines of Code (SOLVED).
Phase 1: DATABASE DESIGN

End to End Project Work Flow
Naming Conventions in Real-time
Schemas & Normal Forms (OLTP)
Computed Columns and Data Types
Email and Phone Number Validations

Phase 2: QUERY DESIGN

Views with JOIN Options
Implementing Indexed Views
Using PIVOT Tables in Queries
Dynamic Conditions in Queries
Parameterized Queries in T-SQL

Phase 3: PROGRAMMING

Event Handling, Error Handling
Transactions, Event Handling Options
Transaction Nesting, Save Points
Stored Procs with Functions, Triggers
Project Deployments, Project FAQ

Project Solution, Interview FAQs

Real-time Case Study - 1 (Sales & Retail)
Objective : DB Design, Table Design, Relations
Involves Purchases, Products, Customers
and Time Data with Various Data Types.

Real-time Case Study - 2 (Sales & Retail)
Objective : Query Writing, Excel Integration
Excel Pivot Tables, Pivot Charts,
Data Formatting, ODC Connections & Labelling

Module 2: Azure SQL Dev Training Content[For Plans A, B, C]

Module II: Performance Tuning & MCSA - 70 761 Applicable for Plans B, C	Module III: Azure SQL Database Development & MCSA - 70 762 Applicable for Plan C
Ch 21: QUERY TUNING 1 - AUDITS, INDEXES Audit Long Running Queries using DMVs and DMFs Activity Monitor Tool and Query Statistics Reports Logical I/O, Physical I/O and Database I/O, Wait Time Recent Expensive Queries & Active Expensive Queries Plan Handle and Execution Time - Query Usage Audits Server Dashboards and Memory Consumption Reports Factors Impacting the Query Executions, Performance Indexes: Architecture and Types : Clustered, Non Clustered B Tree Architecture and Advantages : IAM Page, Branches GAM, SGAM, PFS and Index Page Architecture Clustered & Non Clustered Indexes : Creation and Usage Included and ColumnStore Indexes : Creation and Usage Covering Indexes and Filtered Indexes : Creation and Usage Indexed View (Materialized View) : Performance Advantages SORT_IN_TEMPDB, ONLINE = ON. Real-time Considerations	Ch 26: AZURE CLOUD INTRO, CONFIGURATION 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 - MarketPlace SQL Database Implementations in Azure Platform Logical Servers, Virtual Machines, Managed Instance Installing SSMS and Azure Data Studio (ADS) Tools Creating Azure Account and Free Subscriptions Creating Azure SQL Server (Logical Server) Firewall Settings for Azure SQL Server (Logical Server) Adding Firewall Rules - IP for Remote Access Server Properties and Status Check. Server Name Format Password Resets and Azure SQL Server Name Format Creating Azure SQL Databases and Pricing Tiers Azure SQL Database Access from SSMS Tool
Ch 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT Query Store - Settings and Advantages. Options PARTITIONS Mechanism : Advantages, Performance Partition Functions and Partition Schemes - Usage Partitioning Un-partitioned Tables using GUI Table Data Compression Techniques : ROW, PAGE Compression of Speific Partitions, REBUILDS Partition and Compression Recommendations for OLTP Auditing and Verifying Partitions with sys.partitions Index Management - DOP : Degree Of Parallelism Index Rebuilding Process and Fragmentation Audits Index Page Count and Index Condition Checks Resumable Indexes: ONLINE and RESUME Options PAUSE and RESUME Options in Index Rebuilds Fast, Detailed Scans and Stats NoRecompute Statistics Management : Index and Column Stats	Ch 27 : DTU, ELASITC QUERIES, MIGRATIONS DTU : Data Transaction Unit, Resource Allocations Basic, Standard and Premium Plans For SQL DB vCore Based Purchasing : Gen 4 and Gen 5 Types General Purpose and Business Critical Plans Compute Tier : Provisioned and Serverless Bounding Box Model, Elastic Pools & Queries eDTUs and Elastic Pool, per Database Settings Azure Storage : Types, Creation & Containers LRS, GRS and RA-GRS Azure Storage Accounts Storage Containers, Storage Explorer Tool Usage Data Migration Assistant (DMA) Tool, Assessment Data / Database Migrations To Azure SQL Database Exports and Imports in Azure with bacpac Migration Scopes : Schema, Data, Schema & Data Schema Generation and Compatibility For Migration
Ch 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT Tuning Tools : Creating Workload Files and Trace Files SQL Profiler Tool - Tuning Template and TSQL / SP Events DTA Tool with Profiler Trace Files: Tuning Recommendations DTA with Query Cache (Procedure Cache) & .SQL File Inputs Perfmon Counters : Processor, Disk, Memory, Transactions, DB Execution Plans - Internals. Actual, LIVE Execution Plans Query Costs : IO, CPU Cost, SubTree Cost, Operator Cost NUMA Nodes, Boost SQL Priority, Thread Count, IO Affinity Execution Plan Issues with Spooling Mechanism Lock Types: Shared Lock, Intent Shared, Exclusive Lock Intent Exclusive, Update, Metadata, Schema Lock Lock Audits : SP_WHO2, SP_LOCK, sysprocesses Isolation Levels - ReadCommitted, Read Uncommitted Serializable, Snapshot, Repeatable Read Isolations Read Committed Snapshot Isolation Level in Real-time Deadlock Simulation, Deadlock Prevention Scenarios Deadlock Audits and Lock Events in Profiler Tool	Ch 28 : AZURE SQL DATABASE TUNING Azure SQL Server Level Tuning Options Azure SQL Database Level Tuning Options Automated Tuning Options and Peak-Loads Force Plan, Create Index and Drop Index Query Performance Insight, Recommendations IO Metrics, CPU Metrics & Query Statistics Data File IO, Log File IO, Custom Reports Query Audits with Query IDs, Dashboards DTU Usage Reports and Elastic Queries Query Level Recommendations and Query Costs Azure Search Service Configuration, Pricing Tiers Azure Search for Data Import and Indexer Options Suggester and Analyzer Index Modes for Tuning Retrievable, Facetable, Filterable Indexes Facetable and Searchable Indexes for Tuning Change Tracking Options, Watermark Columns Full Text Search : Performance Advantages
Ch 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES Full Text Search (FTS) Mechanism - Architecture, Tuning Stop Words, Stemmer and Thesaurus For FullText Indexes Indexer Program, Query Processor & FT Query Compilation Database Catalogs (FTC) and FDHost.exe. Daemon Threads Full Text (FT) Indexes : Query Tuning. Filter Daemon Host Creating Full Text Catalogs (FTCs) and FT Indexes CONTAINS() Queries and FREETEXT() Queries with SELECT Query Performance Impact with SQL Server T-SQL Queries Resumable Indexes, Usage in SQL Server 2017 & 2019 ONLINE, RESUME, PAUSE, MAX_DURATION Options In-Memory Tables : Creation and Practical Usage for Tuning Memory Snapshots at Database Level and Table Level FileStream Files and Memory Snapshot Filegroups for MOT MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT Temporal Tables : for DML Audits, System Versioning Using Temporal Tables for Data Audits, Timestamps Statistics : Purpose, Auto Creation and Updates	Ch 29 : XEL GRAPHS, STRETCH DATABASES SQL Traces : Creation and Audits. Limitations SQL Traces : Event Class, Category, Filter, Conditions Extended Events Package, Target, Action, Session TSQL and SP Debug Events with Global Fields XE Objects : Catalog & Dynamic Management Views XE Profiler - Templates for Event Profiling (Audits) Comparing XE Profiler with SQL Profiler Tool Comparing Azure SQL Database with On-Premise Stretch Databases in Azure SQL Databases Stretch Databases - Tuning Benefits, Cautions Table Level Migrations with Azure SQL Databases Compute Performance Levels and DSU Pricing Data Storage and Azure Database Snapshots Geo Backup Of Tables and Hybrid Cloud Settings Remote Data Archive Configuration in Azure Database Master Key [DMK], Cold Data Migration Real-time Advantages of Stretch Databases
Ch 25 : MCSA 70 761 Exam Pattern, Examples, Guidance	Ch 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance

Module II: Performance Tuning & MCSA - 70 761

Applicable for Plans B, C

Module III: Azure SQL Database Development & MCSA - 70 762

Applicable for Plan C

Ch 21: QUERY TUNING 1 - AUDITS, INDEXES

Audit Long Running Queries using DMVs and DMFs
Activity Monitor Tool and Query Statistics Reports
Logical I/O, Physical I/O and Database I/O, Wait Time
Recent Expensive Queries & Active Expensive Queries
Plan Handle and Execution Time - Query Usage Audits
Server Dashboards and Memory Consumption Reports
Factors Impacting the Query Executions, Performance

Indexes: Architecture and Types : Clustered, Non Clustered
B Tree Architecture and Advantages : IAM Page, Branches
GAM, SGAM, PFS and Index Page Architecture
Clustered & Non Clustered Indexes : Creation and Usage
Included and ColumnStore Indexes : Creation and Usage
Covering Indexes and Filtered Indexes : Creation and Usage
Indexed View (Materialized View) : Performance Advantages
SORT_IN_TEMPDB, ONLINE = ON. Real-time Considerations

Ch 26: AZURE CLOUD INTRO, CONFIGURATION

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 - MarketPlace
SQL Database Implementations in Azure Platform
Logical Servers, Virtual Machines, Managed Instance
Installing SSMS and Azure Data Studio (ADS) Tools

Creating Azure Account and Free Subscriptions
Creating Azure SQL Server (Logical Server)
Firewall Settings for Azure SQL Server (Logical Server)
Adding Firewall Rules - IP for Remote Access
Server Properties and Status Check. Server Name Format
Password Resets and Azure SQL Server Name Format
Creating Azure SQL Databases and Pricing Tiers
Azure SQL Database Access from SSMS Tool

Ch 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT

Query Store - Settings and Advantages. Options
PARTITIONS Mechanism : Advantages, Performance
Partition Functions and Partition Schemes - Usage
Partitioning Un-partitioned Tables using GUI
Table Data Compression Techniques : ROW, PAGE
Compression of Speific Partitions, REBUILDS
Partition and Compression Recommendations for OLTP

Auditing and Verifying Partitions with sys.partitions
Index Management - DOP : Degree Of Parallelism
Index Rebuilding Process and Fragmentation Audits
Index Page Count and Index Condition Checks
Resumable Indexes: ONLINE and RESUME Options
PAUSE and RESUME Options in Index Rebuilds
Fast, Detailed Scans and Stats NoRecompute
Statistics Management : Index and Column Stats

Ch 27 : DTU, ELASITC QUERIES, MIGRATIONS

DTU : Data Transaction Unit, Resource Allocations
Basic, Standard and Premium Plans For SQL DB
vCore Based Purchasing : Gen 4 and Gen 5 Types
General Purpose and Business Critical Plans
Compute Tier : Provisioned and Serverless
Bounding Box Model, Elastic Pools & Queries
eDTUs and Elastic Pool, per Database Settings

Azure Storage : Types, Creation & Containers
LRS, GRS and RA-GRS Azure Storage Accounts
Storage Containers, Storage Explorer Tool Usage
Data Migration Assistant (DMA) Tool, Assessment
Data / Database Migrations To Azure SQL
Database Exports and Imports in Azure with bacpac
Migration Scopes : Schema, Data, Schema & Data
Schema Generation and Compatibility For Migration

Ch 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT

Tuning Tools : Creating Workload Files and Trace Files
SQL Profiler Tool - Tuning Template and TSQL / SP Events
DTA Tool with Profiler Trace Files: Tuning Recommendations
DTA with Query Cache (Procedure Cache) & .SQL File Inputs
Perfmon Counters : Processor, Disk, Memory, Transactions, DB
Execution Plans - Internals. Actual, LIVE Execution Plans
Query Costs : IO, CPU Cost, SubTree Cost, Operator Cost
NUMA Nodes, Boost SQL Priority, Thread Count, IO Affinity
Execution Plan Issues with Spooling Mechanism

Lock Types: Shared Lock, Intent Shared, Exclusive Lock
Intent Exclusive, Update, Metadata, Schema Lock
Lock Audits : SP_WHO2, SP_LOCK, sysprocesses
Isolation Levels - ReadCommitted, Read Uncommitted
Serializable, Snapshot, Repeatable Read Isolations
Read Committed Snapshot Isolation Level in Real-time
Deadlock Simulation, Deadlock Prevention Scenarios
Deadlock Audits and Lock Events in Profiler Tool

Ch 28 : AZURE SQL DATABASE TUNING

Azure SQL Server Level Tuning Options
Azure SQL Database Level Tuning Options
Automated Tuning Options and Peak-Loads
Force Plan, Create Index and Drop Index
Query Performance Insight, Recommendations
IO Metrics, CPU Metrics & Query Statistics
Data File IO, Log File IO, Custom Reports
Query Audits with Query IDs, Dashboards
DTU Usage Reports and Elastic Queries

Query Level Recommendations and Query Costs
Azure Search Service Configuration, Pricing Tiers
Azure Search for Data Import and Indexer Options
Suggester and Analyzer Index Modes for Tuning
Retrievable, Facetable, Filterable Indexes
Facetable and Searchable Indexes for Tuning
Change Tracking Options, Watermark Columns
Full Text Search : Performance Advantages

Ch 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES

Full Text Search (FTS) Mechanism - Architecture, Tuning
Stop Words, Stemmer and Thesaurus For FullText Indexes
Indexer Program, Query Processor & FT Query Compilation
Database Catalogs (FTC) and FDHost.exe. Daemon Threads
Full Text (FT) Indexes : Query Tuning. Filter Daemon Host
Creating Full Text Catalogs (FTCs) and FT Indexes
CONTAINS() Queries and FREETEXT() Queries with SELECT
Query Performance Impact with SQL Server T-SQL Queries

Resumable Indexes, Usage in SQL Server 2017 & 2019
ONLINE, RESUME, PAUSE, MAX_DURATION Options
In-Memory Tables : Creation and Practical Usage for Tuning
Memory Snapshots at Database Level and Table Level
FileStream Files and Memory Snapshot Filegroups for MOT
MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT
Temporal Tables : for DML Audits, System Versioning
Using Temporal Tables for Data Audits, Timestamps
Statistics : Purpose, Auto Creation and Updates

Ch 29 : XEL GRAPHS, STRETCH DATABASES

SQL Traces : Creation and Audits. Limitations
SQL Traces : Event Class, Category, Filter, Conditions
Extended Events Package, Target, Action, Session
TSQL and SP Debug Events with Global Fields
XE Objects : Catalog & Dynamic Management Views
XE Profiler - Templates for Event Profiling (Audits)
Comparing XE Profiler with SQL Profiler Tool
Comparing Azure SQL Database with On-Premise

Stretch Databases in Azure SQL Databases
Stretch Databases - Tuning Benefits, Cautions
Table Level Migrations with Azure SQL Databases
Compute Performance Levels and DSU Pricing
Data Storage and Azure Database Snapshots
Geo Backup Of Tables and Hybrid Cloud Settings
Remote Data Archive Configuration in Azure
Database Master Key [DMK], Cold Data Migration
Real-time Advantages of Stretch Databases

Ch 25 : MCSA 70 761 Exam Pattern, Examples, Guidance

Ch 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance

Module 3: Azure DevOps Training Content [For Plans C]

Module I: Azure Funda & DevOps Basics	Module II: Azure DevOps Service - 1	Azure DevOps Service - 2 Az DevOps Server
Ch 1. Azure Fundamentals Basics of Cloud Computing Cloud Services: Advantages Cloud Services: Product Models Virtualization Concepts in Cloud Comparing On-Premise with Cloud DevOps : Introduction, Use Azure Cloud : Features, Advantages Azure Cloud : Services & Usage Azure Cloud : Platform Components Azure Resoures, Service Types Azure PaaS, IaaS & SaaS Azure Account Creation, Resources	Ch 7: Organizations & Projects Azure DevOps: Implementation Plan Creating and Using Organizations Planning and Security Advantages Region Specifications and Owners Users and Resource Limits Azure DevOps - Org Notifications Azure Projects - Creation, Use Public and Private Projects Version Control: Git and TFS Work Item Process: Agile Basic, CMM and Scrum Options Security, Teams, Dashboards	Ch 13: Azure Functions, App Service, Alerts Azure Functions and Automations Azure Event Notifications, Audits Azure App Services & Webapps Build, Deployment and Scaling Azure App Service Migrations Azure Apps Versus DevOps Azure Monitoring and Alerts Notification Options in Azure Alert Management, Operators Creating, Managing Alert Rules RBAC , Continuous Monitoring Smart Groups and Performance
Ch 2. Azure Services, Configurations Azure Registration and Azure Portal Azure Resources and Azure Services Azure Resource Types, Resource Groups Creating Resource Groups in Azure Portal Resource Groups: Access, Advantages Cost and Billing Management Azure Storage Account Creation Storage Account Types, Replication Azure BLOB Data Storage Containers Azure Storage Explorer Tool Uploads, Imports, SAS and Access Key Azure File Storage and On-Premise Access	Ch 8: Azure Boards Azure Boards - Creation, Use Work Item - Fields & Sprints Kanban Boards, Item Tracking Backlogs and Code Testing Bugs and Feature Requests Team Dashboards, Monitoring Azure Boards with Agile Process Azure Boards For CMMI Procces Azure Boards For Scrum Procces Change Column & Queries Style Rules and Highlight Cards Color Tag & Work Item Cards	Ch 14: Azure DevOps Resources in Portal Azure DevOps Services From Portal Application Insights and Logs Log Analytics and Storage Account API Management Services API Connections in Azure Azure DevOps Organizations DevTest Labs From Azure Portal Build Apps with Azure DevOps Azure Pipelines and Samples Plan and Buld Tasks in DevOps Setup Azure DevOps Org Account Create & Publish Azure Pipelines
Ch 3. Azure Active Directory, Monitoring Azure Active Directory Service Azure AD : Users, Tokens & Passwords Azure AD : Groups, Members, Owners Azure AD : App Registrations, Tokens Service Principals and Real-time Use Identity & Access Management (IAM) Azure Monitoring and Metrics Azure Dashboards and Counters Customizations and Usage Reports Azure Alerts and Conditions Notifications: Push/Email/SMS Log Analytics and Health Checks	Ch 9: Azure Repos Azure Repository (Repo), Storage Distributed Versus Centralized Azure DevOps Repos: Cloning Commit, Push and Pull Options Branch & Branch Policies Fork, Git and WorkFlow Git Versus TFVC, Customizations Public Projects and Pull Requests Notification Options in Repos Team Foundation Version Control Git and TFS Projects in DevOps Azure Repos with Slack	Ch 15: Azure DevOps Strarter, App Insights Azure DevOps Starter Deployments Migrations from Git Repository Continuous Integration (CI) Continuous Delivery (CD) Item Pipeline and Workflow Azure DevOps Pipelines DevOps Starter, Github Integration DevOps Starter, DevOps Integration DevOps Starter Vs Azure DevOps Github Actions & Azure DevOps Azure DevOps to Azure VM Examine CI and CD Pipelines
Ch 4. SDLC, Dev & Operations, DevOps Software Development Life Cycle SRS Documents and Principles Design, Planning and Coding Coding Techniques and Tools Testing Operations, Issues UAT, Production Deployment Issues Need for DevOps Services Life Cycle Management Automations and Code Control DevOps Tools and Techniques DevOps : Advantages, Benefits DevOps Engineers: Job Roles	Ch 10: Azure Pipelines For CI/CD - 1 Azure Pipelines - Architecture, Creation Azure Pipeline Creation Ecosystem Continious Integration (CI) Continious Development (CD) Build Pipeline in Azure DevOps Key Concepts, Real-time Use Creating Pull and Push Requests Release Pipelines - Creation, Use Multi Stage Release Pipelines New Branch Options with Pipelines Classic Release Pipelines Classic Editor - Pipeline Creation	Ch 16: Power Shell & Azure DevOps Azure Power Shell and DevOps Power Shell Installations Power Shell in Azure Portal Creating Resources in Portal Creating Pipelines in PowerShell YAML Snippet and Arguments Writing Sample Apps, Builds Writing Warnings and Errors Powershell with Multiple Args Service Fabric Manifests Publish Test Results in DevOps Run Functional Test Results
Ch 5. DevOps Tools, Git & GitHub DevOps Tools & Life Cycle Stages Continuous Development (CD) Continuous Integration (CI) Planning Phase: UML Tools Code: Visuaal Studio, Git Build: Maveen and Gradle Test: Selleinum and Junit Release: Jenking, Bamboo Deploy: Puppet, Chef, Ansible Operate: Visual Studio Options Monitor: NewRelic, Splunk Git & GitHub For Code Store	Ch 11: Azure Pipelines For CI/CD - 2 Continous Integration Pipelines PreDeployments in Azure devOps WorkTeam Correlation Options Azure Pipelines - Customizations GitHub with Azure Active Directory GitBub with DevOps Integration Pipeline Creation Comparisions AzurePipelines for YAML Agent, Approvals and Artifacts Caching, Conditions and Jobs Classic Builds and Class Release Dependancies, Job Deployments	Ch 17: DevOps Server - Configurations Azure DevOps Server - Advantages On-Premise Configurations for Server Code Share, Track Work and Shipping Visual Studio Team Fundation Server Azure DevOps Server - Installation Criterion for Azure DevOps Server SQL Server Installation for DevOps Database Engine, FullText Search Services and Service Account, Agent SSMS Tools Installation for Access Server Connections, Authentication Database Creation using SSMS
Ch 6. Docker, Kubernetes, AzureDevOps Introduction to Docker in Azure Understanding Docker Lifecycle ACI Containers and Options Introduction to Kubernetes in Azure Kubernetes Lifecycle Implementation Azure Kubernetes Containers, Options Azure DevOps : Advantages Azure DevOps: Services Azure Boards, Azure Repos Azure Pipelies and Realtime Use Azure Test Plans and Artifacts VSTS Versus Azure DevOps	Ch 12: Azure Testing & Artefacts Azure Testing Options in DevOps Manual Testing in Kanban Manual Testing in Test Manager UAT and Test Tracking Test Case Explorer in DevOps Stakeholder Feedback Azure Artifacts and Feeds Single Feeds & Multi Feeds Nuget, npm, Maven with DevOps Versions and Compatability Retention Polocies with Artifacts Maven Central Upstream Sources	Ch 18: DevOps Server & Visual Tools Privacy Advantages with DevOps Server XML Definition Files and Options Build Server Configurations Content Version and Projects General Administration Tasks Server Level Administration Tasks Adding Users to Projects Grant and Restrict Permissions Set Code & Test Properties Area and Iteration Paths Adding Teams and Scaling Billing Items & Monitoring

Module I: Azure Funda & DevOps Basics

Module II: Azure DevOps Service - 1

Azure DevOps Service - 2
Az DevOps Server

Ch 1. Azure Fundamentals

Basics of Cloud Computing
Cloud Services: Advantages
Cloud Services: Product Models
Virtualization Concepts in Cloud
Comparing On-Premise with Cloud
DevOps : Introduction, Use

Azure Cloud : Features, Advantages
Azure Cloud : Services & Usage
Azure Cloud : Platform Components
Azure Resoures, Service Types
Azure PaaS, IaaS & SaaS
Azure Account Creation, Resources

Ch 7: Organizations & Projects

Azure DevOps: Implementation Plan
Creating and Using Organizations
Planning and Security Advantages
Region Specifications and Owners
Users and Resource Limits
Azure DevOps - Org Notifications

Azure Projects - Creation, Use
Public and Private Projects
Version Control: Git and TFS
Work Item Process: Agile
Basic, CMM and Scrum Options
Security, Teams, Dashboards

Ch 13: Azure Functions, App Service, Alerts

Azure Functions and Automations
Azure Event Notifications, Audits
Azure App Services & Webapps
Build, Deployment and Scaling
Azure App Service Migrations
Azure Apps Versus DevOps

Azure Monitoring and Alerts
Notification Options in Azure
Alert Management, Operators
Creating, Managing Alert Rules
RBAC , Continuous Monitoring
Smart Groups and Performance

Ch 2. Azure Services, Configurations

Azure Registration and Azure Portal
Azure Resources and Azure Services
Azure Resource Types, Resource Groups
Creating Resource Groups in Azure Portal
Resource Groups: Access, Advantages
Cost and Billing Management

Azure Storage Account Creation
Storage Account Types, Replication
Azure BLOB Data Storage Containers
Azure Storage Explorer Tool
Uploads, Imports, SAS and Access Key
Azure File Storage and On-Premise Access

Ch 8: Azure Boards

Azure Boards - Creation, Use
Work Item - Fields & Sprints
Kanban Boards, Item Tracking
Backlogs and Code Testing
Bugs and Feature Requests
Team Dashboards, Monitoring

Azure Boards with Agile Process
Azure Boards For CMMI Procces
Azure Boards For Scrum Procces
Change Column & Queries
Style Rules and Highlight Cards
Color Tag & Work Item Cards

Ch 14: Azure DevOps Resources in Portal

Azure DevOps Services From Portal
Application Insights and Logs
Log Analytics and Storage Account
API Management Services
API Connections in Azure
Azure DevOps Organizations

DevTest Labs From Azure Portal
Build Apps with Azure DevOps
Azure Pipelines and Samples
Plan and Buld Tasks in DevOps
Setup Azure DevOps Org Account
Create & Publish Azure Pipelines

Ch 3. Azure Active Directory, Monitoring

Azure Active Directory Service
Azure AD : Users, Tokens & Passwords
Azure AD : Groups, Members, Owners
Azure AD : App Registrations, Tokens
Service Principals and Real-time Use
Identity & Access Management (IAM)

Azure Monitoring and Metrics
Azure Dashboards and Counters
Customizations and Usage Reports
Azure Alerts and Conditions
Notifications: Push/Email/SMS
Log Analytics and Health Checks

Ch 9: Azure Repos

Azure Repository (Repo), Storage
Distributed Versus Centralized
Azure DevOps Repos: Cloning
Commit, Push and Pull Options
Branch & Branch Policies
Fork, Git and WorkFlow

Git Versus TFVC, Customizations
Public Projects and Pull Requests
Notification Options in Repos
Team Foundation Version Control
Git and TFS Projects in DevOps
Azure Repos with Slack

Ch 15: Azure DevOps Strarter, App Insights

Azure DevOps Starter Deployments
Migrations from Git Repository
Continuous Integration (CI)
Continuous Delivery (CD)
Item Pipeline and Workflow
Azure DevOps Pipelines

DevOps Starter, Github Integration
DevOps Starter, DevOps Integration
DevOps Starter Vs Azure DevOps
Github Actions & Azure DevOps
Azure DevOps to Azure VM
Examine CI and CD Pipelines

Ch 4. SDLC, Dev & Operations, DevOps

Software Development Life Cycle
SRS Documents and Principles
Design, Planning and Coding
Coding Techniques and Tools
Testing Operations, Issues
UAT, Production Deployment Issues

Need for DevOps Services
Life Cycle Management
Automations and Code Control
DevOps Tools and Techniques
DevOps : Advantages, Benefits
DevOps Engineers: Job Roles

Ch 10: Azure Pipelines For CI/CD - 1

Azure Pipelines - Architecture, Creation
Azure Pipeline Creation Ecosystem
Continious Integration (CI)
Continious Development (CD)
Build Pipeline in Azure DevOps
Key Concepts, Real-time Use

Creating Pull and Push Requests
Release Pipelines - Creation, Use
Multi Stage Release Pipelines
New Branch Options with Pipelines
Classic Release Pipelines
Classic Editor - Pipeline Creation

Ch 16: Power Shell & Azure DevOps

Azure Power Shell and DevOps
Power Shell Installations
Power Shell in Azure Portal
Creating Resources in Portal
Creating Pipelines in PowerShell
YAML Snippet and Arguments

Writing Sample Apps, Builds
Writing Warnings and Errors
Powershell with Multiple Args
Service Fabric Manifests
Publish Test Results in DevOps
Run Functional Test Results

Ch 5. DevOps Tools, Git & GitHub

DevOps Tools & Life Cycle Stages
Continuous Development (CD)
Continuous Integration (CI)
Planning Phase: UML Tools
Code: Visuaal Studio, Git
Build: Maveen and Gradle

Test: Selleinum and Junit
Release: Jenking, Bamboo
Deploy: Puppet, Chef, Ansible
Operate: Visual Studio Options
Monitor: NewRelic, Splunk
Git & GitHub For Code Store

Ch 11: Azure Pipelines For CI/CD - 2

Continous Integration Pipelines
PreDeployments in Azure devOps
WorkTeam Correlation Options
Azure Pipelines - Customizations
GitHub with Azure Active Directory
GitBub with DevOps Integration

Pipeline Creation Comparisions
AzurePipelines for YAML
Agent, Approvals and Artifacts
Caching, Conditions and Jobs
Classic Builds and Class Release
Dependancies, Job Deployments

Ch 17: DevOps Server - Configurations

Azure DevOps Server - Advantages
On-Premise Configurations for Server
Code Share, Track Work and Shipping
Visual Studio Team Fundation Server
Azure DevOps Server - Installation
Criterion for Azure DevOps Server

SQL Server Installation for DevOps
Database Engine, FullText Search
Services and Service Account, Agent
SSMS Tools Installation for Access
Server Connections, Authentication
Database Creation using SSMS

Ch 6. Docker, Kubernetes, AzureDevOps

Introduction to Docker in Azure
Understanding Docker Lifecycle
ACI Containers and Options
Introduction to Kubernetes in Azure
Kubernetes Lifecycle Implementation
Azure Kubernetes Containers, Options

Azure DevOps : Advantages
Azure DevOps: Services
Azure Boards, Azure Repos
Azure Pipelies and Realtime Use
Azure Test Plans and Artifacts
VSTS Versus Azure DevOps

Ch 12: Azure Testing & Artefacts

Azure Testing Options in DevOps
Manual Testing in Kanban
Manual Testing in Test Manager
UAT and Test Tracking
Test Case Explorer in DevOps
Stakeholder Feedback

Azure Artifacts and Feeds
Single Feeds & Multi Feeds
Nuget, npm, Maven with DevOps
Versions and Compatability
Retention Polocies with Artifacts
Maven Central Upstream Sources

Ch 18: DevOps Server & Visual Tools

Privacy Advantages with DevOps Server
XML Definition Files and Options
Build Server Configurations
Content Version and Projects
General Administration Tasks
Server Level Administration Tasks

Adding Users to Projects
Grant and Restrict Permissions
Set Code & Test Properties
Area and Iteration Paths
Adding Teams and Scaling
Billing Items & Monitoring

Above Course Curriculum is applicable for registrations from Dec 2nd, 2020

Trainer Profile

Reviews

Course Curriculum

Mode of Training

Free Demo

SQL Server T-SQL Online 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
Certification Guidance to MCSA Exams
Interview Preparation & MOCK Interviews

End-End Database Design & Implementation
Detailed SQL Server Architecture, DB Design
Query Tuning, Stored Procedures, Linked Servers
In-Memory, New Features of SQL Server 2017
Azure SQL Database Programming, Sharding
In-Memory Tables and Azure Performance Insights

Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute

SQL Server, SQL DBA, MSBI, Azure SQL Dev, Azure SQL DBA, Power BI Training

Online Video

Online Video

Online Video

Online Video

Online Video

Details Register

Online Video

Online Video

Online Video

Details Register

Online Register

Online Video

Online Video

Online Video

Online Register

Online Video

[+] More Courses

Other Trainings

Online InHouse

Online Video

Details Register

Online InHouse

Online Video

Details Register

[+] More Courses

Azure SQL Database Training

Azure SQL Dev Training with Azure SQL

Azure SQL Database (DEV) Training Course Contents:

Ch 1: SQL SERVER INTRODUCTION

Ch 7: JOINS, T-SQL Queries : Level 1

Ch 13: STORED PROCEDURES Level 2

Ch 2: SQL SERVER INSTALLATIONS

Ch 8: Group By, T-SQL Queries Level 2

Ch 14: STORED PROCEDURES - Level 3

Ch 3: SSMS Tool, SQL BASICS - 1

Ch 9: JOINS, T-SQL QUERIES Level 3

Ch 15: STORED PROCEDURES - Level 4

Ch 4: SQL BASICS - 2

Ch 10: View, SPs, Function Basics

Ch 16: XML,BLOB,FUNCTIONS Level 2

Ch 5: SQL Basics - 3, T-SQL INTRO

Ch 11: Triggers & Transactions

Ch 17: Server, DB Architecture

Ch 6 : CONSTRAINTS,INDEXES BASICS

Ch 12 : ER MODELS, NORMAL FORMS

Module II: Performance Tuning & MCSA - 70 761

Module III: Azure SQL Database Development & MCSA - 70 762

Ch 21: QUERY TUNING 1 - AUDITS, INDEXES

Ch 26: AZURE CLOUD INTRO, CONFIGURATION

Ch 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT

Ch 27 : DTU, ELASITC QUERIES, MIGRATIONS

Ch 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT

Ch 28 : AZURE SQL DATABASE TUNING

Ch 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES

Ch 29 : XEL GRAPHS, STRETCH DATABASES

Ch 25 : MCSA 70 761 Exam Pattern, Examples, Guidance

Ch 30 : MCSA - 70 762 Exam Pattern, Examples, Guidance

Module I: Azure Funda & DevOps Basics

Module II: Azure DevOps Service - 1

Azure DevOps Service - 2 Az DevOps Server

Ch 1. Azure Fundamentals

Ch 7: Organizations & Projects

Ch 13: Azure Functions, App Service, Alerts

Ch 2. Azure Services, Configurations

Ch 8: Azure Boards

Ch 14: Azure DevOps Resources in Portal

Ch 3. Azure Active Directory, Monitoring

Ch 9: Azure Repos

Ch 15: Azure DevOps Strarter, App Insights

Ch 4. SDLC, Dev & Operations, DevOps

Ch 10: Azure Pipelines For CI/CD - 1

Ch 16: Power Shell & Azure DevOps

Ch 5. DevOps Tools, Git & GitHub

Ch 11: Azure Pipelines For CI/CD - 2

Ch 17: DevOps Server - Configurations

Ch 6. Docker, Kubernetes, AzureDevOps

Ch 12: Azure Testing & Artefacts

Ch 18: DevOps Server & Visual Tools

SQL Server T-SQL Online Training - Highlights :

Job-Oriented Real-time Training @ SQL School Training Institute

SQL Server, SQL DBA, MSBI, Azure SQL Dev, Azure SQL DBA, Power BI Training

Other Trainings

Azure DevOps Service - 2
Az DevOps Server