<="style13 style13 style13">Oracle Database 10g: Administration Workshop I Suite Training
CD-Rom / CBT

Training Course ID:CBT 88-67110D

Training Course Description / Outline

Oracle Database 10g: Administration Workshop I Suite Computer Based Training CBT consists of Oracle Database 10g: Administration Workshop I Training 1, Oracle Database 10g: Administration Workshop I Training 2, Oracle Database 10g: Administration Workshop I Training 3, and Oracle Database 10g: Administration Workshop I 4. Oracle Database 10g: Administration Workshop I Training 1 enables learners to 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. Oracle Database 10g: Administration Workshop I Training 2 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 discussed at length. Attention has been paid to DML and to PL/SQL code, which is Oracle's proprietary fourth generation programming language that enables Oracle applications to interact over different operating systems and hardware platforms. Oracle Database 10g: Administration Workshop I Training 3 provides an understanding of the Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic alerts and thresholds. Oracle Database 10g: Administration Workshop I Training 4 enables learners to 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.

<="bodycopy">Oracle Database 10g Administratgor CBT Exam: 1Z0-042

This Computer Based Training Suite concist of four courses:

Oracle Database 10g: Administration Workshop I Part 1
Oracle Database 10g: Administration Workshop I Part 2
Oracle Database 10g: Administration Workshop I Part 3
Oracle Database 10g: Administration Workshop I Part 4

Learn To

• Identify features of a Relational Database Management System (RDBMS).
• Match the different types of integrity constraints with their features.
• Identify tasks of an Oracle DBA.
• Identify features of database user accounts and profiles in Oracle Database 10g.
• Identify options you can configure when creating a user.
• Identify options used to grant privileges to a user.
• Identify features of schemas.
• Identify rules for naming database objects.
• Match data types in Oracle Database 10g with their features.
• Identify security practices and principles that are implemented in Oracle Database 10g.
• Identify advantages of revoking unnecessary privileges from the user group PUBLIC.
• Identify guidelines for restricting dictionary and directory access.
• Identify benefits of undo data.
• Identify features of undo segments.
• Identify undo management tasks that a DBA should perform to use Undo efficiently.
• Match database failures with their possible causes.
• Identify features of instance recovery.
• Identify key concepts of tuning instance recovery.

Total Training Time

24 hours

Audience

This Oracle Database 10g: Administration Workshop I Suite Computer Based Training CBT target audience is Data Administrators, Technical consultants Support Engineers, and Sales Consultants.