certificate in Oracle 9i

Course Duration  4 Months

Course Objective

Oracle9i Database is the state of the art in object-relational databases. Voted Editors Choice by PC magazine and the #1 database for Linux by Linux Journal, Oracle9i Database is the most scalable and full-featured database available. Whether driving your web site, packaged applications, data warehouses or OLTP applications, Oracle9i Database is a foundation technology for any professional computing environment.

This comprehensive course is specially designed for those who have little or no I.T. experience. You are trained in a step-by-step manner from fundamental database concepts to advanced PL/SQL and Java programming. Upon completion of the program, you will be ready to join highly technical projects.

Prerequisites/Audience

Students with good logical reasoning ability, from science/mathematics educational background can find out a career option from this course. This will give you a clear head start in a brand new career objective towards a well-defined goal.

Course Contents

• Introduction to RDBMS and Oracle 9i
• Introduction to SQL
• Set Operator
• SQL Operators
• Updating and Deleting Data in Existing Table (DML)
• Views and Miscellaneous Facilities of SQLPLUS
• An Introduction to PL/SQL
• Database Triggers
• Procedures, Functions and Packages
• Implementing Types, Object Views, and Methods
• Collectors (Nested Tables and Varying Arrays)
• Using Large Objects
• Advanced Object-Oriented Concepts
• An Introduction to Java
• JDBC And SQLJ Programming
• Java Stored Procedures
• Introduction to the Oracle Server
• Oracle Server Features
• Data Blocks, Extents, and Segments
• Tablespaces, Datafiles, and Control Files
• The Data Dictionary
• Database and Instance Startup and Shutdown
• Distributed Processing and Oracle Net Services
• Memory Architecture
• Process Architecture

Career Prospects

• Database Administrator
• Database Operator

Hardware required

Processor - Pentium -266 MMX and above
RAM - 128MB or higher
Hard Disk Space – 500MB and above
Monitor - SVGA Color 800x600

Software Required

Operating System - Windows 98/2000
Oracle 9i

Click here for Join Now