Best Microsoft Sql Server Training Course in Delhi/NCR
Course Overview
What is SQL?
Create Statement
Create database
Create table
Use Identity
Select Statement
Insert statement
Update statement
Delete statement
Drop statement
Truncate statement
Difference between delete, drop & truncate
Alter Query
Clauses
Group By
Order By
Basic Queries
Inner Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Equi Join
Self Join
Primary Key
Foreign key
Unique
Check
Default
Not Nullv
Use Input and Output Type parameter in Stored Procedure
Types of Functions
Trigger
Cursor
Union & Union All
Transaction
Indexes
Views