MS SQL SERVER
- Introduction
- What is SQL?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- What is ACID ?
- What is Normalization?
- Constraints
- Table
- Columns
- Data Types
- Table Related Commands (Alter / Drop)
- Table Join
- Inner Join
- Left join
- Right Join
- Cross Join
- Uses
- Practical(Demo)
- Index
- Introduction
- Types of Index
- Uses
- Practical(Demo)
- Queries
- Select
- Insert
- Update
- Delete
- Truncate Table
- Uses
- Practical(Demo)
- SubQuery
- Introduction
- Uses
- Practical(Demo)
- Dynamic SQL
- Introduction
- Uses
- Practical(Demo)
- Views
- Introduction
- Uses
- Practical(Demo)
- Function
- Introduction
- Uses
- Practical(Demo)
- Store Procedure
- Introduction
- Uses
- Practical(Demo)
- Triggers
- Introduction
- Uses
- Practical(Demo)
- Cursor
- Introduction
- Uses
- Practical(Demo)
- SQL Server Profiler
- Introduction
- Uses
- Practical(Demo)
- Creating users and Roles
Fees: Rs.5,000/- | Duration: 15 hours
- Introduction
- What is SQL?
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- What is ACID ?
- What is Normalization?
- Constraints
- Table
- Columns
- Data Types
- Table Related Commands (Alter / Drop)
- Table Join
- Inner Join
- Left join
- Right Join
- Cross Join
- Uses
- Practical(Demo)
- Index
- Introduction
- Types of Index
- Uses
- Practical(Demo)
- Queries
- Select
- Insert
- Update
- Delete
- Truncate Table
- Uses
- Practical(Demo)
- SubQuery
- Introduction
- Uses
- Practical(Demo)
- Dynamic SQL
- Introduction
- Uses
- Practical(Demo)
- Views
- Introduction
- Uses
- Practical(Demo)
- Function
- Introduction
- Uses
- Practical(Demo)
- Store Procedure
- Introduction
- Uses
- Practical(Demo)
- Triggers
- Introduction
- Uses
- Practical(Demo)
- Cursor
- Introduction
- Uses
- Practical(Demo)
- SQL Server Profiler
- Introduction
- Uses
- Practical(Demo)
- Creating users and Roles
Fees: Rs.5,000/- | Duration: 15 hours