1. Introduction:

• DBMS.
• Different Database Models.
• Features of Relational Model.
  
              Database Design:
              E-R Modeling
             
  2. Normalization/Normal Forms:

• 1N-F.
• 2N-F.
• 3N-F.
• BCNF.

            History of Microsoft SQL Server.
            Features of SQL server 2000 & 2005.
           
3. Introduction to SQL server architecture:

• Relational Engine.
• Storage Engine.
• Open Data Source (ODS).

            4. SQL server components:

• Enterprise Manager.
• Query Analyzer.
• ISQL/OSQL.
• Service Manager.

            5. SQL Server Databases.

• System Databases.
• User Databases.
• Creating Databases.
  
    6. Structured Query language (SQL):

• Data Types.
• User defined data types.
• Predefined Data Types.
• Operators.
• SQL commands.
• DDL.
• DML.
• DCL.

            7. Data Integrity:                                    Top

• Data Integrity.
• Entity Integrity.
• Referential Integrity.
• Rules and Defaults.

            8. Functions:

• Scalar functions.
• Aggregate Functions.
• Row set functions.
• DW functions (cube, rollup).

           
            9. Sub Queries:
           

• Query Processing Techniques.
• Single Row Sub Queries.
• Multi Row Sub Queries.
• Correlated Sub Queries.

            10. Joins:
           

• Cross join.
• Inner join.
• Self join.
• Outer join.

            11. Advantages of views:

• Creating views.
• Creating view with check option.
• Altering a view.
• Dropping a view.
• Working With Indexed Views.

            12. Indexes:                                    Top

• Need for creation of index.
• Clustered index.
• Non-clustered index.
• Unique index.
• Composite Index.
• Execution plan of SQL statement.

            13. SQL server programming:

• Overview
• Batches
• Using Local& Global Variables
• Using of print Statements
• Programming Constructs
• Begin….End
• If………Else
• Case Structure
• While Loop

           
            14. Cursors
            Types of Cursors
            Different States of Curser

• Define
• Open
• Fetch
• Close
• Deal locate
  
              15. Stored Procedure                               Top

• Creation of Stored Procedure
• Passing Arguments
• Advantages of Scope in Real time Apps.
• Modifying a Sorted Procedure.
• Dropping a Sorted Procedure.
• Programming in Stored Processors.

            16. Transact SQL (T-SQL):
             Functions:

            17. Triggers:

• Types of Triggers.
• Define a Trigger.
• Altering a Trigger.
• Nested a Trigger.
• Dropping a Trigger.
  
      18. Transactions and Locks:

• Transactions and Locking Architecture.
• Managing SQL Server Transaction.
• Managing SQL Server Locking.

            19. Database Backups
            Export/Import:                                             Top

• Using BCP.
• DTS.

            20. Retrieving XML Data:

• Using For XML.
• RAW, AUTO.
  
   21. SQL 2005 SQL Server Features:

• Introducing SQL Server Management
• Studio.
• Ranking Functions.
• New Data Types.
• The With Clause.
• Recursive Queries. 
• New Operators.
• (SOME, ANY, ALL, SET Operator)
  
  22. Pivot & Un-Pivot Apply:

• Merge (up set) Command.
• Top Clause, Output Clause.
• Exception Handling.
• XML Integration.
• User-Defined Aggregates.
• User-Defined Data Types.
• NEW DDLs.
• User Management.

            23. Service Broker:

• Reporting Services.
• Designing & Naming Reports.
• Reports Definition Language.
• Replication.

             24. DAB Concepts:

• Scheduling jobs.
• Backup and Recovery.
• Index Maintenance.
• Archiving Data.