Tutorialspoint
Subscription Includes
 04:51:41 of High Quality Videos
 44  Lectures
 Full Lifetime Access
 Certificate on Completion
$ 178   9.99

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.

More Courses from Anadi Sharma