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      

ORACLE 10g

  DBMS:

  • Concepts of DBMS
    • Introduction
    • Importance and Need
    • Database Models and Normalization
        • Models
          •  Hierarchical
          • Network
          • Relational
          • Object
            • Normalization Techniques

Introduction to RDBMS:

  • Concepts of RDBMS
    • Introduction
    • Comparison with DBMS
    • CODD rules
    • Normalization Revisited
      • Concepts of ORDBMS & OODBMS
        • Introduction to ORDBMS
        • Introduction to OODBMS
        • Comparison and analysis

Structured Query Language

  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database Objects
  • Table, view

Commands in SQL

  • Data definition language (DDL)
  • Data manipulation language (DML)
  • Data control language (DCL)
  • Transaction control language (TCL)
  • Database security and privileges (DCL)

Working with DDL, DML,TCL Commands

  •  Operators
    • Conditional
    • Logical
    • Comparison
    • SET
      •  Functions
        • Date
        • Number
        • Character
        • String
        • Group
        • Group by ,Having clause
        • Transformation function:-

     DECODE, TRANSLATE

    •  NVL ,NVL2(9i)
    • Aggregate Functions
    • Integrity Constraint
    • Different Types of Integrity Constraint
    • Use of Integrity constraint in table
        • Joins
          •  Usage of joins
          •  Different Types of joins
    • Equip join, Cartesian join
    • Self join, outer join
      • Sub queries
        • Need of sub queries
        • Nested sub queries
        • Co-related sub quires
        • Flashback queries (9i)
          • View
            •  Importance of views
            • Creating, manipulating views
            • Materialized views(9i)
                      • Working with database objects
                        • Sequences and synonyms
                        • Index, cluster, creating cluster table
                          • Using external tables(9i)
            • System privileges
            • Table privileges
              • Locks and SQL plus editor commands

            PL/SQL

            • Introduction to PL/SQL
            • Advantages of PL/SQL
            • Data types in PL/SQL
            • Variable and constants
            • Assignments and constants
            • Referencing NON-PL/SQL Variable
            • Using built in functions
            • Conditional and Iterative statements
            • SQL in PL/SQL
            • Composite data types
            • Cursors
            • Exception:-predefined, user-defined
            • Records and PL/SQL table types

            Advanced PL/SQL

            • Introduction to Triggers
            • Types of triggers:-row levels, statements level
            • Before and after, instead of triggers
            • Procedures, functions in PL/SQL
            • Argument modes
            • User defined packages
            • Dropping triggers, procedures, functions
            • Reference cursors
            • Usage of ref cursors in procedures, functions, packages

             

Copyright © 2012, Jampani Technologies. All rights reserved.