RDBMS using SQL Server
Module 1
1. Introduction To SQL Server
- Server Type
- Server Name
-
Authentication Modes
- Sql Server Authentication Mode
- Windows Authentication Mode
- Login and Password
Module 2 - TSQL (Transact-Structured Query Language)
2. Introduction To TSQL
- History and Features of TSQL
-
Types Of TSQL Commands
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)
-
Database
- Creating Database
- Altering Database
- Deleting Database
-
Constrains
- Procedural Integrity Constraints
-
Declarative Integrity Constraints
- Not Null, Unique, Default and Check constraints
- Primary Key and Referential Integrity or foreign key constraints
- Data Types In TSQL
-
Table
- Creating Table
- Altering Table
- Deleting Table
Module 3
3. Data Manipulation Language
-
Insert
- Identity
- Creating A Table From Another Table
- Inserting Rows From One Table To Another
-
Update
- Computed Columns
-
Delete
- Truncate
- Differences Between Delete and Truncate
Module 4
4. Data Query Language (DQL)
- Select
- Where clause
- Order By Clause
- Distinct Keyword
- Isnull() function
- Column aliases
-
Predicates
- Between … And
- In
- Like
- Is Null
Module 5
5.
-
Scalar Functions
- Numeric Functions
- Character Functions
- Conversion Functions
- Date Functions
-
Aggregate Functions
- Convenient Aggregate Functions
- Statistical Aggregate Functions
- Group By and Having Clauses
- Super Aggregates
- Over(partition by …) Clause
-
Ranking Functions
- Common Table Expressions (CTE)
Module 6 Top n Clause
6. Set Operators
- Union
- Intersect
- Except
Module 7
7. Joins
-
Inner Join
- Equi Join
- Natural Join
- Non-Equi Join
- Self Join
-
Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Cross Join
Duration Course
- 3 Months
