This prestige oracle certification title is in great demand. Students have
to pass four certifications exams
Course : Introduction Oracle 9i SQL
Duration : 30 hours
Associated Exams : 1Z0 - 007
Description
This class is applicable to Oracle9i and
Oracle8i users. This course offers students an extensive introduction to
data server technology. The class covers the concepts of both relational and
object relational databases and the powerful SQL programming language.
Students are taught to create and maintain database objects and to store,
retrieve, and manipulate data. Students learn to retrieve data by using
advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical
retrieval. They also learn to write SQL and SQL* Plus script files using the
iSQL* Plus tool to generate report-like output. Demonstrations and hands-on
practice reinforce the fundamental concepts.
Objective
SELECT statement, correlated sub queries, and
scalar sub queries. Use the iSQL* Plus environment. Write scripts to
generate script files. Generate reports using iSQL* Plus. Create and
maintain database objects. Control transactions. Control data/user access.
Use the Oracle9i Single row functions. Use GROUPING SETS and the WITH
clause. Use the Oracle9i extensions to DML and DDL statements. Apply
techniques in real life simulation
Audience
Database administrators system Analysts
Prerequisite
Solve problems by using multicolumn sub queries, sub queries in the from
clause of a Familiarity with data processing concepts and techniques windows
experience. Ability to use a graphical user interface (GUI)
Course : Oracle 9i Database Admin Fundamental - I
Duration : 30 hours
Associated Exam : 1Z0 - 031
Description
Oracle DBAs manage the industries most advanced information systems and
command some of the highest salaries. This course is your first step towards
success as an Oracle professional, designed to give you a firm foundation in
basic database tasks. In this class, you'll learn how to design, create, and
maintain an Oracle database. Students will gain a conceptual understanding
of the Oracle database architecture and how its components work and interact
with one another. Students will also learn how to create an operational
database and properly manage the various structures in an effective and
efficient manner. The lesson topics are reinforced with structured hands-on
practices. This course is designed to prepare you for the corresponding
Oracle Certified Associate exam: Exam #1Z0-031.
Objective
Manage tables paces, segments, extents, and
blocks Manage users, privileges, and resources Create an operational
database Start up and shut down an Oracle instance and database Manage
Oracle database files Use Globalization Support features
Audience
Students must have working experience in the
computing environment. System administrator, Database Administrator
Prerequisite
Working experience in the computing
environment Prerequisite course Introduction Oracle 9i
Course : Oracle 9i
Database Administrator Fundamental II
Duration : 30 hours
Associated Exam : 1Z0 - 032
Description
Develop your ability to manage the industry's most advanced information
system. Learn several methods to backup and to recover your Oracle database.
Hands-on workshops give you experience in a realistic technical environment.
Develop skills for basic network administration. Simplify your duties with
Oracle Recovery Manager. This course gives the Oracle database administrator
(DBA) a firm foundation in Oracle Net administration and backup and recovery
operations. Students learn about transporting data between databases and the
utilities used to perform these activities. Students are also introduced to
networking concepts and configuration parameters, as well as how to solve
some common network problems. In hands-on exercises, students configure
network parameters so that database clients and tools can communicate with
the oracle database server.
Objective
Define networking requirements and the solutions provided by Oracle to
implement these requirements Perform database and data file backups with and
without Recovery Manager (RMAN) Configure the network environment for an
Oracle client-server system, List the different Oracle backup methods and
recovery operations that can be used to resolve database failure Describe
the database utilities (Export and Import) and the situations where they can
be used Develop network configuration and recovery techniques through
various workshop scenarios. List the Oracle architecture components related
to backup and recovery operations .
Audience
Students must have working experience in the computing environment
Prerequisite
Working experience in the computing environment
Introduction Oracle9i: SQL
Oracle9i Database Administration Fundamentals I
Course :
Oracle 9i Database Performance Tuning
Duration : 30 hours
Associated Exam : 1Z0 - 033
Description
Database performance tuning is critical to any effective information
system. Reducing wait times, increasing users' productivity and maximizing
the performance of your Oracle database are critical to success. Learn from
the experts the value of intelligent database design and methods for tuning
an Oracle database for maximum performance. This course will introduce
participants to the importance of good initial database design, and the
method used to tune a production Oracle9i database. The focus is on Database
and Instance tuning rather than specific operating system performance
issues. Participants will gain practical experience tuning an Oracle
database. Using the available Oracle tools, such as Oracle Enterprise
Manager (with the Diagnostics and Tuning Packs) and STATSPACK participants
also learn how to recognize, troubleshoot and resolve common performance
related problems in administering an Oracle database.
Objective
Configure Resource Manager to control resource usage Configure an Oracle
Database with an emphasis on good performance. Detect and resolve latch and
lock contention problems within the Oracle database environment Diagnose and
resolve performance issues associated with Shared Server Use Oracle tools to
diagnose performance problems Utilize Enterprise Manager to perform Tuning
tasks Perform day-to-day monitoring on an operational database using
STATSPACK Identify and resolve I/O, data storage, and database configuration
problems Configure memory and disk resources to optimize sort operations.
Reconfigure file structures for performance and other considerations List
the important steps for outlining a tuning methodology
Audience
Students must have working experience in the computing environment
Prerequisite
working experience in the computing environment.
Introduction Oracle 9i SQL
Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II
