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. Special 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 Sub-Query
Insert Records	Query with Clause
All Column(s)	Query with Operator
Particular Column(s)	Co-related Sub-Query
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 Build 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	Maintain Error
About User Defined Function	@@RAISE ERROR
Scalar User Defined Function	Nested Stored Procedure
Create Function	Convert Procedure - Function
Modify Function	06. TRIGGER
Execute Function	Create Trigger
Display Function	Execute Trigger
Rename Function	Display Trigger
Delete Function	Rename Trigger
Numeric Argument	Delete Trigger
Character Argument	Data Integrity Trigger
Date Time Argument	INSTEAD 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. Build-In Function	08. Index
Mathematical Functions	Overview of Index
String Functions	B-Tree Index
Date and Time Functions	Clustered Index
Configuration Functions	Non-Clustered Index
Metadata Functions	Unique Index
System Functions	Composite Index
04. SET OPTION ON / OFF	BIT Map Index
ANSI_NULL	Maintain Index
NOCOUNT	Disable Index
ROWCOUNT	Rebuild Index
STATISTICS IO	Drop Index
SHOWPLAN_ALL	Optimization Technique
SHOWPLAN_TEXT	09. MS SQL Server Profiler
QUOTED_IDENTIFIER	About Profiler Application

* * * * *

Your Comment To AUTHOR