SQL Server & T-SQL (DEV) Video Training

This impeccable Microsoft SQL Server Training Course is exclusively designed for aspiring Data Analysts, Business Analysts, Data Scientists, MSBI / Power BI Engineers and SQL Database Developers. This SQL Server and T-SQL Training Course is designed for both starters as well as for experienced professionals. This course includes SQL Basics, T-SQL Queries, Query Writing and Query Understanding required for Data Analysts and Business Analysts. This course also includes Programming, Tuning and Azure SQL (Cloud) concepts required for BI Developers and SQL Database Developers. One Real-time project is included in this SQL Server and T-SQL Training Course addressing Basic to Advanced SQL Queries, Detailed Database Design, Complex Joins, Common Table Expressions (CTEs), Complex Stored Procedures, Triggers, Remote Joins, Transactions and Query Tuning with XML, BLOB and JSON Data Sources with complete guidance to MCSA 70-761 and MCSA 70-762 Microsoft Certification Exams.

Practice Material, Certification, Resume & Interview Guidance are included in this SQL Server T-SQL Course.

SQL Server & T-SQL Developer Course - Video Training

  PLAN A PLAN B PLAN C PLAN D
Applicable For Data Analysts SQL Dev (0-1 yrs) SQL Dev (1-2 yrs) SQL Dev (2+ yrs)
No Of Videos 12 Videos 18 Videos 23 Videos 28 Videos
Completely Real-time, Practical Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Mock Interviews, Case Studies Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL Basics and Query Writing Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
SQL DB Design, Table Design Croos-symbol-for-Yes Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Normal Forms, Joins, Queries Croos-symbol-for-Yes Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Indexes, Stored Procedures Croos-symbol-for-Yes Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
CTE, PIVOT, XML and BLOB Data Croos-symbol-for-No Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Advanced Stored Procedures Croos-symbol-for-No Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-time Project [Banking] Croos-symbol-for-No Croos-symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Performance Tools, Locks Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
In-depth Query Tuning Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Complex SPs, MCSA - 70 761 Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Database (Cloud) Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Azure SQL Database Migrations Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
DB Deployments, MCSA 70-762 Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Total Course Fee INR 5000/-
USD 75
INR 7000/-
USD 100
INR 10000/-
USD 150
INR 14000/-
USD 200
 

SQL Server T-SQL (DEVELOPER) Video Training Contents:

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

Module I: SQL Basics, SQL Server Concepts

Applicable for Plan A, B, C, D

Module II: T-SQL Queries & Programming Basics

Applicable for Plan A, B, C, D

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

Applicable for Plan B, C, D

Video 1: DATABASE & SQL SERVER BASICS

  • Introduction to Data, Databases, DBMS
  • Database Basics : Types of Databases
  • DB Types: OLTP, OLAP, DWH, HTAP
  • Microsoft SQL Server : Advantages
  • SQL, Transact SQL (T-SQL) Variants
  • Microsoft SQL Server - Career Options
  • SQL Developers : Job Responsibilities
  • BI Developers : Roles, Responsibilities
  • Data Analyst : Roles, Responsibilities
  • Business Analyst Vs Data Analyst
  • Course Plan, Mock Interview Details
  • Real-time Project Details For Resume
  • 24x7 LIVE Server Access (Online Lab)

Video 7: JOINS AND QUERIES - Level 1

  • JOINS - Types and Real-time Usage
  • JOIN Types and JOIN Options in T-SQL
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - LEFT, RIGHT, FULL
  • CROSS JOIN and CROSS APPLY
  • MERGE JOIN - Joining Bigger Tables
  • LOOP JOIN - Joining Smaller Tables
  • HASH JOIN - Joining HEAP Tables
  • GROUP BY Queries and Aggregations
  • GROUP BY Queries with Having Clause
  • ROLLUP, CUBE Queries with Group By
  • Grouping () Functions in Rollup, Cube
  • Replacing Nulls: ISNULL, COALESCE

Video 13: STORED PROCEDURES - Level 2

  • Error Handling in T-SQL: TRY & CATCH
  • Error Handling, THROW in Stored Procs
  • Updatable Views and Triggers with SPs
  • Implementing Dynamic T-SQL Programs
  • SQL Injection Issues, Real-time Solutions
  • Common Table Expressions (CTE)
  • CTE for DML, DDL Operations in SPs
  • CTEs @ Avoiding Self Joins, Sub Queries
  • Recursive CTEs and ANCHOR Elements
  • TERMINATION CHECK, Looping Options
  • Table Valued Parameters (TVP) - Usage
  • Output Parameters, ReadOnly Parameters
  • User Defined Data Types, Real-time Use

Video 2: SQL SERVER INSTALLATION

  • SQL Server 2019 Installation Guidance
  • SQL Server 2017 and 2016 Installation
  • Installation Pre-Requisites and Precautions
  • SQL Server Management Studio (SSMS)
  • SSMS - SQL Server Instance Connections
  • SQL Server Versions, Editions Comparisons
  • Evaluation, Developer Editions - Instances
  • Instances, Instance Types & Instance IDs
  • System Administrator Users @ Instance
  • Windows Authentication Type and its Use
  • Mixed Mode Authentication Type and Use
  • Default Admin Account in SQL Server : "sa"
  • SQL Server Services and Service Accounts
  • File Stream and Collation in SQL Instances

Video 8: SUB QUERIES, JOINS - Level 2

  • Joining 2 Tables with Group By, Having
  • Joining 3 Tables with Group By, Having
  • Joining 4 Tables with Group By, Having
  • Using MERGE and ROLLUP with Joins
  • Sub Queries Versus Joined Queries
  • Nested Queries and Joins in WHERE
  • Nested Sub Queries with JOIN Options
  • Cast and Convert Functions - Usage
  • Date, Time Functions, Sub Queries
  • DateAdd, DateDiff, Date Time Types
  • Date & Time Styles Usage in Queries
  • Data Formatting Options in Queries
  • Using Date and Time Formats in Joins
  • Join Queries - Aggregations, Formats

Video 14: STORED PROCEDURES - Level 3

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

Video 3: BASIC SQL QUERIES - Level 1

  • DDL, DML, SELECT, DCL and TCL
  • Creating SQL Databases and Tables
  • CREATE, ALTER, DROP Statements
  • INSERT, UPDATE, DELETE Statements
  • Data Inserts, Values and Table Scan
  • Data Types & their Usage (Basic Level)
  • INTEGER, CHAR, FLOAT Data Types
  • Character Range for Character Data
  • INSERT and INSERT INTO Statements
  • Single Row Inserts, Multi Row Inserts
  • SELECT Statement for Table Retrieval
  • WHERE Examples : =, !=, <,>, <=, >=
  • AND, OR, NOT, IN, NOT IN Conditions
  • BETWEEN, NOT BETWEEN Conditions

Video 9: INDEXES, VIEWS QUERIES

  • Indexes: Architecture and Types
  • Clustered and Non Clustered Indexes
  • Included and ColumnStore Indexes
  • FILTERED and COVERING Indexes
  • UNIQUE Indexes, Query Optimizer
  • LIVE Online Indexes in Real-time
  • B Tree Structures and IAM Pages
  • Tuning Joined Queries, Conditions
  • Views on Tables - SCHEMABINDING
  • ENCRYPTION and CHECK OPTION
  • Orphan Views - Real-world Solutions
  • Cascaded Views, Encrypted Views
  • System Views for Metadata Access
  • Indexed Views / Materialized Views

Video 15: Constraints, Functions - Level 2

  • CASCADING with Character Keys
  • ON UPDATE, ON DELETE CASCADE
  • Self Referencing Keys, Practical Use
  • Adding Primary Key to Existing Table
  • Adding Foreign Key to Existing Table
  • MERGE Statement for Table Comparisons
  • WHEN MATCHED and NOT MATCHED
  • PIVOT Operation, Correlated Sub Queries
  • Using BULK INSERT & BULKCOLUMN
  • OPENROWSET For Data Import, CAST
  • String Functions and STUFF ( )
  • XML Options in T-SQL Queries, Joins
  • XML AUTO, XML RAW and XML PATH
  • JSON Files - Data Import into SQL DB

Video 4: BASIC SQL QUERIES - Level 2

  • CHAR Versus VARCHAR Data Types
  • VARCHAR & NVARCHAR Data Types
  • GO Statement, SQL BATCH Concept
  • BIGINT, BIT, SQL_Variant Data Types
  • IS NULL, NOT NULL. LIKE, NOT LIKE
  • ORDER BY with ASC, DESC Options
  • DISTINCT, TOP and COUNT() Options
  • FETCH, OFFSET, NEXT ROW Options
  • UNION, UNION ALL and Sub Queries
  • Single Quotes, Double Quotes, Aliases
  • UPDATE : Conditional & Unconditional
  • DELETE and TRUNCATE Commands
  • ALTER Command   DROP Command

Video 10: Functions, Procedures - 1

  • Scalar Value Returning Functions
  • Inline Table Functions, Dynamic Joins
  • Multi-Line Table Functions Usage
  • Table Variables and Table Data Type
  • Variables & Parameters in SQL Server
  • OBJECTID, OBJECTNAME Functions
  • System Functions & Metadata Access
  • Stored Procedures - Purpose, Usage
  • IF .. ELSE and ELSE IF Conditions
  • Using Procedures with Parameters
  • Recompilation of Stored Procedures
  • Sp_help, Sp_helpdb and sp_helptext
  • Sp_recompile, sp_pkeys System SPs

Videos 16 - 18: REAL-TIME PROJECT
This SQL Server T-SQL Course includes a Real-world BANKING Project. The project includes about 2500 Lines of Code with basic to complex Stored Procedures, Join Queries, Triggers, Transactions and Lock Hints. (COMPLETELY SOLVED).
Phase 1: DATABASE DESIGN
  • Understanding Project Requirements
  • End to End Project Work Flow
  • Naming Conventions in Real-time
  • DB Creations with Files, Filegroups
  • Table Schemas and Synonyms
  • Implementing Normal Forms (OLTP)
  • Creating Data Sheets, Test Data

 

Phase 2: QUERY DESIGN
  • Joining Tables for Reports
  • Query Design and Tuning
  • Views with JOIN Options
  • LIVE Query Stats, Index Selection
  • Implementing Indexed Views

 

Phase 3: PROGRAMMING
  • Automating DML Operations
  • Using Triggers with Views
  • Event Handling , Error Handling
  • Stored Procedures for DMLs
  • Stored Procedures with Triggers
  • Stored Procedures with Transactions

 

Phase 4: RESUME - PROJECT PLAN
  • Project Interview Questions
  • Project Challenges, Solutions
  • Project Deployments, Go LIVE
  • Resume Plan - MSBI / Power BI, Cloud

 

Career Options for SQL Developers

Video 5: SERVER, DB ARCHITECTURE

  • Client Server Architecture, TDS Packets
  • SNAC and OLE DB Command for TDS
  • TDS Packets and SQL Query Processing
  • SQL Server Architecture Components
  • Protocols, SQL Native Client (SNAC)
  • Query Optimizer (QO) and SQL Manager
  • Storage Engine, File and DB Manager
  • Transaction Manager and Lock Manager
  • Buffer Manager, SQL OS and IO Buffer
  • Synchronization and Thread Scheduler
  • Logs, Checkpoints, Virtual Log File (VLF)
  • DB Data Files (mdf) and Log Files (ldf)
  • Primary/Secondary Files (ndf), Filegroups
  • Write Ahead Log (WAL) and Lazy Writer
  • Log Sequence Number (LSN), Mini LSN

Video 11: TRIGGERS, TRANSACTIONS

  • Triggers - Purpose, Types Of Usage
  • DML Triggers - Events, Practical Use
  • FOR/AFTER Triggers - Real time Use
  • INSTEAD OF Triggers - Real time Use
  • INSERTED, DELETED Memory Tables
  • Enable Triggers and Disable Triggers
  • Database Level DDL Triggers - Usage
  • Server Level DDL Triggers - Usage
  • COMMIT and ROLLBACK Statements
  • EXPLICIT & IMPLICIT Transactions
  • Autocommit Transaction, ACID Options
  • Conditional Commits and Rollbacks
  • Open Transactions and Query Impact
  • Query Blocking Scenarios @ Real-time
  • NOLOCK and READPAST Lock Hints

Video 6 : CONSTRAINTS Level 1

  • Constraints, Keys - Table Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, OLTP Relational Tables
  • CHECK, DEFAULT Constraints Usage
  • Candidate Keys and Identity Property
  • Normal Forms : 1 NF, 2 NF and 3 NF
  • BCNF, 4 NF, EKNF and ETNF Designs
  • Schemas - Purpose. Using DBO schema
  • User Defined Schemas & Data Transfer
  • Database Diagrams, PK-FK Base Tables
  • Local Temporary Tables and Sessions
  • Global Temporary Tables and Connections

Video 12: REAL-TIME CASE STUDIES, EXCEL

SCENARIO 1: HEALTHCARE DOMAIN
  • Writing Queries : Joins, Group By
  • Joining 2 and More Tables, Formatting
  • Writing Sub Queries with Joins
  • ROW_NUMBER and RANK Functions
  • DENSE_RANK, PARTITION BY Queries

SCENARIO 2: SALES & RETAIL DOMAIN
  • Excel File - Imports and Exports
  • Excel Pivot Tables and Pivot Charts
  • Excel ODC Connections in Real-time
  • CASE and IIF() Conditional Queries
  • String Functions with JOIN Queries
PART 2 Of 2: Performance Tuning and Azure SQL Database (Cloud)

Module IV: Performance Tuning & MCSA - 70 761

Applicable for Plan C, D

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

Applicable for Plan D

Video 19: 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

Video 24: 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

Video 20: 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

Video 25: DTU ARCHITECTURE, ELASTIC QUERIES

  • DTU : Data Transaction Units : Architecture, Pools
  • DTU - Memory and IO Resources for Reads & Writes
  • Bounding Box Model for Optimial 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 - Stategies
  • 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

    Video 21: 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

    Video 26 : AZURE SQL DB MIGRATIONS, AZURE DATA STUDIO

    • Data Migration Assistant (DMA) Tool
    • On-premise to Azure SQL Database Migratration
    • 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

    Video 22: 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

    Video 27 : 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, Intesive Queries
    • Query Level Recommendations and Query Costs
    • Azure Search Service - Configuration, Pricing Tiers
    • Azure Search for Data Import and Indexer Options
    • Suggester and Analyser Index Modes for Tuning
    • Retreivable, Facetable, Filterable Indexes
    • Facetable and Searchable Indexes for Tuning
    • Change Tracking Options, Watermark Columns

    Video 23 : EXECUTION PLAN ANALYSIS and EVENTS

    • 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 & 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
    • Classifier Function : Creation and RECONFIGURE
    • SQL Traces : Creation and Audits. Limitations
    • Extended Events and Traces for T-SQL Query Analysis
    • Extended Events Packages, Targets, Actions, Sessions
    • TSQL and SP Debug Events with XEL Files for EventInfo
    • Global Fields and Event Filters with XEL Files @ Traces
    • XE Profiler - Default Templates for Event Profiling

    Video 28 : 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
    Real-time Case Study for Azure SQL Database (DEV)
    This Case Study includes :
    • Database Assessment
    • Database Migrations
    • Azure SQL DB Scaling
    • Execution Plan Analysis
    • Query Processing Metrics
    • DTU Allocations and Insights
    • Performance Tuning Implementation
    • Azure Search Service Implementation
    • Azure SQL Database Event Log Commands

    MCSA - 70 761 Exam : Complete Guidance & Material

    MCSA - 70 762 Exam : Complete Guidance & Material

    * Above course curriculum applicable for registrations from March 23rd, 2019
     
    24x7 LIVE Online Server (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today
     

    SQL Server T-SQL Video 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