Oracle Database 10g Aministration Workshop 1 Training CBT

Price: $516.00

Oracle CBT Course Overview:

The Self Study Store Computer Based Training Oracle Database 10g: Administration Workshop I consists of Oracle Database 10g: Administration Workshop I Part 1, Oracle Database 10g: Administration Workshop I Part 2, Oracle Database 10g: Administration Workshop I Part 3, and Oracle Database 10g: Administration Workshop I 4. Oracle Database 10g: Administration Workshop I Part 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 Part 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 Part 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 Part 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.

Total Training Duration:

24 hours

CBT Course Modules:

Oracle Database 10g: Administration Workshop I Part 1 - 4

Training Course Topics:

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

The Self Study Store Computer Based Training Oracle Database 10g: Administration Workshop I course target audience is Data Administrators, Technical consultants Support Engineers, and Sales Consultants.