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: 16 Videos (Duration: 90 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 Realtime 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?
  • Why SQL Server? Advantages and Usage
  • What is SQL? What is T-SQL? Why T-SQL?
  • Versions and Editions of SQL Server
  • Video Wise Plan, Material and Project Details
  • LAB PLAN - 24x7 LIVE Server (Online Lab)
  • How to install SQL Server - Step by Step
  • SQL Server 2016 Software Installation
  • SQL Server 2014 / 2012 Software Installation
  • H/W & S/W Requirements. Instance Configuration
  • Installation Errors, Solutions. Server Name Conventions
  • SQL Server Management Studio (SSMS) Tool    Register

Video 8: STORED PROCEDURES - LEVEL 1

  • Stored Procedures - Purpose and Usage
  • Variables - Need, Usage in Stored Procedures
  • Parameters - Need, Usage in Stored Procedures
  • Stored Procedures for Data Validations
  • Stored Procedures for Dynamic SQL Queries
  • Stored Procedures for Data Reporting
  • Important System Procedures For Metadata
  • Important Extended Procedures For App Access
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions
  • Error Handling Techniques: TRY, CATCH, THROW
  • Dynamic SQL Parameters and Variables
  • Default Parameter Values and Usage Types

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

  • Testing Installation, Understanding Server Connection
  • Defining New Sessions for Writing Queries
  • Basic SQL for Beginners. Introducing Databases, Tables
  • What is SQL? Why we need SQL? How to write Basic SQL?
  • DDL and DML Queries. SELECT Quries. DCL Options
  • Creating Databases (Basic Level) and Tables
  • How to Store/INSERT Data into Tables?
  • How to Verify/Retreive Data from Tables?
  • How to UPDATE Data and Structure of Tables?
  • How to DELETE & TRUNCATE Data? Remove Tables?
  • SYSTEM DATABASES - Purpose of each and Importance
  • CLIENT - SERVER Architecture (TDS) & Client Statistics    Register

Video 9: STORED PROCEDURES - LEVEL 2

  • Stored Procedures for Dynamic Sub Queries
  • Stored Procedures for Recursive Queries
  • OUTPUT Parameters and Nested Sub Queries
  • Common Table Expressions (CTE) & Uses
  • Using CTE & Data Retrieval in Stored Procs
  • Using CTE for DML in Stored Procedures
  • Using Recursive CTEs with Procedures
  • Precautions for Recursive CTEs, Performance
  • Query Tuning Operations with CTE Queries
  • CTE Limitations and Self Join Options
  • Dynamic SQL Queries & Parameters & Variables
  • Cached Plans & Memory for Stored Procedures
  • RECOMPILE Options and ENCRYPTION Options

Video 2: SQL SERVER DATABASE DESIGN

  • SQL Server Databases - Purpose and Design
  • Understanding SQL Database Architecture
  • Database Properties and Storage Options
  • Data Files : Sizing, Purpose and Usage
  • Filegroups : Placement, Purpose, Usage & Options
  • Log files : Sizing Recommendations and Placement
  • Database Creation Options using GUI - Limitations
  • Database Creation using T-SQL Scripts
  • Data File Locations and Sizing Recommendations
  • Filegrowth, Autogrowth and MAXSIZE Options
  • Planning & Designing Very Large Databases (VLDB)
  • Database Structure Modifications, ALTER Options
  • Adding New Filegroups and Files to Database

Video 10: STORED PROCEDURES - LEVEL 3

  • Parameter Sniffing and SQL Injection Issues
  • Table Value Parameters (TVP) & Table Types
  • User Defined Table Data Types & TVP Examples
  • Extended Stored Procedures - Options, Usage
  • Startup Stored Procedures - Configuration, Use
  • Working with Cursors and Stored Procedures
  • Cursor Types - Benefits, Purpose and Options
  • FORWARD_ONLY and SCROLL Cursors Types
  • STATIC and DYNAMIC Cursors Types & Queries
  • LOCAL and GLOBAL Cursor Types & Queries
  • KEYSET DRIVEN Cursor Types & Performance
  • Embedding Cursors in Procedures and UDFs
  • SPs with Cursors For Dynamic Data Loads

Video 3: TABLE DESIGN & QUERIES

  • Table Design - Defining and Creating Tables
  • Routing Tables to Database File Groups
  • Schemas - Purpose, Creation and Usage in Tables
  • Table Design using T-SQL Scripts - Variants
  • Table Design using GUI - Usage & Options
  • Naming Conventions for Table Columns
  • Single Row Inserts and Multi-Row Inserts
  • Table Aliases, Column Aliases and Usage
  • DDL, INSERT, UPDATE, DELETE Statements
  • SELECT Queries with Schema References
  • T-SQL Data Types and NULL Value Comparison
  • Role of Database Log Files for DML Operations
  • Design Limitations and Understanding UPDATES
  • Comparing DELETE and TRUNCATE Statements

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

  • Use of Triggers - Purpose and Scope
  • DML Triggers and Performance Impact
  • FOR / AFTER Triggers - Usage & Importance
  • INSTEAD OF Triggers - Usage & Importance
  • INSERTED and DELETED Memory Tables
  • Using Triggers for DML Audits, Data Sampling
  • Database Level Triggers , Server Level Triggers
  • Triggers for Bulk Operations, Updatable Views
  • Triggers for Data Distribution & JOINS
  • ACID Properties and Transaction Types
  • EXPLICIT, IMPLICIT Transactions - Query Blocking
  • IMPLICIT Transactions - Usage, DB Settings
  • AUTOCOMMIT Transactions - Advantages, Usage
  • Transactions Nesting & SavePoints, LOCK HINTS

Video 4: CONSTRAINTS and KEYS

  • Constraints and Keys - Purpose and Usage
  • Normal Forms and Relational Database Design
  • OLTP Database Model and BCNF - Relations
  • NULLABILITY Property and Importance
  • UNIQUE KEY Constraints and Importance
  • PRIMARY KEY Constraints and Limitations
  • FOREIGN KEY References and Relations
  • FOREIGN KEY Constraints - Rules & Limitations
  • Schema Level and Table Level Relations
  • CHECK Constraints - Usage & Limitations
  • DEFAULT Column Constraints and Usage
  • Identity Property with PRIMARY KEY
  • Composite Primary Keys and Recommendations
  • Constraints with Naming & Conventions

Video 12: INDEXES and QUERY TUNING OPTIONS

  • Indexes Architecture, Types and Purpose
  • Clustered Indexes - Architecture & Usage
  • Non Clustered Indexes - Architecture & Usage
  • Execution Plans & Query Optimization Techniques
  • Plan Types - Table Scan, Index Scan, Index Seek
  • SORT_IN_TEMPDB, FILLFACTOR, PAD_INDEX
  • INCLUDED Indexes, COLUMN STORE Indexes
  • FILTERED Indexes, ONLINE and OFFLINE Indexes
  • Indexes with JOIN Options, Merge and Loop Joins
  • Primary Key Index, Composite Indexes, Precautions
  • STATISTICS - Type and Purpose, Tuning Options
  • STATISTICS with Indexes and Query Conditions
  • Working with Materialized Views (Indexed Views)
  • Indexes For Query Tuning, Query Optimizer (QO)

Video 5: JOINS, SUB QUERIES & TUNING

  • Need for Joins and Use Case Scenarios
  • JOIN - Types, Queries and Usage
  • CROSS JOIN in detail. Examples and Scenarios
  • INNER JOIN in detail. Examples and Scenarios
  • OUTER JOINS in detail. Types and Scenarios
  • SELF JOINS in detail. Types and Scenarios
  • Combining JOIN Types - An Online Medical System
  • Query Tuning & Optimization Options
  • HASH JOIN - Example, Scenario and Usage
  • MERGE JOIN - Example, Scenario and Usage
  • LOOP JOIN - Example, Scenario and Usage
  • Basic Sub Queries and Joins. Alternate Syntax
  • End User Access to Queries - Options and Interfaces

Video 13: SQL SERVER ARCHITECTURE

  • Basic Architecture - Client/Server
  • ISO-OSI Model of Encrypted Data
  • Query Processing & Query Optimizer(QO)
  • SQL Server Architecture - Protocols & DB Engine
  • Architecture - Query Processor, Storage Engine
  • Architecture - Parser, Optimizer, Mini LSN, MDAC
  • Architecture - SQL Engine, SQL Manager, Buffers
  • Architecture - Write Ahead Log, Lazy Writer
  • Architecture - SQLOS Threads & Schedules, CLR
  • SQL Database Architecture - RAID Levels
  • Log File Architecture - Virtual Log Files
  • Log File Architecture - Mini LSN & DOP
  • Catalogs, CLR Integration & MDAC Components

Video 6: VIEWS - FUNCTIONS (LEVEL 1)

  • Benefit of Views in SQL Server Database
  • Defining Views on Tables and Views
  • Views as Stored SELECT Statements
  • SCHEMABINDING and ENCRYPTION Options
  • Issues with Views For Data Validations
  • Cascaded Views and WITH CHECK OPTION Usage
  • Orphan Views - Scenarios, Realworld Solutions
  • Common System Views and Metadata Access
  • Views on Multi Level Tables - Joined Queries
  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Returning Functions
  • Table Variables and Usage with Functions
  • Function Arguments - Usage and Options
  • SCHEMABINDING and ENCRYPTION Options

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, Possible Joined Queries
  • Phase 2: Common Reporting Functions, User Access
  • Phase 2: Queries for Pivot, DENSE_RANK, PARTITION BY
  • Phase 3: End-to-End Implementation - Data Validations
  • Phase 3: Using Stored Procedures for Data Inserts
  • Phase 3: Using Updatable Views and Triggers for DML
  • Phase 3: ADVANCED, COMPLEX Stored Procedures
  • Phase 3: DB Documentation Tools, Deployment Options
  • 3rd Party Tool - Dell Litespeed for SQL Server
  • Reading Log Files and Data Audits using 3rd Party Tools

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

  • Queries with GROUP BY Columns, HAVING Condition
  • Queries with GROUPING() Option in SELECT, HAVING
  • ROLLUP of Table Data. Column Aggregations
  • CUBE on Table Data - Purpose & Usage
  • HAVING versus WHERE Conditions - Differences
  • Query Execution Order with ORDER BY and ROLLUP
  • Important System Functions and Metadata Access
  • Date & Time, Date Format, Styles and DATEDIFF
  • SOUNDEX, DIFFERENCE, CASE, ISNULL, COALESCE
  • CAST, CONVERT, TRY_PARSE, ROW_NUMBER, RANK
  • String Functions and Character Settings. Usage
  • CASE Statement, MERGE Statement, PIVOT Functions
  • Miscellaneous System Functions and Performance
  • Using Views for Queries, Sub Queries with Functions
  • Real-time Case Study on Joins, Functions, Sub Queries

Video 15: SQL Server 2014 & 2016 CERTIFICATION

  • Guidance for SQL Server T-SQL Certifications
  • Certification Pattern and Examples (Technical)
  • Version Compares and Edition Compares
  • Mock Scenarios for SQL Server Certification
  • Temporal Tables in SQL Server 2016
  • New Data Types in SQL Server 2016
  • Stretch Databases and Performance
  • Full Text Search (FTS) Service - Purpose
  • Change Tracking Options, Performance Impact
  • BULK..INSERT, OPENROWSET, BLOB Data Storage
  • Sub Queries with Updates, RANK and DENSE_RANK()
  • New Authentication Modes in SQL 2016
  • Foundation to SQL 2016 Certifications
  • Upgradation Paths from SQL 2014 Certification
  • Upgradation Paths from SQL 2012 Certification

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 JANUARY 6th, 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

 

Register Today For Free Demo