T-SQL Server

• Introduction of SQL Server
• Syntax of SQL Server
• DDL and DML Command
• Select Statement
• Select Statement with multiple operators
• Find Unique record by DISTINCT
• Apply filter bases on criteria using WHERE clause
• Where and Having clause
• AND, OR, NOT operators
• Ascending and Descending order by ORDER BY
• Insert value in table
• Update value in existing table
• Delete record from existing table
• Select top 5 records from table
• Select records by LIKE
• Wildcards for Single character and Multiple Characters
• Pass multiple parameters on single columns by IN
• Extract records between two records.
• Aliases of Tables and Fields
• SQL Joins (Inner Join, Left Join, Right Join, Full Join, Cross Join, Self Join)
• Combines the result by UNION and UNION ALL
• Create subset table by SELECT INTO
• SQL Insert into Select
• Create Database and Table
• SQL Constraints ( Not Null, Unique, Primary Key, Foreign Key, Check and Default, Identity)
• Create View
• Create Index
• Drop (Database, Table, Fields, Index, View)
• Alter (Table, Fields, View)
• SQL Datatype
• SQL Functions (AVG, COUNT, FIRST, LAST, MAX, MIN, SUM, GROUP BY, HAVING, UCASE, LCASE, MID, LEN,ROUND,NOW,DATE, GETDATE)
• SQL TRIGGER
• SQL PROCEDURE
• SQL CURSOR