SQL Server Training Videos
 

SQL Server & T-SQL Video Training

On-demand SQL Server Training Videos at your comfortable timings. Our SQL Server Video Training Service (Course Code: VC01) contains carefully designed videos on complete practical scenarios with LIVE examples. Study Material, Practice Material and Free LIVE Server Access available for Online Lab included for every video you access! Register for T-SQL Video Training

 
SQL Server & T-SQL 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 2014 & 2016

Type: 100% Practical & Example Based, Real-time
No. of Videos: 16 Videos (Duration: 85 mins per video)
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
  • Two 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 (9+ Yrs Exp, MCT)

 

 

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

Video 1: SQL Server Introduction & Installation

  • SQL Server 2016 Software Installation
  • SQL Server 2014 Software Installation
  • Planning H/W & S/W Requirements
  • .NET Framework and Software Prerequisites
  • Windows Management Instrumentation (WMI)
  • Configuration Checker Tool (pre-install)
  • Instance Naming and Service Accounts
  • Server Components - Installation & Purpose
  • Shared Features and Client Components
  • Services and Service Accounts (Windows Level)
  • Authentication Modes & User Connections
  • Management Studio (SSMS) Tool - Purpose & Usage
  • Testing Installation Components and Connections

Video 9: Stored Procedures, Queries & CTE

  • Stored Procedures - Purpose and Usage
  • Use of Variables & Parameters (IN / OUT)
  • Stored Procedures for Data Validations
  • Stored Procedures for Dynamic Queries
  • Stored Procedures for Data Reporting
  • System Procedures For Metadata Access
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions
  • RECOMPILE Options and Execution Plans
  • Common Table Expressions (CTE) & Uses
  • Using CTE for Data Retrieval and Updates
  • CTE Usage and Performance Considerations
  • Dynamic SQL Queries and Parameters & Variables
  • OUTPUT Parameters in Stored Procedures - Usage

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: Triggers and Memory Limitations

  • 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 Audit Operations
  • Using Triggers for Data Sampling Operations
  • Database Level Triggers , Server Level Triggers
  • Using Triggers for Bulk Operations (DML)
  • Using Triggers for Updatable Views (Cascade)
  • Using Triggers for Data Distribution Operations
  • Considerations for Triggers with Joined Queries
  • Memory Limitations and Performance with Triggers

Video 3: Table Design & Simple 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: Cursors and Queries

  • Need for Cursor Variables in T-SQL Queries
  • Cursor Variables in Queries & Data Access
  • Cursor Variables for Record Level Iterations
  • Cursor For Dynamic SQL Programming Design
  • 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 and Performance
  • Stored Procedures with Transactions & Cursors
  • Embedding Cursors in Procedures and UDFs
  • SPs with Cursors For Dynamic Data Loads
  • Deciding Table Variables versus Temp Tables

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
  • Use of FOREIGN KEY References and Relations
  • FOREIGN KEY Constraints - Rules and 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: Transactions and Save Points

  • ACID Properties and Transaction Types
  • EXPLICIT Transaction Types and Usage
  • IMPLICIT Transactions Types and Options
  • AUTOCOMMIT Transactions - Advantages, Usage
  • Transactions Nesting - Need and Precautions
  • SAVEPOINTS in Transactions - Rules and Usage
  • ATOMOCITY with SavePoints, Inner Transactions
  • Transactions - Scope, Usage Parameters
  • Transactions - Conditional Commits
  • Transactions and Query Blocking Scenarios
  • Lock Hints - NOLOCK and READPAST
  • Need for Transaction Isolation Levels
  • Isolation Levels - Usage and Examples
  • Database Diagrams and Object Scripting Options

Video 5: Views, Joins and Queries

  • 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
  • Limitations & Real-world Considerations
  • Database Diagrams and Entity Relations
  • INNER JOIN and Table Intersection Operations
  • OUTER JOINS, Types with Table Comparisons
  • CROSS JOIN, Alternatives and Usage
  • Views on Multi Level Tables - Joined Queries

Video 13: SQL Server Architecture

  • Basic Architecture - SQL Server over Client/Server
  • ISO-OSI Model of Encrypted Data Communication
  • SQL Server Architecture - Batch and Client Stats
  • SQL Server Architecture - Protocols and DB Engine
  • TDS Packets - Tabular Data Stream Packets & Sizing
  • Client Server Architecture - Detailed
  • TCP/IP, Named Pipes, Shared Memory
  • TDS Packets and Network Options
  • Storage Architecture, Transaction, IO
  • Parser, Optimizer, Mini LSN [Log Sequence Number]
  • Write Ahead Log, Lazy Writer Threads
  • SQL Engine and SQL Manager @ Query
  • SQLOS and Thread, Log Schedulers
  • SQL Database Architecture - Files and Filegroups

Video 6: Queries & Joins

  • MERGE Operations - Benefits and Usage
  • TARGET and NOT MATCH Clauses with MERGE
  • Conditions and Comparisions with MERGE
  • Query Joins in Updates and Deletes
  • Working with SET Options and Joins
  • NOCHECK Options in Constraints, Limitations
  • Table Comparison Options and Advantages
  • Use of GO statement in Batch Scope
  • Nested Queries - Benefits and Usage
  • Sub Queries, Nested Queries and Usage
  • Temporary Tables and Object Types
  • Multi Value Insert Statements in T-SQL
  • Synonyms - Creation, Purpose and Usage
  • Synonyms - Joins, Usage & Limitations

Video 14: XML, BLOB and Full Text Search

  • Gearing towards Microsoft 70-461 Certification
  • XML Data Storage and Sub & Nested Sub Queries
  • XML Operations on Views and Synonyms
  • Working with XML Data and Custom ROOT & PATH
  • Error Handling and Events : RAISEERROR and THROW
  • Sub Queries with Updates, RANK and DENSE_RANK()
  • Common Table Expressions (CTE) and Tuning Issues
  • Avoiding Self Joins with CTEs - Query Tuning
  • Full Text Search (FTS) Service - Purpose & Usage
  • Full Text Search and Change Tracking Options
  • Storing BLOB / CLOB Data (Docs, Pdf)
  • BULK..INSERT Commands - Options
  • OPENROWSET and Bulk Data Loads
  • Performance Impact - FTS and XML Queries

Video 7: User Defined Functions and Joins

  • Functions: Types, Purpose and Usage
  • Scalar Value Returning Functions - Usage
  • Inline Table Value Returning Functions
  • Multi-line Table Value Returning Functions
  • Data Generation - Functions, Table Variables
  • Function Arguments - Usage and Options
  • SCHEMABINDING and ENCRYPTION Options
  • Using System Functions and Metadata Access
  • Date Functions, CAST and CONVERT() Styles
  • CROSSAPPLY and GROUP BY Operations
  • HAVING versus WHERE Conditions in SELECT
  • ROW_COUNT, GROUPING and ROLLUP Functions
  • ELSE .. IF, WHILE and Iteration Loops
  • Joins - Table Variables, Views and Functions

Video 15: New Features of SQL Server 2016

  • New Add-ons in SQL Server 2016
  • Temporal Tables in SQL Server 2016
  • New Data Types in SQL Server 2016
  • New System Functions and Usage
  • New System SPs and Metadata Audit
  • Stretch Databases and Peroformance
  • Query Store Operations and Usage
  • Common Table Expressions (CTE) in 2016
  • Memory Tables and Usage
  • New Authentication Modes in SQL 2016
  • Foundation to SQL 2016 Certifications
  • Upgradation Paths from SQL 2014
  • Upgradation Paths from SQL 2012
  • Upgradation Paths from SQL 2008

Video 8: Indexes and Query Tuning

  • Indexes Architecture, Types and Purpose
  • Clustered Indexes - Architecture & Usage
  • Non Clustered Indexes - Architecture & Usage
  • Defining Indexes on Table Columns With Options
  • Execution Plans - Table Scan and Index Scan
  • Index Seek and Multi Level Index Options
  • SORT_IN_TEMPDB Option and Fill Factor Option
  • INCLUDED Column Indexes & Query Optimizer
  • Working with Materialized Views(Indexed Views)
  • Constraints with Indexes - Understanding & Usage
  • Indexes for Joins, WHERE and UNIQUE Constraints
  • Using Indexes while Querying Views in Real-time

Video 16: Solutions to all tasks from above videos

  • Features, Comparisions - SQL Server 2012, 2014, 2016
  • Solutions to T-SQL Video 1 Tasks
  • Solutions to T-SQL Video 4 Tasks
  • Solutions to T-SQL Video 5 Tasks
  • Solutions to T-SQL Video 6 Tasks
  • Solutions to T-SQL Video 7 Tasks
  • Solutions to T-SQL Video 8 Tasks
  • Solutions to T-SQL Video 9 Tasks
  • Solutions to T-SQL Video 10 Tasks
  • Solutions to T-SQL Video 11 Tasks
  • Solutions to T-SQL Videos 12,13 Tasks
  • No Tasks applicable for Videos 2, 3, 13, 14
 

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 OCTOBER 25th, 2016.

 

Trainer: Mr. Sai Phanindra T, 10+ 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

 

 
SQL Server T-SQL Video Training

SQL School

SequelGate (I) Technologies Pvt. Ltd.
#108/2RT, Road No: 1, Beside Bus Stop,
SR Nagar, Hyderabad - 38 (India). Map

contact@sqlschool.com
+91-9666440801 (INDIA)
+91-9542916779 (INDIA)
+91-(0)40 64577244 (INDIA)
+1-510-400-4845 (USA/Canada)
 

 

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

Register Today For Free Demo