TSQL Training

TSQL Online Training

Introduction

  • Introduction about database
  • The Sample Database
  • Creating the Sample Table, Data
  • Viewing Sample Table, Data

Data Definition Language

  • Categories of SQL Statements
  • The CREATE Statement
  • The DROP Command
  • The ALTER Command

Data Manipulation Language

  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement

Transaction Control Language

  • Transactions
  • Command Classification
  • The SET TRANSACTION Command

SQL Data Types

  • Different types of SQL data types and its uses.

SQL Constraints and Operators

  • Constraints
  • Comparison Operators
  • IN and NOT IN Operators
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL

SQL Functions

  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Aggregate Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions

Joining Tables

  • Joins
  • Inner Joins
  • Outer Joins
  • Cross Join

Set Operators

  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus

SQL Sub queries & Correlated Queries

  • Introduction
  • Typical Sub queries
  • Correlated Sub queries
  • CTE

Groups

  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement

Stored Procedure

  • Create a stored procedure
  • Alter a stored procedure
  • Drop a stored procedure
  • Parameter declaration
  • Uses

View

  • Create a view
  • Alter a view
  • Drop a view
  • Uses

User Defined Functions

  • Create functions
  • Alter Functions
  • Drop Functions
  • Uses

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message