SQL - Structured Query Language

Programming in MS SQL Server 2008

01. About SQL Server
     History of SQL
     History of SQL Server
     Download and Install
     Management Studio
     System Databases
02. DDL Statements
     Maintain Database
          Files & Filegroups
          Create Database
          Alter Database
          Drop Database
     Maintain Table
          Create Table
          Describe Table
          Alter Table
          Rename Table
          Truncate Table
          Drop Table
03. SQL Operators
     Arithmetic Operators
     Assignment Operator
     String Operator
     Comparison Operators
     Bitwise Operators
     Unary Operators
     Compound Operators
     Scope Resolution Operator
04. SQL Data Types
     Numeric Data Types
     Character Data Types
     Date & Time Data Types
     Special Data Types
05. DML Statements
     Insert Records
          All Column(s)
          Particular Column(s)
          Random Column(s)
     Select Records
          All Column(s)
          Particular Column(s)
          Combination of Column(s)
          Expression of Column(s)
          Assignment Operator
          TOP N Record(s)
          DISTINCT Record(s)
          DECODE Data by CASE
      Update Records
      Delete Records
06. SQL Clauses
     Where Clause
     Order By Clause
     Group By Clause
     Having Clause

07. Constraints
     Primary Key
     Composite Key
     Unique Key
     Not Null
     Check Data
     Default Data
     Foreign Key
08. SQL Joins
     Cross Join
     Inner Join
     Outer Join
          Left Outer Join
          Right Outer Join
          Full Outer Join
     Joins with Clause
     Self Join
     ANSI Join
     Alias Name
09. Set Operators
     Union Operator
     Union All Operator
     Except Operator
     Intersect Operator
10. Special Operators
     IS Operator
     NOT Operator
     IN Operator
     ALL Operator
     ANY Operator
     SOME Operator
     BETWEEN...AND Operator
     LIKE (Wild Card) Operator
11. SQL Sub-Query
     Query with Clause
     Query with Operator
     Co-related Sub-Query
12. SQL View
     Create View
     Alter View
     Rename View
     Delete View
     WITH ENCRYPTION
     WITH CHECK OPTION
     @@ Rowcount Data
     Use Build in Function
     Data Partitioned Technique
13. TCL Statements
     BEGIN Transaction
     COMMIT Transaction
     AUTOCOMMIT Transaction
     ROLLBACK Transaction
     SAVE Transaction
     @@TRANCOUNT Data

01. Program Statements
     Comment
     Variables
     Data Types
          Boolean
          Integer
          Binary
          Decimal
          Currency
          Date Time
          Character
          Variant
          Table Variable
          Temporary Table
     Print Statement
     Begin ... End
     Conditional Statement
          IF Statement
          CASE ... WHEN ...THEN
          WHILE Statement
          BREAK and CONTINUE
02. User Defined Function
     About User Defined Function
     Scalar User Defined Function
          Create Function
          Modify Function
          Execute Function
          Display Function
          Rename Function
          Delete Function
          Numeric Argument
          Character Argument
          Date Time Argument
          Decode Argument
     Inline Table-valued Function
          Create Function
          Execute Function
     Multi Table-valued Function
          Create Function
          Execute Function
03. Build-In Function
     Mathematical Functions
     String Functions
     Date and Time Functions
     Configuration Functions
     Metadata Functions
     System Functions
04. SET OPTION ON / OFF
     ANSI_NULL
     NOCOUNT
     ROWCOUNT
     STATISTICS IO
     SHOWPLAN_ALL
     SHOWPLAN_TEXT
     QUOTED_IDENTIFIER

05. Stored Procedure
     Types of Stored Procedures
     Simple Stored Procedure
          Create Stored Procedure
          Execute Stored Procedure
          Display Stored Procedure
          Rename Stored Procedure
          Delete Stored Procedure
     Parameter and Data Types
          Input Parameter Data
          Default Parameter Data
          NULL Parameter Data
          Wildcard Parameter Data
          Output Parameter Data
          Output Cursor Data
          Output Table Data
     Define Option in Procedure
          WITH RECOMPILE Option
          WITH ENCRYPTION Option
          RETURN Option
     Error Handling in Procedure
          Maintain Error
          @@RAISE ERROR
     Nested Stored Procedure
     Convert Procedure - Function
06. TRIGGER
     Create Trigger
     Execute Trigger
     Display Trigger
     Rename Trigger
     Delete Trigger
     Data Integrity Trigger
     INSTEAD OF Trigger
07. Cursor
     Declare Cursor
     Open Cursor
     Fetch Cursor
     Close Cursor
     Deallocate Cursor
     @@FETCH_STATUS
08. Index
     Overview of Index
     B-Tree Index
          Clustered Index
          Non-Clustered Index
          Unique Index
          Composite Index
     BIT Map Index
     Maintain Index
          Disable Index
          Rebuild Index
          Drop Index
     Optimization Technique
09. MS SQL Server Profiler
     About Profiler Application

Your Comment To AUTHOR