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
Preview00:10:22 -
T-SQL - Server Overview
Preview00:03:43 -
T-SQL - Environment Setup
Preview00:07:30 -
T-SQL - Data Types
Preview00: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
Preview00: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.