T-SQL Online Training

Simply Easy Learning

Created by Anadi Sharma, Last Updated 05-Aug-2019, Language:English

Description

T-SQL (Transact-SQL) is an extension of SQL language from Microsoft. This video tutorial covers the fundamental concepts of T-SQL starting from its basics to advanced covering DML, DDL, and DQL including various functions, procedures, indexes, and transactions. Each topic has been explained using appropriate practical example for easy understanding.

Audience

This video training has been prepared for the beginners to help them understand the basic to advanced concepts related to T-SQL language.

Course Content

T-SQL Basics

5 Lectures 00:39:40
- T-SQL - Overview
  
  Preview
  
  00:10:22
- T-SQL - Server Overview
  
  Preview
  
  00:03:43
- T-SQL - Environment Setup
  
  Preview
  
  00:07:30
- T-SQL - Data Types
  
  Preview
  
  00:05:59
- T-SQL - Getting Started
  
  00:12:06
T-SQL DQL Statements

12 Lectures 01:27:57
- T-SQL - Select Statement
  
  00:06:57
- T-SQL - Using Expressions
  
  00:06:30
- T-SQL - Top Keyword
  
  00:02:09
- T-SQL - DISTINCT Keyword
  
  00:02:45
- T-SQL - Operators
  
  00:14:42
- T-SQL - Sorting Data
  
  00:06:15
- T-SQL - Subqueries
  
  00:11:12
- T-SQL - Correlated Subqueries
  
  00:04:43
- T-SQL - Joins
  
  00:14:35
- T-SQL - Set Operators
  
  00:06:23
- T-SQL - Group Functions
  
  00:04:23
- T-SQL - Group By Clause
  
  00:07:23
T-SQL DDL Statements

6 Lectures 00:23:10
- T-SQL - DDL Statements
  
  00:04:06
- T-SQL - Create Table
  
  00:04:45
- T-SQL - Alter Table
  
  00:04:56
- T-SQL - Drop Table
  
  00:01:28
- T-SQL - CHECK Constraints
  
  00:04:36
- T-SQL - Truncate Table
  
  00:03:19
T-SQL DML Statements

4 Lectures 00:15:43
- T-SQL - DML Statements
  
  00:01:18
- T-SQL - Insert Statement
  
  00:06:03
- T-SQL - Delete Statement
  
  00:02:12
- T-SQL - Update Statement
  
  00:06:10
T-SQL Constraints

5 Lectures 00:22:52
- T-SQL - Constraints
  
  Preview
  
  00:04:28
- T-SQL - Primary Key Constraints
  
  00:04:00
- T-SQL - NOT NULL Constraints
  
  00:03:09
- T-SQL - UNIQUE Constraints
  
  00:05:52
- T-SQL - Foreign Key Constraints
  
  00:05:23
T-SQL Advanced

12 Lectures 01:42:19
- T-SQL - Using Index
  
  00:06:54
- T-SQL - Using Views
  
  00:13:44
- T-SQL - Introduction
  
  00:03:43
- T-SQL - Getting Started - 2
  
  00:06:01
- T-SQL - Conditional Statement
  
  00:05:40
- T-SQL - Loops
  
  00:04:54
- T-SQL - Exception Handling
  
  00:05:09
- T-SQL - Transactions
  
  00:12:04
- T-SQL - Cursors
  
  00:10:06
- T-SQL - Stored Procedures
  
  00:09:10
- T-SQL - Stored Functions
  
  00:04:32
- T-SQL - Triggers
  
  00:20:22

Anadi Sharma

Anadi Sharma is an MCA from Chhatrapati Shahu Ji Maharaj University, Kanpur. He holds international certifications like MCSD and OCA. Anadi has more than 8 years of experience in IT and Corporate training. He has delivered corporate training for clients such as TCS, Yamaha, IBM, where he taught .NET, Sql Server, and Oracle related technologies.