An Oracle Technical Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and skills in databases, giving you the competitive edge. The Oracle student is given an extensive introduction to data server technology and concepts of both relational and object relational databases.

Entry Requirements:

• Knowledge of Databases, familiarity with data processing concepts and techniques

Programme Content -

Oracle 9i SQL & PL/SQL

• Writing a Basic SQL Statement
• Restricting and Sorting Data
• Single Row Functions
• Displaying Data from Multiple Tables
• Writing Sub queries
• Producing Readable Output with iSQL*Plus
• Manipulating Data
• Creating and Managing Tables
  Including Constraints
  SQL Workshop
• Using Set Operators
• Oracle9i Single Row Functions
• Enhancements to the GROUP BY Clause
• Advanced Sub queries
• Hierarchical Retrieval
• Extensions to DDL and DML Statements
• Writing Scripts to Generate Scripts

Oracle 9i Database Fundamentals 1

• Getting Started with the Oracle Server
• Managing an Oracle Instance
• Creating a Database
• Using the Data Dictionary
• Maintaining the Control File
• Maintaining Redo Log Files
• Managing Tablespaces and Data Files
• Storage Structure and Relationships
• Managing Table
• Managing Indexes
• Maintaining Data Integrity
• Managing Password Security and Resources
• Managing Users
• Managing Privileges and Roles
• Using Globalization Support