SQL Server Training Videos
 

SQL Server & T-SQL (DEV) Video Training

SQL Server T-SQL (DEVELOPER) course includes Database Fundamentals, Installation, In-depth DB and Table Design, Detailed Constriants, Joins, Views, Functions including Basic to Advanced Stored Procedures, Transactions, Triggers, XML & Query Tuning with one REAL-TIME PROJECT. Each video includes Study Material, Lab Works and Tasks & Solutions with 24x7 LIVE Server Access. Register for T-SQL Video Training

 
SQL Server & T-SQL (DEV) Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study Material and Lab Work for every video. Trainers available for doubts clarifications. COMPLETELY PRACTICAL & REAL-TIME. Versions: SQL Server 2016, 2014 & 2012

Type: 100% Practical & Example Based, Real-time
No. of Videos: 15 Videos (Duration: 80 mins per video)
Total Course Fee: INR 7000/- (USD 120) payable in 2 installments

This Video Course includes one Real-time Project. Download Brochure
Program Highlights & Trainer Profile

  • Completely Real-time and Practical
  • Video wise Lab Work and Tasks
  • One Real-time Case Studies
  • One Real-time Project
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MCT)

 

 

Module I: SQL Server & Design, Queries, Joins
8 Videos, INR 3500/- [~ USD 60]
Module II: T-SQL Queries, Tuning & Programming
8 Videos, INR 3500/- [~ USD 60]

Video 0: SQL SERVER (2016 / 2014) INSTALLATION -- Free Demo

  • What is Data? What is Database? File Store Limitations?
  • Why Microsoft SQL Server? Advantages (Technical/Usage)
  • What is SQL? What is T-SQL? Differences. Why T-SQL?
  • Versions and Editions of SQL Server - Overview
  • Video Wise Plan, Material and Real-time Project Details
  • LAB PLAN - 24x7 LIVE Server (Online Lab) For the Course
  • How to install SQL Server - Step by Step Guidelines
  • SQL Server 2016 Software - Server Installation Steps
  • SQL Server 2016 - Tools Installation and Verification
  • SQL Server 2014 / 2012 Software Installation Guidance
  • H/W & S/W Requirements. Server Configuration Options
  • Instance, Service, Authentication, Collation Properties
  • Installation Errors, Solutions. Server Name Conventions
  • SQL Server Tools - SQL Server Management Studio (SSMS)
  • Client Connectivity Tests, Browsing Servers (Local/Remote)
    Register

Video 8: STORED PROCEDURES - LEVEL 1

  • Stored Procedures - Purpose, Syntax, Properties and Types
  • Compilation, Precompilation and Query Optimization (QO)
  • Variables - Usage and Data Types in Stored Procedures
  • Parameters - Usage and Data Types in Stored Procedures
  • Stored Procedure Executions - Syntax, Alternate Options
  • Stored Procedures for Data Validations & Missing Identity
  • Stored Procedures for Dynamic SQL Queries. Views & SPs
  • Stored Procedures for Data Reporting. Advantanges, Tuning
  • Important System Procedures For Metadata Access. Usage
  • Important Extended Procedures For Application Operations
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions. PRINT statements
  • Error Handling Techniques in T-SQL: TRY, CATCH, THROW
  • Dynamic Parameters and Variables. Examples with Views
  • Default Parameter Values, Data Types and NULL Values
  • Batch Executions with Stored Procedures. Variants
  • Unicode Data and Dynamic SQL Queries. sysname Data

Video 1: SQL BASICS - DDL, DML, SELECT -- Free Demo

  • Testing Installation, Understanding Server Connection
  • Defining New Sessions for Writing Queries. Session IDs
  • Basic SQL for Beginners. Introducing Databases, Tables
  • What is SQL? Why T-SQL? Basic SQL Queries in SSMS
  • DDL and DML Statements - Creating & Using Databases
  • Table Creation (Basic Level) - Columns and Data Types
  • Issues with Digital Data into Characters. Missing Values
  • INSERT / Store Data into SQL Server Tables - Options
  • Single Row and Multiple Row Inserts with NULL Values
  • SELECT Queries and Basic Operators : IN, BETWEEN
  • UPDATE Statements with / without Conditions. SET
  • DELETE Statements with Conditions. Event Logging
  • TRUNCATE Statement - DELETE Comparisions, Logging
  • SYSTEM DATABASES - Purpose and Importance. Resource
  • CLIENT - SERVER Architecture (TDS) & Client Statistics
  • SQL Native Client (SNAC) and OLE-DB Providers
    Register

Video 9: STORED PROCEDURES - LEVEL 2

  • Stored Procedures for Sub Queries, Dynamic Sub Queries
  • Stored Procedures for Recursive and Nested Queries
  • OUTPUT Parameters in Stored Procedures. Usage Options
  • Common Table Expressions (CTE) and In-Memory - Syntax
  • Row Number and Rank Generation, Sub Queries, Self Joins
  • Stored Procedures for Parameterized CTE (Sub) Queries
  • Using CTE for Table Data Operations - DML & Retrieval
  • CTE for DML and DDL Operations in Stored Procedures
  • Using Recursive CTEs and Self Joins with Stored Procedures
  • Precautions for Recursive CTEs - Performance Impact
  • Query Tuning Operations with CTEs. Query Store Options
  • CTE Advantages and Limitations - Precompilations
  • Dynamic SQL Queries with Parameters and Variables
  • Cached Plans and Memory Store for Stored Procedures
  • RECOMPILE Options and ENCRYPTION Options - Scenarios
  • Identity Inserts - Manual Sequence. Dynamic Inserts
  • ANCHOR Members and RECURSIVE Members. Termination

Video 2: SQL SERVER DATABASE DESIGN

  • SQL Server Databases - Purpose and Design Options
  • SQL Database Architecture - Logical and Physical View
  • Database Properties - Files - Types - Storage Options
  • Data Files : Purpose and Sizing. Detailed Architecture
  • Filegroups : Purpose and Grouping Options. Properties
  • Log files : Sizing, Placement & Detailed Architecture
  • Pages, Extents (Uniform, Mixed). Data Allocation Process
  • Write Ahead Log (WAL) and Log Sequence Number (LSN)
  • Virtual Log File (VLF) and MINI LSN. Operation Audits
  • Database Creation using GUI - Adding Files, Filegroups
  • Database File and Filegroup Options. GUI Limitations
  • Database Creation using T-SQL Scripts. SYNTAX Rules
  • Database with Filegrowth, Autogrowth, MAXSIZE Options
  • mdf, ndf, ldf and Custom Extensions. Dynamic Extensions
  • Planning and Designing Very Large Databases (VLDB)
  • Adding Filegroups and Files. Size, Property Modifications
  • CHAR versus VARCHAR Differences - Type, Size Allocations

Video 10: STORED PROCEDURES - LEVEL 3

  • SQL Injection Attacks and Parameter Sniffing - Solutions
  • SQL Injection Vulnerables - Data Types and Validations
  • Table Value Parameters (TVP) - Purpose, Types and Syntax
  • User Defined Table Data Types and TVP Usage in SProcs
  • READONLY Parameters, Table Data Type (User Defined)
  • Error Handling with Table Valued Parameters in SProcs
  • Startup Stored Procedures: Configuration, Server Property
  • Server Startup, Auto Log Options with Stored Procedures
  • Extended Stored Procedures - Purpose, Options & Usage
  • Stored Procedures for Dynamic Values, Calendar Data
  • Cursors - Benefits, Syntax. Using SProcs with Cursors
  • FORWARD_ONLY and SCROLL Cursors Types. Limitations
  • STATIC and DYNAMIC Cursors Types. ABSOLUTE Fetch
  • LOCAL and GLOBAL Cursor Types & Scope, Reusability
  • KEYSET DRIVEN Cursor Types & Performance Options
  • Embedding Cursors in Procedures and User Functions
  • SPs with Cursors @ Dynamic Data Loads, Data Formatting

Video 3: TABLE DESIGN & QUERIES

  • Table Design - Creation. Columns - Data Types, Length
  • Routing Tables to Database File Groups, Advantages
  • Schemas - Purpose, Creation and Usage with Tables
  • Table Design using T-SQL Scripts - Syntax, Examples
  • Table Design using User Interface - Usage Options
  • Data Types, Length, NULLs and Naming Conventions
  • BATCH and TRANSACTION Concepts - Insert Examples
  • UNION, UNION ALL Operators. Differences, Row Order
  • CREATE, ALTER, DROP -- INSERT, UPDATE, DELETE
  • SELECT Queries with Schema on Tables, Column Aliases
  • T-SQL Data Types and NULL Values. Computed Columns
  • Database Log Files for DML - Logged, NonLogged Options
  • Comparing DELETE and TRUNCATE Statements - TLog Files
  • T-SQL Operators: IN, BETWEEN, IS, AND, OR, EXISTS
  • Default Schema and Default Filegroup for Table Design
  • Basic Sub Queries - SELECT, MIN/ MAX. Column Aliases
  • Temporary Tables : Purpose and Types. Local and Global
  • Synonyms : Purpose. Alternate Object Reference, Queries

Video 11: TRIGGERS & TRANSACTIONS (in detail: 2.5 hrs)

  • Triggers - Purpose and Types. Scope Of Usage
  • DML Triggers - Events, Types and Practical Usage
  • FOR / AFTER Triggers - Syntax, Usage and Importance
  • INSTEAD OF Triggers - Syntax, Usage and Importance
  • INSERTED & DELETED Memory Tables with DML Triggers
  • Triggers for Disabling DML Operations. Trigger Priority
  • Triggers for DML Audits, Data Sampling & Distribution
  • Database Level Triggers and Server Level Triggers, Audits
  • Triggers for Bulk Operations, Updatable Views (Indexed)
  • Triggers for Data Distribution and JOINS. Value Mapping
  • Performance Impact on Tables / Views - Precautions
  • ACID Properties and Transaction Types. Atomic Property
  • EXPLICIT, IMPLICIT Transactions - Query Blocking
  • IMPLICIT Transactions - Usage, Database Settings
  • AUTOCOMMIT Transactions - Advantages, Usage Examples
  • Nested Transactions and COMMIT / ROLLBACK Rules
  • SavePoint Options with Explicit Transactions, Rollbacks
  • LOCK HINTS : READPAST, NOLOCK, HOLDLOCK, Isolations

Video 4: CONSTRAINTS and KEYS

  • Constraints and Keys - Ensuring Table Data Integrity
  • Normal Forms - Types, Relational Database (RDB) Design
  • OLTP Database Model & BCNF - Relations with PK / UQ
  • NULL, NOT NULL and Default Nullability for Columns
  • UNIQUE KEY Constraints: Importance, Uniqueness, Nulls
  • PRIMARY KEY Constraint: Properties, Priority, Limitations
  • FOREIGN KEY Constraint: References, Relations & Usage
  • FOREIGN KEY Constraints : Relating Two or more tables
  • CASCADED Foreign Keys and Relations - UPDATE, DELETE
  • CHECK Constraints: Properties, Conditions and Usage
  • CHECK Constraints: Multi Column Checks & Operators Use
  • DEFAULT Constraints: Properties, Usage and Limitations
  • Relations with Tables across Multiple Schemas, Usage
  • Identity Property with / without PRIMARY KEY, Usage
  • Composite Primary Keys & Practical Use. Recommendations
  • Self Referencing Keys & Usage. Using Unicode References
  • Adding / Modifying Constraints, Keys and Data Types
  • Naming Conventions For Constraints, Columns and Tables
  • Normal Forms - Types, Purpose and Usage. With Examples
  • BCNF: Boycee-Codd Normal Form and Practical Usage

Video 12: INDEXES and QUERY TUNING OPTIONS

  • Indexes: Architecture (Page Level), Purpose and Types
  • Clustered Indexes - Architecture, Fragmentation Issues
  • Non Clustered Indexes - Architecture, Column References
  • SORT_IN_TEMPDB, FILLFACTOR and PAD_INDEX Options
  • Execution Plans and Query Optimization (QO) Techniques
  • Execution Plan - Table Scan, Index Scan and Index Seek
  • INCLUDED INDEXES - Purpose, Index Seeks, Query Tuning
  • COLUMN STORE Indexes - Advantages, Usage Examples
  • FILTERED Indexes - Sizing Advantages and Limitations
  • ONLINE Indexes and OFFLINE Indexes - UNIQUE Indexes
  • Indexes on Join Options - MERGE and LOOP Joins. Usage
  • Primary Key Index, Composite Indexes and Precautions
  • STATISTICS - Purpose and Types. Query Tuning Options
  • Column Statistics - Creation and Usage. Advantages
  • Index Statistics - Auto Creation with Indexes, Usage
  • STATISTICS with Indexes and Query Conditions. Updates
  • Materialized Views / Indexed Views - Tuning Options
  • Query Optimizer (QO) Options for Index Pages, Data Pages
  • Limitations of Indexes - Impact on DML and SELECT
  • Real-world Considerations For Indexes (Tables, Views)

Video 5: JOINS, SUB QUERIES & TUNING

  • JOINS - Purpose and Types, Use Case Scenarios
  • JOIN - Types, Queries and Importance of Reports
  • CROSS JOIN in detail. Examples and Conditions @ WHERE
  • INNER JOIN in detail. Examples with WHERE and ON
  • Comparing INNER JOIN with CROSS JOIN for Conditions
  • OUTER JOINS in detail. LEFT, RIGHT and FULL Joins
  • SELF JOINS with INNER / OUTER Joins. Usage Scenarios
  • JOINS with more than 2 tables. Syntax, Precedence Order
  • Query Tuning and Optimization with Schema References
  • HASH JOIN - Example, Scenario and Usage. HEAP Tables
  • MERGE JOIN - Example, Scenario and Usage. Priority
  • LOOP JOIN - Example, Scenario and Usage Limitations
  • JOIN Queries with Options and UNION, UNION ALL Operators
  • Basic Sub Queries and Joins. Alternate Syntax & Queries
  • A Real-world Case Study understanding Joins & Queries
  • End User Access to SQL Databases - Reporting Tools, Options
  • MS EXCEL, SSRS, POWER BI, SHAREPOINT, TABLEAU, etc..

Video 13: SQL SERVER ARCHITECTURE

  • Client - Server Architecture of SQL Server
  • SQL Server Tools - Connection Options, TDS Packets
  • Protocols : TCP / IP, Named Pipes, Shared Memory
  • SQL Native Client (SNAC) and OLE DB Drivers / Providers
  • ISO - OSI Model of Data Connections, Encrypted Data
  • Query Processing and Query Optimizer (QO) Components
  • SQL Server Architecture For Database Engine, LCM Options
  • Architecture - Query Processor and Storage Engine
  • Architecture - Query Parser, Optimizer, Mini LSN, MDAC
  • Architecture - SQL Engine, SQL Manager and Query Buffers
  • Architecture - Write Ahead Log (WAL), Lazy Writer Threads
  • Architecture - SQLOS Threads and Task Schedulers, CLR
  • SQL Database Architecture - RAID Levels (S/W, H/W)
  • Log Sequence Numbers (LSN) and Time Mapping. Audits
  • Log File Architecture - Virtual Log Files and Usage
  • Log File Architecture - Mini LSN & Degree Of Parallelism
  • DB Catalogs, CLR Integration and MDAC Components

Video 6: VIEWS - FUNCTIONS (LEVEL 1)

  • VIEWS - Benefits For Data Access, Table Operations
  • Defining Views on Tables - Syntax, Options, Uses
  • Views as Stored SELECT Statements, Data Access
  • SCHEMABINDING and ENCRYPTION Options - Advantages
  • Issues with Views For Data Validations - Solutions
  • Cascaded Views and WITH CHECK OPTION, Advantages
  • Orphan Views - Scenarios and Realworld Solutions
  • Common System Views For Metadata Access, Object IDs
  • Views on Multi Level Tables. Joins. Partitioned Views
  • Data Synchronization and Metadata Refresh with Views
  • Functions: Types, Purpose and Usage. Return Values
  • Scalar Value Returning Functions - Examples, Usage
  • Inline Table Value Returning Functions - Dynamic Joins
  • Multi-Line Table Value Returning Functions - Usage
  • Table Variables and Usage with Functions. Table Data Type
  • Variables and Parameters in SQL Server. Usage Differences
  • Dynamic Query Conditions with Functions. Return, Returns
  • SCHEMABINDING and ENCRYPTION Options with Functions

Video 14: REAL-TIME PROJECT (BANKING)

End-End Implemetation:
  • Phase 1: Understanding Project Requirement - Banking
  • Phase 1: Database Design with FileGroups, Schemas
  • Phase 1: Table Design with FileGroups, Schemas
  • Phase 1: Defining Constraints, Relations, Synonyms
  • Phase 2: Views for Data Inserts, Joined Queries
  • Phase 2: Common Reporting Functions, User Access
  • Phase 2: Queries for PIVOT, DENSE_RANK, PARTITION BY
  • Phase 2: INSERTS with PIVOT, Calculations, Sub Queries
  • Phase 3: End-to-End Implementation - Data Validations
  • Phase 3: Stored Procedures for Dynamic Data Inserts
  • Phase 3: Updatable Views and Triggers for DML, Indexes
  • Phase 3: ADVANCED, COMPLEX Stored Procedures in T-SQL
  • Phase 3: DB Documentation Tools, Deployment Options
  • 3rd Party Tools - Dell Litespeed for SQL Server 2014/2016
  • Reading Log Files and Data Audits & 3rd Party Tools
  • Transaction Audits and Offline Query Logs for SQL DEVs

Video 7: FUNCTIONS - QUERIES - VIEWS (LEVEL 2)

  • Queries with GROUP BY, HAVING, ON & WHERE
  • ROLLUP and CUBE - Sub Totals, Grand Totals, Aggregates
  • ROLLUP of Table Data. Column Aggregations. ORDER BY
  • CUBE on Table Data - Purpose & Usage. Permutations
  • Queries with GROUPING() Option in SELECT, Using HAVING
  • HAVING versus WHERE Conditions - Usage Differences
  • Query Execution Order with Joins, ORDER BY and ROLLUP
  • Important System Functions and Metadata. Object Name, IDs
  • Date and Time Functions, Date Format, Styles and DATEDIFF
  • SOUNDEX, DIFFERENCE, CASE, ISNULL, COALESCE Functions
  • CAST, CONVERT, TRY_PARSE, ROW_NUMBER, RANK Functions
  • PATINDEX, CHARINDEX,RTRIM/LTRIM, REVERSE Functions
  • CASE Statement (with/without Expressions), PIVOT Usage
  • MERGE Statement - MATCHED and NONMATCHED Operations
  • Miscellaneous System Functions and Dynamic Conditions
  • Using Views for Queries and Sub Queries with Functions
  • Real-time Case Study on Online Medicare Project
    - Joins, Functions, Sub Queries

Video 15: SQL Server 2014 & 2016 CERTIFICATION

  • Guidance for SQL Server T-SQL Certifications (MCSA - TSQL)
  • 70-461 Certification Pattern and Examples (Technical)
  • SQL Server Version Comparisions and Edition Differences
  • Latest Certification Questions & Exam Dumps - Explained
  • XML Data Type and XML Format. SELECT Query Options
  • XML Schemas with AUTO, RAW and PATH. Customized Tags
  • TRY..CATCH Versus RAISERROR. Common Issues
  • RANK, DENSE_RANK, ROW_NUMBER Functions. Comparisons
  • OVER with PARTITION BY columns. Pagination Concepts
  • Common Issues and Solutions with CTEs For Query Tuning
  • Full Text Search (FTS) Service - Purpose of FT Indexes
  • Full Text Catalogs and FT Options. Token Search Concepts
  • Inflectional Forms, CONTAINS(), FREETEXT() and Operators
  • Change Tracking Options, Query Performance Impact
  • Table Partitioning Concepts - Tuning Options, Uses
  • Partition Functions and Partition Schemes. Rebuild Options
  • Split, Merge Partitions. Real-time Considerations
  • Version & Edition Comparisons. New Features in SQL 2016

EVERY VIDEO IS COMPLETELY PRACTICAL. REAL-TIME. TASKS, MATERIAL, LAB WORK for EVERY VIDEO. 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 70-461 Exam
  • Interview Preperation & 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 2016
  • Multi Server Triggers, Views, CTEs & BLOB Data
  • In-Memory Tables and HASH Joins, Query Tuning
 

*Above curriculum applicable for registrations from May 13th, 2017.

 

Trainer: Mr. Sai Phanindra T, 11+ Years of expertise exclusively on SQL Server, SQL DBA and MSBI / DWH
Complete Profile of the Trainer @ here

 

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

 

 

Register for Free Demo on SQL Server / T-SQL Training Videos

 

Who can benefit from this T-SQL Video Training course?

This course is helpful for aspiring SQL Engineers, Developers, Database Testers, BI Analysts, DB Architects and .NET Professionals. This course helps in laying a strong fundamental base for MSBI / SSIS / SSAS / SSRS courses. 24x7 LIVE Server with Realtime databases and Free Online Lab included.

 

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 & T-SQL
SQL Server DBA
MSBI (SSIS, SSAS, SSRS)
 

Register Today

 

SSIS (with ETL, DWH)
SSAS (with MDX, DAX)
SSRS & Power View
 

Register Today

 

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google: 4.7/5

Facebook: 4.8/5

Sulekha: 4.8/5

JustDial: 4.7/5

MouthShut: 5/5

UrbanPro: 5/5

Yet5: 5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social