Courses Offered :
Testing Tools      PeopleSoft      Oracle Technologies      SQL DBA / MSBI      DBA/App’s      Data Warehousing      Android / iPhone      OBIEE, Data Stage      SOA Testing      Main Frames      DBA Technologies      SAS      Database / ETL Testing      SAP All Modules      SOA Testing      Micro Soft Technologies      JAVA      

SQL SERVER

    • Basics of DBMS
    • Basics of RDBMS
    • Data Models
    • What is SQL server
    • Introduction to SQL Server 2005
    • Tools of SQL Server 2005
    • Security
    • Authentications
    • Windows
    • SQL Server
    • Data types
    • TSQL Introduction
    • Database designing
    • Files and File groups
    • Data Definition language
    • Data Manipulation Language
    • Data Retrieval Language
    • Transactions in SQL Sever 2005
    • Commit
    • Roll back
    • Operators
    • Functions
    • Number Functions
    • Character Functions
    • Date time Functions
    • Aggregate Functions
    • Clauses
      • Group By
      • Having
      • Order by

        • Set Operators
        • Joins

        • Inner Join
        • Outer Join(3)
        • Non Equi Join
        • Self Join
        • Cross Join
        • Sub Queries
        • Copying table concept
        • Constraints
        • Primary key
        • Unique
        • Foreign key
        • Check Constraint
        • Not Null
        • Default
        • Views
        • Indexes
        • Synonyms
        • Snapshots
        • Locks in SQL Server 2005
        • Introduction to Programming
        • Batches and Basic programs
        • If. Else, While
        • Cursors
        • User Defined Functions
        • Stored Procedures
        • Triggers
        • Architecture of SQLSERVER 2005
        • SQLSERVER 2008 Features
Copyright © 2012, Jampani Technologies. All rights reserved.