SQL SERVER

Introduction to Data Store

  • Different types of storing Data
    1. Books & papers
    2. Data files
    3. Database

Introduction to DBMS

  1. Understanding Data Storage in HDBMS
  2. Understanding Data Storage in NDBMS
  3. Introduction to RDBMS
    • Understanding CODD Rules
    • Understanding SEQUEL
    • Normalization

Introduction to SQL SERVER

  1. What is Data Base?
  2. What is Table?
  3. SQL Commands
    • Data Definition Language
    • Data Manipulation Language
    • Data Control Language
    • Transaction Control Language
  4. Data types in SQL server
  5. Types of Constraints
    • Primary key
    • Foreign key
    • Unique
    • Not null
    • Check
  6. SQL Functions
    • Mathematical Functions
    • String Functions
    • Date & Time Functions
    • Conversion Functions
    • Group Functions
  7. Operators
    • Arithmetic operators
    • Assignment operators
    • Comparison operators
    • Logical operators
    • Concatenation operators
  8. Types of CLAUSES
    • Where
    • Group by
    • Having
    • Order by
  9. SUBQUERIES
    • Single row sub queries
    • Multi row sub queries
    • Correlated sub queries
  10. JOINS
    • Equi-joins
    • Non equijoin
    • Self join
    • Cartesian join
    • Outer joins
  11. Transactions
    • Commit
    • Rollback
    • Save Transaction
  12. Creating tables from existing tables
  13. Views
    • Creating views
    • Altering views
    • Types of views
    • Simple view
    • Complex view
  14. Indexes
    • Clustered Index
    • Non clustered Index
    • Creating indexes
    • Modifying indexes
    • Dropping indexes

Introduction to T-SQL

  1. Understanding the structure of programming in T-SQL
  2. Writing programs using T-SQL
  3. Control Statements If, if-else, while, case
  4. Understanding Cursors
    • Types of Cursors
    • Creating cursors

Introduction to sub-Programs

  • Writing procedures
    • Handling Errors in procedures
    • Transaction Management in procedures
  • Writing user-Defined Functions
  • Writing Triggers1
    • Types of Triggers
    • DML and DDL Triggers
    • Instead of triggers
    • Altering and Dropping Triggers

    Sql server 2008 Features

    1. Enterprise Data Platform
    2. Encryption
    3. Auditing
    4. Data compression
    5. Resource Governor
    6. Performance Data
    7. Dynamic Development
    8. Entity Data service
    9. LINQ
    10. Data synchronizing features
    11. Large UDT
    12. Data and time data type
    13. Files stream
    14. Spatial data
    15. Table value parameter
    16. Full text search
    17. Reporting server
    18. Merge command
    19. Exporting report directly to Microsoft office 2007