SQL Server & T-SQL Training (LIVE, Instructor-Led)

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, Quer 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 Queries, Transactions and Query Tuning Operations 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 Training with Azure. Trainer : Mr Sai Phanindra T, 12+ Yrs Exp

  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)
Course Duration 2.5 Weeks 3.5 Weeks 4.5 Weeks 5.5 Weeks
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
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
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
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 4000/- INR 5000/- INR 7000/- INR 10000/-

* Data Analyst: MSBI Developer, Power BI, Tableau, SAP HANA, Data Scientists

Arrange Callback from the Trainer

Sch 1: 6:30 AM to 7:30 AM
October 17th - Register
Sch 2: 9 AM to 10 AM
November 1st week - Register
Sch 3: 11:15 AM to 12:15 PM
September 21st - Register
Sch 4: 5:30 PM to 6:30 PM
October 4th - Register
Sch 5: 7:30 to 9:30 AM (Wk)
October 6th - Register
 

SQL Server T-SQL (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 A, B, C, D

Module II: T-SQL Queries & Programming Basics

Applicable for Plan A, B, C, D

Module III: T-SQL Programming

Applicable for Plan B, C, D

DAY 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 : Roles, Responsibilities
  • BI Developers : Roles, Responsibilities
  • Data Analyst : Roles, Responsibilities
  • Business Analyst Vs Data Analyst
  • SQL Server Versions and Editions
  • Course Plan, Mock Interview Details
  • Real-time Project Details For Resume
  • 24x7 LIVE Server Access (Online Lab)

DAY 8: JOINS AND QUERIES - Level 1

  • JOINS - Types, Real-time Usage
  • JOIN Types and JOIN Options
  • CROSS JOIN - Examples, Conditions
  • INNER JOIN - Examples, WHERE, ON
  • OUTER JOIN - LEFT, RIGHT, FULL
  • Comparing OUTER JOINS and Types
  • Comparing INNER JOIN, OUTER JOIN
  • Joins with Constraints and Relations
  • Joining unrelated Tables - Possibilities
  • SELF JOINS and NATURAL JOINS
  • MERGE JOIN, LOOP JOIN, HASH JOIN
  • Join Options - Performance Advantages
  • Joining more than 2 Tables, Examples
  • Join Query Considerations for Big Data

DAY 14: STORED PROCEDURES - Level 2

  • Error Handling in T-SQL: TRY and CATCH
  • Error Handling - THROW. In-Memory, CTE
  • Dynamic Parameters and Variables in SPs
  • Stored Procedures - Dynamic Sub Queries
  • Common Table Expressions (CTE)
  • In-Memory Query Store and Result Store
  • CTE for DML, DDL Operations in SPs
  • Recursive CTEs, Self Joins in SPs
  • ANCHOR Members in CTEs - Examples
  • RECURSIVE Members in CTEs, Usage
  • TERMINATION Checks in Recursive CTEs
  • Table Valued Parameters (TVP) - Usage
  • User Data Types and Real-time Use
  • Cached Plans, Stored Procedures Memory

DAY 2: SQL SERVER INSTALLATION

  • SQL Server 2017 Installation
  • SQL Server 2016 Installation
  • SQL Server Management Studio Tool
  • SQL OPS (SQL Operations Studio) Tool
  • SSMS - Installation in Windows OS
  • SQL OPS - Installation in Linux, MAC
  • SSMS and SQLOPS - Connection Tests
  • Version & Editions - Comparison Charts
  • Instance, Types and Collation Options
  • Authentication, Service, FileStream
  • Adding Administrator Users for Instance
  • Windows Authentication : Real-time Use
  • Mixed Mode Authentication in Real-time
  • Common Installation Errors - Ref Doc
  • Older Version Installations - Ref Doc

DAY 9: SUB QUERIES, JOINS - Level 2

  • GROUP BY Queries for Data Reporting
  • GROUP BY, HAVING and GROUPING()
  • ROLLUP, CUBE Options for Reports
  • Sub Totals, Grand Totals, Aggregates
  • Replacing Nulls: ISNULL, COALESCE
  • CASE, IIF, CHOOSE and Aggregates
  • JOINS with Group BY & HAVING
  • JOINS with Group BY & ROLLUP
  • ROLLUP & CUBE with GROUPING
  • Query Execution Order with Joins
  • Working with Sub Queries on Tables
  • Nested Queries, Nested Sub Queries
  • Sub Queries Versus JOIN Queries
  • Sub Queries with JOIN Queries
  • Using Sub Queries with Join Options

DAY 15: STORED PROCEDURES - Level 3

  • SQL Injection Attacks, Parameter Sniffing
  • Stored Procedure for ReadWrite Parameters
  • READONLY Parameters in Stored Procs
  • User Defined Data Types, Real-time Use
  • Cursors - Benefits, Cursors in SProcs
  • FORWARD_ONLY, SCROLL Cursors
  • STATIC, DYNAMIC Cursors. ABSOLUTE
  • LOCAL, GLOBAL Cursor Types & Scope
  • KEYSET DRIVEN Cursor and Performance
  • Embedding Cursors - Procedures, Functions
  • SPs with Cursors @ Dynamic Data Loads
  • Data Formatting with Stored Procedures
  • WHILE loops, Dynamic SQL Code in SPs
  • FETCH_STATUS, CURSOR_ROWS
  • Memory Limitations with Cursors, SPs

DAY 3: BASIC SQL QUERIES - Level 1

  • DDL, DML, SELECT, DCL and TCL
  • Creating Databases and Tables
  • CREATE, ALTER, DROP Statements
  • INSERT, UPDATE, DELETE Statements
  • Data Inserts - SELECT - Modify
  • 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

DAY 10:INDEXES & QUERY TUNING

  • Indexes: Architecture and Types
  • Clustered Index Architecture Options
  • Non Clustered Indexes - Architecture
  • SORT_IN_TEMPDB, ONLINE Options
  • INCLUDED, COLUMNSTORE Indexes
  • FILTERED and COVERING Indexes
  • ONLINE Indexes, UNIQUE Indexes
  • B Tree Structures and IAM Pages
  • Query Optimizer (QO) Component
  • Execution Plans in SQL Server
  • Table Scan, Index Scan, Index Seek
  • Tuning Joined Queries, Conditions
  • Statistics and Tuning Options
  • Column Statistics, Index Statistics

DAY 16: BLOB, XML, Functions - Level 2

  • XML Options in T-SQL Queries, Joins
  • XML AUTO, XML RAW and XML PATH
  • Custom Root and Tags with XML Results
  • Using BULK INSERT and BULKCOLUMN
  • Correlated Queries, Use in Real-time
  • OPENROWSET() For Data Import, CAST
  • CONVERT,TRY_PARSE,TRY_CONVERT
  • ROW_NUMBER, RANK, DENSE_RANK
  • PATINDEX, CHARINDEX, RTRIM / LTRIM
  • Correlated Sub Queries - Aliasing
  • Using Self Joins in Nested Sub Queries
  • Generating Calendar Values @ Functions
  • Using Loops with Variables, Functions
  • CASE, SWITCH, IIF, CHOOSE Functions

DAY 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, COUNT() Options
  • FETCH, OFFSET, NEXT ROW Options
  • UNION, UNION ALL and Sub Queries
  • Single Quotes, Double Quotes, Aliases
  • UPDATE : Condition, Unconditional
  • DELETE and TRUNCATE Commands
  • ALTER Command   DROP Command
  • Client Server Architecture, TDS Packets

DAY 11: VIEWS, FUNCTIONS - Level 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
  • System Functions, Date-Time Functions
  • String Functions and PIVOT Operation
  • CAST, CONVERT, Date / Time Styles
  • 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

DAY 17: ISOLATION LEVELS & LOCKS

  • Isolation Levels : Types and Usage
  • Read Committed Isolation Examples
  • Read UnCommitted Isolation Examples
  • Snapshot Isolation Level, its Usage
  • Serializable Isolation Level, Blocking
  • ReadCommitted Snapshot Isolation
  • Query Blocking with Isolation Levels
  • Isolation Levels in Concurrent Queries
  • Choosing Best Isolation Level in OLTP
  • Locks - Types, Lock Hints in Real-time
  • Lock Grants and Lock Escalations
  • S, U, X, IX, IS, Sch-S, Sch-M, MD Locks
  • Lock Audits - System Stored Procedures
  • sp_lock and sysprocesses System Tables

DAY 5: SERVER, DB ARCHITECTURE

  • SQL Server Architecture, DB Architecture
  • Protocols, SQL Native Client (SNAC)
  • Query Processor, Parser and Compiler
  • Query Optimizer and SQL Manager
  • Storage Engine, File & DB Manager
  • Transaction Manager, Lock Manager
  • SQL Buffer Manager, SQL OS, IO Buffer
  • Checkpoints & Virtual Log File (VLF)
  • Database Data Files (mdf), Log Files (ldf)
  • Write Ahead Log (WAL) and Lazy Writer
  • Log Sequence Number (LSN), MINI LSN
  • Local Temporary Tables and Usage
  • Global Temporary Tables and Usage
  • Session Scope and Connection Scope

DAY 12: STORED PROCEDURES Level 1

  • Stored Procedures - Purpose and Types
  • Real-time Use with Stored Procedures
  • Using Stored Procedures for Validations
  • Using Stored Procedures for Queries
  • Variables, Parameters and Data Types
  • Stored Procedure Executions - Options
  • Precompilation, Recompilation Options
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions
  • PRINT Statements in Stored Procedures
  • Important System Stored Procedures
  • OUTPUT Parameters with SPROCs
  • Batch Executions in Stored Procedures
  • MERGE Statement in Stored Procedures
  • MERGE : MATCHED & NONMATCHED

DAY 18 - 20: REAL-TIME PROJECT
As a part of this SQL Server T-SQL Course we shall work on a Real-world BANKING Project. The project includes about 3000 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 Planning, Work Flow
  • Naming Conventions in Real-time
  • DB Creations with Files, Filegroups
  • MDF, NDF, LDF Files. FileGroups Usage
  • Table Creations - Schemas, Synonyms
  • Using Schemas for Data Storage
  • Relations, Implementing Normal Forms
  • Creating Data Sheets, Test Data
Phase 2: QUERY DESIGN
  • Joining Tables for Reports
  • Query Design and Tuning
  • Views with JOIN Options
  • Views with LOCK HINTS
  • FILLFACTOR, PAD_INDEX
  • Estimated, Actual Execution Plans
  • LIVE Execution Plans in Real-time
  • LIVE Query Stats, Index Selection
  • Implementing Indexed Views
  • Generating End User Reports
Phase 3: PROGRAMMING
  • Automating DML Operations
  • Using Views for Data Inserts
  • Using Triggers with Views
  • Transacional Codes in T-SQL
  • Event Handling Mechanism
  • Using Error Handling with THROW
  • Stored Procedures for DMLs
  • Stored Procedures with Triggers
  • Updatable Views - Triggers on Views
  • Stored Procedures with Transactions
Phase 4: RESUME - PROJECT PLAN
  • Project Interview Questions
  • Project Challenges, Solutions
  • Project Deployments, Go LIVE
  • Resume Planning with BI, Cloud Courses

DAY 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 - Relational Tables
  • CHECK Constraint : Importance, Use
  • DEFAULT Constraint : Importance, Use
  • Identity Property : SEED, INCREMENT
  • Using multiple Constraints in a Table
  • Candidate Keys Concept in Real-time
  • Constraints Priority and Real-time Use

DAY 13: TRIGGERS, TRANSACTIONS

  • Triggers - Purpose, Types Of Usage
  • DML Triggers - Events, Practical Use
  • FOR/AFTER Triggers - Realtime Use
  • INSTEAD OF Triggers - Realtime Use
  • INSERTED & DELETED Memory Tables
  • Enabling and Disabling Triggers
  • Database Level & Server Level Triggers
  • COMMIT, ROLLBACK Concepts in T-SQL
  • EXPLICIT & IMPLICIT Transactions
  • AUTOCOMMIT Transaction, ACID Options
  • Query Blocking - Prevention, Avoidance
  • NOLOCK and READPAST Lock Hints

DAY 7 : CONSTRAINTS - Level 2

  • Normal Forms - Real-time Use
  • First Normal Form and Atomicity
  • 2 Normal Form, Functional Dependency
  • 3 NF, BCNF, EKNF, 4 NF in Real-time
  • OLTP (Relational) Database Design
  • CASCADING with Character Keys
  • ON UPDATE & ON DELETE CASCADE
  • Composite Primary Keys, Practical Use
  • Self Referencing Keys and Practical Use
  • Adding / Disabling Constraints, Keys
  • Schemas - Purpose, Creation and Usage
  • Database Diagrams, PK-FK Base Tables
  • Excel Data Imports - Schema Reference
  • Constraints Priority and Real-time Use


REAL-TIME CASE STUDY
Real-time Case Study on Medicare Database.
This Case Study includes DB Design, Tables, Relations, Schemas, Test Data Inserts.

This Real-time Case Study also includes Queries, Join Types, Join Options, Views and Tuning Options.
PART 2 Of 2: Performance Tuning and Azure SQL Database (Cloud)

Module IV: Performance Tuning (Query Tuning)

Applicable for Plan C, D

Module V: Azure SQL Database Development & Cloud

Applicable for Plan D

DAY 21: QUERY TUNING 1 - CTE, PARTITION TABLES

  • Identifying Long Running Queries & Activity Monitor
  • Using Important Dynamic Management Objects (DMV, DMF)
  • Avoiding Self Joins - Real-world Scenarios
  • Avoding Sub Queries and Conditions - Real-world Scenarios
  • Comparing Sub Queries & Joins - Performance Baselines
  • Using CTEs for Memory Based Query Pre-Fetch
  • Query Tuning and Resource Optimization Options
  • Big Data - Performance Considerations
  • Table Partitions and Query Tuning Options
  • Partition Functions and Partition Schemes
  • Partition Ranges, Values and Sort Orders
  • Partitioning Un-partitioned Tables using Indexes
  • Aligned / Indexed Partitioning and Performance
  • Data Compression Types - ROW Level, PAGE Level
  • Partition Numbers and Filtered Compression Concepts
  • Managing Partitions and Query Tuning Options

Day 25: 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
  • Advantages of Azure SQL Databases & Tools
  • Service Models, Private & Public Clouds
  • Azure SQL & Databases - Need, Importance
  • Azure Sources - Types, Microsoft Market Place
  • Comparing Azure with AWS and Google Cloud
  • Azure SQL Database Architecture Components
  • Creating Azure SQL Server Instances
  • Creating Azure SQL Databases, Price Tiers
  • SQL Database – Cloud Database as a Service
  • Subscription Options and Database Sources
  • Price Tiers: Basic, Standard, Premium, PremiumRS
  • Isolated Price Trier - Advantages, Performance
  • Azure Resources Groups for SQL Databases

Day 22: QUERY TUNING 2 - FULL TEXT SEARCH, STATS

  • STATISTICS - Purpose and Types. Query Tuning Options
  • Column Statistics - Creation and Usage. Advantages
  • Index Statistics - Auto Creation with Indexes, Usage
  • Manual Update of Column Statistics - GUI & Scripting
  • STATISTICS with Indexes and Query Conditions. Updates
  • LIVE Query Statistics (SQL Server 2016), Table Statistics
  • LIKE Operator - Limitations. Using Wild-cards
  • Full Text Search (FTS) Configuration Options
  • Full Text Search Service Activation - DB Level
  • Filter Daemon Launcher Service - Purpose, Settings
  • Database Catalogs (FTC) and Storage Locations
  • Full Text (FT) Indexes for Query Tuning
  • Full Text Index For Searching Queries. Issues
  • Full Population and Incremental Population
  • CONTAINS() and FREETEXT() Functions

DAY 26: AZURE SQL DATABASE CONFIGURATION

  • DTU : Data Transaction Units : Architecture, Pools
  • eDTUs and Elastic Pool, per Database Settings
  • EDTU Cost, eDTU max/min Limits and Performance
  • Elastic Pools & Tier Selection - Recommendations
  • Database Name Identifiers, Naming rules & restrictions
  • Server Names - Locations, Admin Users, Passwords
  • S1/S2/S3 DTU bands and Performance, Storage
  • Add-On Storage Options. Database Provisioning
  • Firewall Rules and IP Configuration Ranges
  • Azure Dashboard - Metrics, Notification Options
  • Azure SQL Database Collation, Connection Options, Tools
  • SQL Server Management Studio (SSMS) & Visual Studio
  • SQL Server Data Explorer Tool in Azure Cloud
  • Need for OMS Workspace - Operations Management Suite
  • Log Audits and Exports with OMS Server - Configurations

Day 23: QUERY TUNING 3 - INDEX MANAGEMENT

  • Index Internals and Execution Plans
  • Understanding Execution Plans, Statistics, Cost
  • Index Fragmentation - Issues, Performance
  • Index Rebuilds (Online/Offline), Tuning Options
  • Index Reorganization Process and Advantages
  • Page, Row Compressions with Indexes - Cautions
  • GAM, SGAM Pages, Metadata Header Info
  • Fill Factor, Pad Index and Query Tuning
  • Memory Pages & IO Resources : Query Performance
  • Memory Optimized Tables, Optimized Filegroups
  • Memory Snapshot Settings and Real-world Usage
  • Temporal Tables and SYSTEM_VERSIONING
  • Temporal Tables For DML Audits, Performance Impact
  • In-Memory Tables Creation and Extended Events

DAY 27 : AZURE SQL DATABASE MIGRATIONS

  • Database Scripting Wizard in SSMS
  • Scripting On-Premise Databases in T-SQL
  • Data Migration Assistant (DMA) Tool
  • Schema Generation and Compatibility Issues
  • Generating Data Scripts and Assessment
  • Generate and Validate Scheams. Migrations
  • Prepare and Deploy Fixes. Database Snapshots
  • Resolving Database Migration Compatibility Issues
  • Partially Supported and Unsupported Functions
  • Schema Migration Options with DMA
  • In-Memory Tables Migrations to Cloud
  • Temporal Tables Migrations to Cloud
  • Comparing SQL DB OnPrem and Cloud Migrations
  • Real-world considerations with Azure SQL Database

Day 24: QUERY TUNING 4 - TUNING TOOLS

  • LIVE Query Statistics - Monitoring Options, Metrics
  • LIVE Query Statistics - Tracing, and Baselining
  • Excution Plan Analysis, Query Cost Metrics
  • CPU Cost, IO Cost, Sub Tree Cost, Spooling
  • Implementing Performance Baseline Methodologies
  • LIVE Execution Statistics, Hash Plans, Performance
  • Natively Compiled Stored Procedures, Performance
  • Tuning Bulk Inserts - Recovery Models & Logging
  • DTA: Usage, Sequential / Parallel Query Tuning
  • DTA Tool with Profiler, Trace Tables, Cache
  • Understanding Workload Files & Tables in Profiler
  • SQL Profiler Tuning and Tuning Templates
  • Database Tuning Advisor (DTA) - Usage
  • DTA Tool for Multi-Database Connections
  • Understanding PDS Options with Indexes
  • New Tuning Options - SQL Server 2017
  • Performance Tuning - Checklist Activities

DAY 28 : Azure SQL DATABASE - QUERY TUNING

  • Azure SQL Database Configuration Plans
  • Using SQL Data Explorer Tool, Visual Studio
  • Azure Database Programming Concepts
  • Monitor Azure SQL Database performance
  • Monitor Azure SQL Database query plans
  • Force Plan, Create Index, Drop Index
  • Configure Azure SQL Database Performance Insight
  • Design, Implement Elastic Pools for Azure SQL Database
  • Azure SQL Database JSON Features, Data Imports
  • Performance Insights - CPU Cost, IO Cost, Log Cost
  • Performance Recommendations and AI Reports
  • Azure Search Service - Purchasing Plans
  • Indexer Program - RETREIVABLE, SORTABLE
  • FILTERABLE, FACETABLE, SEARCHABLE
  • Searchable Indexes and Index Types - Options
  • Tuning Textual Data, WaterMarks in Azure
  • Azure Extended Events : Targers, Actions, Sessions

MCSA - 70 761 Exam Guidance

MCSA - 70 762 Exam Guidance

 
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

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