Oracle
Oracle is the
world's largest enterprise software company. Providing the latest
in technology, applications and services to companies worldwide. Making
Oracle certification one of the most sought after marks of credibility
for expertise in the IT marketplace today.
We have two Oracle courses. Oracle 9i SQL
which is suitable for beginners in database, preparing you for the
first exam (1Z0-007) in the Oracle Certification track. Once you have
passed this exam you can then progress onto Oracle
9i PL/SQL Developer which is for anybody interested in developing
applications using Oracle, and is suitable for programmers in Java,
C, C++, VB .NET.
SQL is implemented
in a wide range of technologies, for example web and e-commerce applications
use SQL to interface web pages with company databases, making just
about every IT infrastructure have some database which is managed
with SQL.
Once you've completed the course and the Oracle syllabus, you can
then go on to take exam: 1Z0-007. After successfully passing the exam,
you can then go on to do Oracle 9i/SQL developer. Our trainers will
be available in classrooms at all times to assist you.
Syllabus
Introduction to
Oracle 9i: SQL, QL/SQL, and SQL*plus
SQL*Plus commands
Filtering and Sorting Data
SQL Functions
Working with Multiple Tables
Tables and Constraints
Other Database Schema Objects
Building PL/SQL Blocks
PL/SQL provides
a server-side, stored procedural language that is easy to use, and
robust. To do this course you will be given your own Oracle User Account,
to access via our server. You will then follow instructions from a
PL/SQL training manual, where you will start writing and debugging
PL/SQL Stored Procedures, Database Triggers and Functions. You will
need to have done our Oracle 9i SQL course and have some knowledge
of Programming to do this course. Trainers are available in classrooms
at all times to assist you.
Syllabus
Buidling PL/SQL
Blocks
PL/SQL Control Structures
Cursors
Exception Handling
Procedures and Functions
Oracle Packages
Oracle Triggers
PL/SQL Collections
