From Serebra Learning Corporation
Oracle Database 10g Performance Tuning Tools and Techniques 
This course provides an overview of the tuning methodology and performance monitoring. The course also covers common tuning problems and the goals and objectives of performance tuning. Finally, the course covers the tuning life cycle and the tuning methodology followed in the different phases of the tuning life cycle. This course is designed for
DBAs, database architects, support engineers, and
more...
Oracle Database 10g - Administration Workshop I Part 1 
Learners will gain a conceptual understanding of the
Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring database security user management and backup/recovery techniques.
more...
Oracle Database 10g - SQL Fundamentals I Part 1 
In this course learners will be introduced to the concepts of relational databases and the
Oracle Database 10g database technology. Additionally the learners will be introduced to the powerful
SQL programming language and its features.
more...
From 123-CBT Computer Based Training
Oracle Database 10g Administration Workshop II Part 3 

This course covers various functions of the
Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption.
Learn To:
Identify features of Flashback
more...
Oracle Database 10g SQL Fundamentals I Part 2 

In this course, the learner will learn how to use the advanced features of
SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. .
Learn To:
Identify the
more...
Oracle Database 10g PL SQL Fundamentals Part 1 

In this course, the learner will get familiar with the procedural language to access
Oracle database. The learner will learn how to write and use anonymous PL/
SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as
more...
Oracle Database 10g SQL Fundamentals I Part 1 

...ntroduced to the concepts of relational databases and the
Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful
SQL programming language and its features.
Learn To:
Match the different phases of system development life cycle (
SDLC) with their features.
Identify features of an
Entity Relationship (ER) model.
Identify features of
more...
Oracle Database 10g Administration Workshop II Part 2 

This course will teach learners to use
RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery.
Learn To:
Match various RMAN commands with their features.
Distinguish between the methods for issuing RMAN commands.
Identify
more...
Oracle Database 10g Administration Workshop I Part 4 

Learners will gain a conceptual understanding of the
Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques.
Learn To:
Identify benefits of undo data.
Identify features of undo segments.
Identify undo management tasks that a
DBA should perform to
more...
Oracle Database Administration Workshop I Part 2 

...Oracle
Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of
Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been
more...
Oracle Database 10g Administration Workshop II Part 1 

... Flashback technology.
Learn To:
Match goals of
Oracle Database 10g manageability features with the methods of achieving them.
Identify features of the Oracle Database 10g manageability strategy.
Identify globalization support features provided by Oracle Database 10g.
Identify features of different encoding schemes supported by Oracle Database 10g.
Distinguish between features
more...
Oracle Database 10g New Features for Administrators Part 2 

...Oracle
Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of
Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring.
Learn To:
Identify features of Automatic Database Diagnostic Monitor
more...
Oracle Database 10g New Features for Administrators Part 4 

...Oracle
Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of
Oracle Database 10g such as flash backup and recovery.
Learn To:
Identify features of the flash backup and recovery strategy.
Identify tasks that you perform when using the flash recovery
more...
Oracle Database 10g New Features for Administrators Part 5 

...Oracle
Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the
Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of
Oracle Database 10g such as automatic storage management, upgrade methods,
RMAN backup,
more...
Oracle Database 10g PL SQL Fundamentals Part 2 

This course introduces learners to PL/
SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers.
Learn To:
Identify features of PL/SQL blocks within a subprogram.
Match types of PL/SQL named blocks
more...
Oracle Database 10g PL SQL Fundamentals Part 3 

In this course, the learner will get familiar with the procedural language to access
Oracle database. Students will learn to manage PL/
SQL program units manage dependencies, manipulate large objects, and use some of the
Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of SQL statements with
more...