Azure SQL Database DEV - LIVE Online 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 (with Server, T-SQL, Azure SQL Database)

  PLAN A PLAN B
Azure SQL Dev - Job Profile Azure SQL Dev T-SQL + Azure SQL Dev
Applicable For Experienced Dev Starters, Experienced
Course Duration 1 Week 5.5 Weeks
Azure Cloud Concepts Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Database Concepts Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Migrations Check-Symbol-for-Yes Check-Symbol-for-Yes
Query Tuning in Azure SQL DB Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure Search & Sharding Check-Symbol-for-Yes Check-Symbol-for-Yes
Built-In Automated Tuning Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure Data Studio Tool Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure Elastic Queries Croos-symbol-for-Yes Croos-symbol-for-Yes
SQL Server, DB Architecture Check-Symbol-for-No Check-Symbol-for-Yes
Query Tuning and Execution Plans Check-Symbol-for-No Check-Symbol-for-Yes
Basic to Adv. Stored Procedures Check-Symbol-for-No Check-Symbol-for-Yes
CTEs, Partitions, Locks, Isolations Check-Symbol-for-No Check-Symbol-for-Yes
Temporal & Memory Tables Check-Symbol-for-No Check-Symbol-for-Yes
New Features: SQL 2017, 2019 Check-Symbol-for-No Check-Symbol-for-Yes
Real-time Project with Solution Check-Symbol-for-No Check-Symbol-for-Yes
MCSA 70-761 Certification Croos-symbol-for-No Croos-symbol-for-Yes
MCSA 70-762 Certification Croos-symbol-for-No Croos-symbol-for-Yes
Total Course Fee INR 5000/-
USD 75
INR 14000/-
USD 200

Azure SQL Database Training Schedules - Trainer : Mr. Sai Phanindra

S. No Timings (IST) Free Demo Start Date  
Schedules for Azure SQL Dev Training [Plan A]
1 6:30 AM - 8:00 AM (wk) Oct 5th Oct 6th Register
3 10:00 AM - 12:00 PM (wk) Sept 21st Sept 22nd Register
Schedules for T-SQL + Azure SQL Dev Training [Plan A, B]
1 6:30 AM - 7:30 AM Sep 16th Register
2 9 AM - 10 AM Oct 21st Oct 22nd Register
3 10:15 AM - 11:15 AM Sept 25th Sept 26th Register
4 6:30 PM - 7:30 PM Oct 3rd Oct 4th Register
5 7:30 PM - 8:30 PM Oct 2nd Oct 3rd Register

If above schedules does not work, opt for Azure SQL Database Video Training

All Trainings are completely Practical, Real-Time. Register Today

 

Azure SQL Database - TRAINING HIGHLIGHTS :

✔ In-depth Tuning ✔ Migration Issues ✔ In-Memory Data
✔ Schema Migrations ✔ Stretch Database ✔ DB Documenation
✔ Memory Tables ✔ Temporal Tables ✔ App Connections
✔ CTEs and TVPs ✔ Excel Imports ✔ Excel Pivots
✔ BLOB Storage ✔ Power Shell ✔ Azure CLI

Azure SQL Database (DEV) Training Course Contents:

PART 1 Of 2: SQL Server Basics, Queries, Stored Procedures and Database Development

Module I: SQL Basics, SQL Server Concepts

Applicable for Plan B

Module II: T-SQL Queries & Programming Basics

Applicable for Plan B

Module III: T-SQL Programming & Real-time Project

Applicable for Plan B

DAY 1: INTRODUCTION, INSTALLATION

  • Data, Databases and RDBMS Software
  • Database Types : OLTP,DWH,OLAP,HTAP
  • Microsoft SQL Server Advantages, Use
  • DB Engine, BI, Data Science Components
  • SQL : Purpose, Real-time Usage Options
  • SQL Versus Microsoft T-SQL [MSSQL]
  • Microsoft SQL Server - Career Options
  • Real-time Projects & Job Responsibilities
  • SQL Server @ Cloud: Azure, AWS, G Cloud
  • Versions and Editions of SQL Server
  • SQL Server and SSMS Installation Plan
  • SQL Server Pre-requisites : S/W, H/W
  • System Configuration Checker (SCC) Tool
  • SQL Server 2019 : Installation [Overview]

DAY 7: JOINS, T-SQL QUERIES - Level 1

  • JOINS - Table Comparisons Queries
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - Examples, WHERE, ON
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins - Real-time Scenarios
  • MERGE, LOOP, HASH Join Options
  • Big Table Versus Small Table Joins
  • Join Types Versus Join Options in T-SQL
  • CROSS JOIN Versus CROSS APPLY
  • Using Joins for DB Metadata Audits
  • Joining more than 2 Tables in T-SQL
  • Joining Tables with Query Conditions
  • Joining Unrelated Tables, Join Options

DAY 14: STORED PROCEDURES - Level 2

  • Table Valued Parameters (TVP) - Usage
  • SQL Injection Attacks - Type Precautions
  • READONLY Parameters - Stored Procedures
  • OUTPUT Parameters - Stored Procedures
  • User Defined Data Types, Real-time Use
  • Dynamic Data Insertions with Stored Procs
  • Table Cloning, Data Inserts @ Table Variables
  • 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

Day 2: INSTALLATIONS [DETAILED]

  • SQL Server 2016 Installation, Guidance
  • SQL Server 2017 Installation, Guidance
  • Instance Types: Default, Named Instances
  • SQL Server Features and Importance
  • SQL Server Database Engine For OLTP
  • File Stream and Collation Properties
  • SQL Server Authentication Modes
  • Windows Login & SQL Server Login Types
  • System Databases: Master, Model, MSDB
  • TempDB and Resource Database Locations
  • "sa" System Account, File Stream Property
  • SQL Server Management Studio. SSMS
  • Test Connection to Local Servers
  • Test Connection to Remote Servers

DAY 8: JOINS, T-SQL QUERIES - Level 2

  • GROUP BY Queries and Aggregations
  • GROUP BY Queries with Having Clause
  • Group By Queries - Query Design Rules
  • ROLLUP( ) & CUBE( ) Summary Values
  • GROUPING() Function for Row Status
  • Comparing WHERE, HAVING Conditions
  • Using UNION and UNION ALL in Queries
  • Date and Time Functions in T-SQL
  • DATEADD, DATEDIFF, Year, Month, Day
  • CAST, CONVERT, STRING Functions
  • PIVOT Functions and Normalization
  • RANK, DENSE_RANK, ROW_NUMBER
  • PARTITION BY and MERGE Statement
  • MERGE with IIF and CASE Statement

DAY 15: STORED PROCEDURES - Level 3

  • Views on Tables - SCHEMABINDING
  • ENCRYPTION and CHECK OPTION
  • Cascaded Views, Encrypted Views
  • Updatable Views, Joins with Triggers
  • Error Handling in T-SQL: TRY & CATCH
  • Error Handling, THROW in Procedures
  • Stored Procedures - WITH RESULT SETS
  • 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

Day 3: DATABASE & SQL BASICS - Level 1

  • SQL : Purpose and Real-time Usage
  • DDL, DML, SELECT, DCL and TCL
  • SSMS Tool : Connections and Usage
  • SQL Versus T-SQL : Basic Difference
  • Server Connections, Session Creations
  • Creating Databases and DB Connections
  • Creating Tables. Int, Char Data Types
  • Single Row Inserts, Multi Row Inserts
  • INSERT and INSERT INTO Statements
  • SELECT Statement for Table Retrieval
  • WHERE Conditions with =, OR, IN
  • AND, OR, NOT, IN, NOT IN Conditions
  • LIVE QUERY STATISTICS in SSMS
  • Table Scan Properties in SQL Server

DAY 9: Views, Functions, Procedure Basics

  • Views : Types, Usage in Real-time
  • System Predefined Views and Audits
  • Listing Databases, Tables, Indexes
  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBId, DBName, ObjectID, ObjectName
  • Variables & Parameters in SQL Server
  • Procedures : Types, Usage in Real-time
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys, sp_rename
  • Compare Views, SPs and Functions

DAY 16: FUNCTIONS - Level 2

  • Functions : Types, Real-world Usage
  • Inline Functions, Multi Line Functions
  • Looping Concepts in SQL Server
  • WHILE Loop Queries and UNPIVOT
  • GROUPING SETS and OUTPUT Function
  • EXISTS and RAISEERROR Functions
  • TRY_CONVERT, TRY_PARSE Functions
  • Using BULK INSERT & BULKCOLUMN
  • OPENROWSET For Data Import, CAST
  • OPENJSON For JSON Data Formats
  • JSON Files - Data Import into SQL DB
  • Json $Tag Notations, SELECT .. INTO
  • XML Options in T-SQL Queries, Joins
  • XML AUTO, XML RAW and XML PATH

DAY 4: DATABASE & SQL BASICS - Level 2

  • Creating Databases : Files [MDF, LDF]
  • Single Row Inserts, Multi Row Inserts
  • SELECT. WHERE Conditions, Operators
  • AND, OR, NOT, Mathematical Operators
  • IN, NOT IN, BETWEEN, NOT BETWEEN
  • IS NULL, LIKE, NOT LIKE. % and _
  • CHAR Versus VARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • DISTINCT, TOP, FETCH, ORDER BY
  • Basic Sub Queries with SELECT
  • UPDATE and DELETE Statements
  • TRUNCATE, ALTER, ADD and DROP
  • Table Scans, Measuring Query Time
  • CLIENT STATISTICS and Query Trails

Day 10: TRIGGERS, TRANSACTIONS

  • Triggers - Purpose, Real-world Usage
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level, Server Level Triggers
  • Auditting Triggers and Real World Use
  • Transactions : Types, ACID Properties
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Query Blocking Scenarios @ Real-time
  • Open Transctions in Real-world, Impact
  • NOLOCK and READPAST Lock Hints
  • Lock Hints, Join Hints in T-SQL Queries

Day 17: Database, Index Architecture

  • Database Architecture - Detailed
  • Primary File, Secondary Files [mdf, ndf]
  • Database Log Files (T-LOG) For Audits [ldf]
  • Data Files, Log Files, LSN & VLF
  • Transaction Log File [LDF] & LSN
  • Filegroups : ReadWrite & Read Only
  • Indexes: Architecture and Types
  • Clustered and Non Clustered Indexes
  • Included and ColumnStore Indexes
  • FILTERED and COVERING Indexes
  • UNIQUE Indexes, Online Indexes
  • B Tree Structure, IAM Page [Root]
  • Indexed Views / Materialized Views
  • Pages, Extents, and Checkpoints

DAY 5: SQL BASICS 3, EXCEL IMPORTS

  • Schemas : Real-time Usage, Security
  • Schemas Creation, Usage with Tables
  • Schema - Table Transfer. 2P, 3P Naming
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • Temp Tables and Session Scope
  • Temp Tables and Connection Scope
  • Excel File Imports into SQL Database
  • Using Import / Export Wizard in SSMS
  • Import Data @ Multiple Excel Sheets
  • Working with Microsoft JET Driver
  • SQL Native Client (SNAC) Connections
  • GUI for Database and Tables Creation
  • GUI Limitations for Big Data Inserts

DAY 11: SQL SERVER ARCHITECTURE

  • SQL Server Architecture Components
  • TDS Packets (N/W) in Client - Server
  • Protocols : Named Pipes and TCP / IP
  • Shared Memory and VIA Protocols
  • Parser, Compiler, SQL Query Validations
  • Query Optimizer (QO) and SQL Manager
  • Storage Engine Components and Usage
  • File Manager and Database Manager
  • Transaction Manager and Lock Manager
  • Buffer Manager, SQL OS and IO Buffer
  • Synchronization Services and Usage
  • Thread Scheduler in SQL OS Component
  • MDAC and CLR Components in SQL OS
  • Checkpoint, Lazy Writer, WAL Threads

DAY 18 - 20: REAL-TIME PROJECT (BANKING)
Includes 2500 Lines of Code (COMPLETELY SOLVED).

Phase 1: DATABASE DESIGN
  • Understanding Project Requirements
  • End to End Project Work Flow
  • Naming Conventions in Real-time
  • Table Schemas : Creation and Use
  • Implementing Normal Forms (OLTP)
  • Computed Columns and Data Types
  • SQL_Variant, Bit, sysname Data Types
  • Email, Phone Validations. Cascades
  • Data Types Conversions. Synonynms
Phase 2: QUERY DESIGN
  • Joining Tables for Reports
  • Views with JOIN Options
  • Implementing Indexed Views
  • Using PIVOT Tables in Queries
  • Using Functions for Queries
  • Dynamic Conditions in Queries
  • Parameterized Queries in T-SQL
Phase 3: PROGRAMMING
  • Event Handling , Error Handling
  • Stored Procedures with Transactions
  • Error Handling, Event Handling Options
  • Transaction Nesting, Save Points
  • Stored Procedures with Tables
  • Stored Procedures with Views
  • Stored Procedures with Functions
  • Automating DML with Triggers
  • Project Deployments, Project FAQ
   Project Solution Explanation
   Resume Points from the Project
   Interview FAQs from Project

DAY 6 : CONSTRAINTS, INDEXES - BASICS

  • 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
  • Indexes : Basic Types and Creation
  • Clustered and NonClustered Indexes
  • Primary Key and Unique Key Indexes
  • Tuning Basic SQL and T-SQL Queries
Real-time Case Study - 1 (Sales & Retail)
Objective : Database Design with Schemas,
Tables, Relations and Data Inserts.
Data Validations with Constraints, Keys.
Solution to be Explained in DAY 12

DAY 12, 13 : NORMAL FORMS, JOINS - Level 3

  • Self Referencing Keys and Self Joins
  • Composite Keys and Composite Indexes
  • 1:1, 1:M, M:1, M:M Relationship Types
  • ER Diagrams for Table Relations, Joins
  • Normal Forms for Entity Relationships
  • First, Second, Third Normal Forms Usage
  • Boycee-Codd Normal Form : BNCF : Usage
  • Functional Dependency and Candidate Keys
  • Multi-Valued and Transitive Dependencies
  • 4 NF, EKNF and ETNF Differences, Usage
Real-time Case Study - 2 (Sales & Retail)
Objective : Query Writing, Excel Integration
Generate Excel Pivot Tables, Pivot Charts,
Data Formatting, ODC Connections, Labelling.
Sub Queries, Nested Sub Queries with Joins
PART 2 Of 2: Performance Tuning and Azure SQL Database (Cloud)

Module IV: Performance Tuning & MCSA - 70 761

Applicable for Plan B

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

Applicable for Plan A, B

DAY 21: QUERY TUNING 1 - QUERY AUDITS, PARTITIONS

  • 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
  • Factors Impacting the Query Executions, Performance
  • Resumable Indexes, Usage in SQL Server 2017 & 2019
  • ONLINE, RESUME, PAUSE, MAX_DURATION Options
  • Query Store - Settings and Advantages. Options
  • PARTITIONS Mechanism : Advantages, Performance
  • Database Filegroups Usage with Partition Ranges
  • Partition Functions and Partition Schemes - Usage
  • Partitioning Un-partitioned Tables using Indexes
  • Aligned / Indexed Partitions - Query Importance
  • Partition SPLIT and Partition MERGE, NextUsed
  • Partition Compression Techniques : ROW, PAGE
  • Data Archival & SWITCH Partitions. Partitioned Views

Day 26: 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 - MarketPlace
  • Comparing Azure with Google Cloud for SQL Server
  • Comparing Azure with AWS Cloud for SQL Server
  • Azure Sources - Types, Microsoft Market Place
  • SQL Database Implementations in Azure Platform
  • Logical Servers, Virtual Machines, Managed Instance
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server (Logical Server)
  • Creating Azure SQL Databases and Pricing Tiers
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • DTUs Allocation for Database Size, Cost Models
  • Firewall Settings for Azure SQL Server (Logical Server)
  • Adding Firewall Rules - IP for Remote Access
  • Password Resets and Azure SQL Server Name Format

Day 22: QUERY TUNING 2 - FULL TEXT SEARCH, TABLE TYPES

  • Full Text Search (FTS) Mechanism - Architecture, Tuning
  • Stop Words, Stemmer and Thesaurus For FullText Queries
  • Indexer Program, Query Processor & FT Query Compilation
  • Database Catalogs (FTC) and FDHost.exe. Daemon Threads
  • Full Text (FT) Indexes for Query Tuning with Tokenization
  • Crawler Threads and User Tables. Filter Daemon Host Exe
  • CONTAINS() Queries and FREETEXT() Queries with SELECT
  • In-Memory Tables : Creation and Practical Usage for Tuning
  • Memory Snapshots and Database Level and Table Level
  • FileStream Files and Memory Snapshot Filegroups for MOT
  • MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT Settings
  • Manual Table Stats Updates with FullScan, NoRecompute
  • Temporal Tables : Real-time Usage and History Tracking
  • Statistics : Purpose, Creation Scenarios and Usage
  • Index Statistics and Column Statistics for Tables, ReUse
  • Comparing Triggers with Temporal Tables for Audits

DAY 27: DTU ARCHITECTURE, ELASTIC QUERIES

  • DTU : Data Transaction Units : Architecture, Pools
  • DTU - Memory and IO Resources for Reads & Writes
  • Bounding Box Model for Optimal Performance
  • Static Pools (DTU) and Elastic Pools (eDTU)
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Configuring Elastic Pools for Azure SQL Databases
  • Elastic Pools & Tier Selection - Recommendations
  • Elastic Scale for Azure SQL Database - Strategies
  • Vertical Partitioning and Horizontal Partitioning
  • Elastic Database Tool Libraries for Elastic Queries
  • Sharding - Topology for Elastic Query Processing
  • Split-Merge Servie for SaaS Software Applications
  • Elastic Database Features - ShardMap, ShardKey
  • MultiShard Queries and Elastic Transactions
  • LOOKUP, HASH and RANGE Strategies for Sharding

    Day 23: QUERY TUNING 3 - INDEX MANAGEMENT, LOCKS

    • Index Management Concepts for Performance Tuning
    • Internal Fragmentation and External Fragmentation
    • Fragmentation Audits : DMFs and Threshold Values
    • Index Reorganization and Index Rebuild Options
    • Database Maintenance Plans (DMP) For Index Reorg
    • Compress Large Objects, Fragmentation Condition
    • Index Page Count Condition, Index Usage Condition
    • Fast, Sampled and Detailed Scan Types for Indexes
    • Statistics Updates : Full Scan Options, DMP Jobs
    • LOCKS : Mechanism, Types, Concurrency Control
    • Lock Types: X, S, IS, IX, U, MD, Sch-M and Sch-S
    • Lock Audits : SP_WHO2, SP_LOCK, sysprocesses
    • Deadlock Simulation, Deadlock Prevention Scenarios
    • Deadlock Audits and Lock Events in Profiler Tool
    • Isolation Levels - ReadCommitted, Read Uncommitted
    • Serializable, Snapshot, Repeatable Read Isolations
    • Read Committed Snapshot Isolation Level in Real-time

    DAY 28 : AZURE SQL DB MIGRATIONS, AZURE DATA STUDIO

    • Data Migration Assistant (DMA) Tool
    • On-premise to Azure SQL Database Migration
    • Logical Server, Virtual Machine, Managed Instance
    • Schema Generation and Compatibility For Migration
    • Generating Data Scripts and Assessment
    • Generate and Validate Schemas. Migrations
    • Migration Scopes : Schema, Data, Schema & Data
    • Compatibility Checks and Assessment Checks
    • Resolving Database Migration Compatibility Issues
    • Azure Data Studio Tool for Database Connections
    • Azure Data Studio Features - Insights, Metrics
    • Comparing Azure Data Studio with SQL OPS Tool
    • SSMS Tool for Azure SQL Database Connections
    • SQLOPS Tool for Azure SQL Database Connections
    • SSDT (Visual Studio) for SQL Database Connections
    • Query Editor for Azure Database Access - in Portal
    • Azure Database Connections with Other Tools

    Day 24: QUERY TUNING 4 - TUNING TOOLS, PERFMON

    • 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
    • Execution Plans - Internals. Actual, LIVE Execution Plans
    • Plan Types : Index Scan, Index Seek, Tables Scan, Spooling
    • Query Costs : IO, CPU Cost, SubTree Cost, Operator Cost
    • NUMA Nodes, Boost SQL Priority, Thread Count, IO Affinity
    • Perfmon Counters and Real-time Tracking Of Resources
    • Processor, Disk, Memory, Transactions, Database Counters
    • Using Perfmon for Big Query Audits. Free & Total Memory
    • Longest Running Transactions & Transactions Per Second
    • Database Log Space - Issues, Solutions. Log Rebuilds
    • TempDB Issues - Causes, Precautions and Solutions
    • Memory Issues - Causes, Precautions and Solutions
    • Performance Tuning - Final Checklist and Precautions

    DAY 29: Azure SQL DATABASE TUNING, AZURE SEARCH

    • 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, Intelligence
    • Index Recommendations with CPU and IO
    • IO Metrics, CPU Metrics & Query Statistics
    • Data File IO, Log File IO, Custom Reports
    • Identify Long Running Queries, Intensive 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

    DAY 25: EXECUTION PLAN ANALYSIS and RESOURCES

    • Parameter Sniffing : Real-time Scenarios, Issues
    • Execution Plan Issues with Parameter Sniffing
    • DBCC SHOW_STATISTICS - Statistics Accuracy
    • Histograms & Density Vectors for Query Optimizer
    • RANGE_HI_KEY, EQ_ROWS and RANGE_ROWS
    • DISTINCT_RANGE_ROWS and Index Overlapping
    • sp_createstats and sp_autostats System Procedures
    • Detection and Fix of (Overlapping) Duplicate Indexes
    • Resource Governor : Real-time Usage
    • Resource Pools and Workload Groups
    • Query Priority and DOP, Grants, Classifier Function
    • Policy Based Management (PBM) : Facets and Conditions
    • Resource Governor : Real-time Usage & Conditions
    • Resource Pools : Creation and Usage Options
    • Workload Groups : Creation, Settings and Limits
    • Query Priority : LOW, MEDIUM and HIGH
    • DOP : Degree Of Parallelism and Allocation Grants

    DAY 30: AZURE SQL DATABASE VERSUS ON-PREMISE

    • Azure SQL Server Architecture Differences
    • Network Protocols and DB Engine Differences
    • File Structure and Filegroup Allocations
    • Secondary Files and FileStream Differences
    • Table Architecture for Partitions, FT Queries
    • Query Processing Differences with TDS Packets
    • Query Monitoring and Resources - Dashboards
    • Unsupported Commands with T-SQL Queries
    • SQL Traces : Creation and Audits. Limitations
    • SQL Traces : Events, Class, Category, Filter, Conditions
    • Extended Events and Traces for T-SQL Query Analysis
    • Extended Events Packages, Targets, Actions, Sessions
    • Extended Events Architecture and Engine Sessions
    • TSQL and SP Debug Events with XEL Files for EventInfo
    • Global Fields and Event Filters with XEL Files @ Traces
    • XE Objects : Catalog Views, Dynamic Management Views
    • XE Profiler - Default Templates for Event Profiling

    Real-time Case Study for Performance Tuning

    This Real-time Case Study includes:

    • Query Tuning : Basic to Advanced Level
    • Parameter Sniffing and OPTIMIZE Options
    • Implementing Partititions, Data Archives
    • Implementing Compressions for Read Only Data
    • Statistics Creation and Updates
    • Histograms and Event Handling Options
    • SQL Traces and XEL Profiler Charts
    • Index Management Techniques
    • Statics Management Techniques
    • Using SQL Profiler Tool
    • Using DTA : DB Engine Tuning Advisor
    • Using Perfmon Tool and AM Tool

    DAY 31: STRETCH DATABASES, MANAGED INSTANCES

    • 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
    • SQL Database Managed Instance
    • Native Virtual Networks and Scalability
    • Lift and Shift LOB Applications
    • Fully Managed PaaS Infrastructure
    • Frictionless Migration for On-Premise
    • Managed Instances - Key Features
    • vCore Purchasing Model for Azure SQL DB
    • Gen 4 and Gen 5 Logical CPUs, Resource Limits
    • Key Differences : On-Premise Vs Managed Instances

    MCSA - 70 761 Exam : Complete Guidance & Material

    MCSA - 70 762 Exam : Complete Guidance & Material

     

    Above Course Curriculum is applicable for registrations from Jan 20th, 2019

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

    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 - Trainer: Mr. Sai Phanindra T [ 13+ Yrs of Technical Expertise, Microsoft Certified Trainer ]

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