TSQL Online Training - callus +919000444287

TSQL Online Training

Click Here For Enquiry

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