Data-e-Education

SQL - Structured Query Language
01. About SQL Server	07. Constraints
History of SQL	Primary Key
History of SQL Server	Composite Key
Download and Install	Unique Key
Management Studio	Not Null
System Databases	Check Data
02. DDL Statements	Default Data
Maintain Database	Foreign Key
Files & Filegroups	08. SQL Joins
Create Database	Cross Join
Alter Database	Inner Join
Drop Database	Outer Join
Maintain Table	Left Outer Join
Create Table	Right Outer Join
Describe Table	Full Outer Join
Alter Table	Joins with Clause
Rename Table	Self Join
Truncate Table	ANSI Join
Drop Table	Alias Name
03. SQL Operators	09. Set Operators
Arithmetic Operators	Union Operator
Assignment Operator	Union All Operator
String Operator	Except Operator
Comparison Operators	Intersect Operator
Bitwise Operators	10. Logical Operators
Unary Operators	IS Operator
Compound Operators	NOT Operator
Scope Resolution Operator	IN Operator
04. SQL Data Types	ALL Operator
Numeric Data Types	ANY Operator
Character Data Types	SOME Operator
Date & Time Data Types	BETWEEN...AND Operator
Special Data Types	LIKE (Wild Card) Operator
05. DML Statements	11. SQL Subquery
Insert Records	Query with Clause
All Column(s)	Query with Operator
Particular Column(s)	Co-related Subquery
Random Column(s)	12. SQL View
Select Records	Create View
All Column(s)	Alter View
Particular Column(s)	Rename View
Combination of Column(s)	Delete View
Expression of Column(s)	WITH ENCRYPTION
Assignment Operator	WITH CHECK OPTION
TOP N Record(s)	@@ Rowcount Data
DISTINCT Record(s)	Use Built-in Function
DECODE Data by CASE	Data Partitioned Technique
Update Records	13. TCL Statements
Delete Records	BEGIN Transaction
06. SQL Clauses	COMMIT Transaction
Where Clause	AUTOCOMMIT Transaction
Order By Clause	ROLLBACK Transaction
Group By Clause	SAVE Transaction
Having Clause	@@TRANCOUNT Data
.	.
.	.
.	.
.	.

Programming in MS SQL Server 2012
01. Program Statements	05. Stored Procedure
Comment	Types of Stored Procedures
Variables	Simple Stored Procedure
Data Types	Create Stored Procedure
Boolean	Execute Stored Procedure
Integer	Display Stored Procedure
Binary	Rename Stored Procedure
Decimal	Delete Stored Procedure
Currency	Parameter and Data Types
Date Time	Input Parameter Data
Character	Default Parameter Data
Variant	NULL Parameter Data
Table Variable	Wildcard Parameter Data
Temporary Table	Output Parameter Data
Print Statement	Output Cursor Data
Begin ... End	Output Table Data
Conditional Statement	Define Option in Procedure
IF Statement	WITH RECOMPILE Option
CASE ... WHEN ...THEN	WITH ENCRYPTION Option
WHILE Statement	RETURN Option
BREAK and CONTINUE	Error Handling in Procedure
02. User Defined Function	@@ERROR
About User Defined Function	@@RAISE ERROR
Scalar User Defined Function	Nested Stored Procedure
Create Function	Stored Procedure Optimization
Execute Function	06. TRIGGER
Display Function	Create Trigger
Modify Function	Alter Trigger
Rename Function	Disable Trigger
Delete Function	Enable Trigger
Numeric Argument	Drop Trigger
Character Argument	INSTEAD OF Trigger
Date Time Argument	Limitation of Trigger
Decode Argument	07. Cursor
Inline Table-valued Function	Declare Cursor
Create Function	Open Cursor
Execute Function	Fetch Cursor
Multi Table-valued Function	Close Cursor
Create Function	Deallocate Cursor
Execute Function	@@FETCH_STATUS
03. Built-In Function	08. Index
Mathematical Functions	Pages and Extents
String Functions	Overview of Index
Date and Time Functions	Types of Indexes
Configuration Functions	Clustered Index
Metadata Functions	Nonclustered Index
System Functions	Unique Index
04. SET OPTION ON / OFF	Filtered Index
SET NOCOUNT	BITMAP Index
SET ROWCOUNT	Maintain Indexes
SET ANSI_NULLS	Fill Factor Option
SET DATEFORMAT	Index Defragmentation
SET STATISTICS IO	Reorganize Indexes
SET SHOWPLAN_ALL	Rebuild Indexes
SET SHOWPLAN_TEXT	Disable Index
SET IDENTITY_INSERT	Enable Index
SET QUOTED_IDENTIFIER	Drop Index
SET IMPLICIT_TRANSACTIONS	Index Optimization Technique

* * * * *

Your Comment To AUTHOR