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
              Fetch Cursor
    Multi Table-valued Function     Close Cursor
         Create Function     Deallocate Cursor
              @@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

* * * * *


Email Your Comment To AUTHOR