 |
Oracle Certification brings the credibility you deserve
for your knowledge, skill, and experience as an Oracle Professional.
It provides you a market recognized credential that can lead
to success. Click on a certification title below for training.
EXAM 1Z0-007
Introduction to Oracle SQL and PL/SQL
Total Lessons: 165
Total Time: 12 Hours
Virtual Training Company's Introduction
to Oracle SQL and PL/SQL covers in detail the Relational Database
Model, the Oracle Architecture, and the Physical Database. The tutorial
is aimed at programmers, and individuals who have had prior SQL and
relational database experience. Gavin Powell, your instructor, teaches
users Oracle tools SQL Plus, SQL Plus Worksheet, and Oracle Enterprise
Manager. The tutorial explains how to maintain the Logical Database
and the differences between the Logical and Physical Databases. You
will be guided, with great detail, in the following areas: retrieving,
changing, adding, and deleting data from the database. Learn about
Logical Database Objects, Security, Select Statements, and much more. Introduction
to Oracle SQL and PL/SQL will cover areas for the Oracle Certification
course #1Z0-007.
EXAM 1Z0-031
Oracle
Database Administration Fundamentals I
Total Lessons: 99
Total Time: 8 Hours
This is the second in a series of courses, aimed at preparing the user
for Oracle Certification exam #1Z0-031.
This course will teach Oracle Database Administration Fundamentals, installing
Oracle, Creating Databases, Managing Objects in the Database, and much
more. This course expands on the first course offered by VTC - Introduction
to Oracle SQL and PL/SQL.
EXAM 1Z0-032
Oracle
Database Administration Fundamentals II
Total Lessons: 181
Total Time: 8 Hours
Oracle Database
Administration Fundamentals II is the third in a series of four
courses covering the Oracle Certification track (course #1Z0-032).
Like the other courses in this series of Oracle Certification titles,
this course teaches and demonstrates by example using thoroughly tested
examples. Your instructor, Gavin
Powell, covers Oracle Net Services, Backup and Recovery including
RMAN, Oracle Enterprise Manager, Transportable Tablespaces and SQL*Loader.
In addition, there are small sections introducing other Oracle optional
features such as Standby Databases (both Logical and Physical) plus
Replication (both traditional and using Streams). Net Services covers
architecture, connection configuration, listener configuration (from
basics to Connection Profiling and Load Balancing), all the facts about
Connection Strings and Oracle Net Services naming methods, even introducing
some advanced features.
EXAM 1Z0-033
Oracle:
Performance Tuning (1Z0-033)
Total Lessons: 194
Total Time: 11 Hours
VTC author, Gavin
Powell, covers material in the 1Z0-033 Oracle 9i tuning certification
examination, including the basics of performance tuning and tuning
tools. Memory tuning covers the shared pool, the database buffer cache
and other buffers. From an I/O perspective, topics covered are physical
file structures of the database, tablespaces, datafiles and at the
block level. Also covered are sorting, locking, latches and wait events,
shared or dedicated server processes, statistics, SQL code tuning and
resource management. There is also brief coverage of tuning in the
operating system, plus specialized objects use.
Note: While every precaution has been taken in the preparation of these tutorials,
the publisher and the authors assume no responsibility for errors or omissions, or
for damages resulting from the use of the information contained herein.
|