Oracle^® Database 10g Administration:
Hands-On

What is this course about?

In this hands-on course, you gain the fundamental knowledge and skills to create and configure Oracle Database 10g (Oracle 10g), manage memory and storage effectively, and deploy essential procedures to maintain your organisation's data. You also learn to ensure availability of data by deploying backup, recovery and flashback operations.

During this course, you gain experience with a variety of Oracle tools including Oracle Enterprise Manager (OEM) 10g Database Control, Data Pump and SQL*Plus.

Who will benefit from this course?

With the increased options available in Oracle 10g, database administrators need to learn how to make appropriate use of these tools and acquire the necessary expertise to employ them effectively. This course is designed for professionals whose work involves or will involve the administration of an Oracle 10g database:

• Database administrators who have had experience administering databases other than Oracle and who need to learn how to perform the administration tasks that are unique to Oracle 10g;
• Application or systems developers who find that their role is being changed to one of a DBA or assistant DBA, or who are interested in, or need to know, the techniques used to properly administer Oracle 10g databases; and
• Systems administrators who want to learn how to properly manage the available system resources to effectively run Oracle 10g on their machines.

What background should I have?

You should have some background and experience working with a SQL-based RDBMS. Experience equivalent to Course 593, Oracle^® Database 10g: A Comprehensive Hands-On Introduction, is assumed. Course 493, Oracle^® PL/SQL Programming: Hands-On, is helpful, but is not required.

How does Oracle Database 10g differ from Oracle9i?

Oracle 10g is a superset of Oracle9i and Oracle8i. This version introduces more automated features for increased manageability and provides an enhanced graphical interface within Oracle Enterprise Manager (OEM) 10g Database Control to facilitate database administration. In addition, Oracle 10g continues to offer the well-established tools and features that finely control database activity. Oracle 10g is aimed at being more adaptable to different levels of administration and is more reliable than previous versions.

What version of Oracle is used?

This course is currently running on Oracle10g, Release 2 on the Windows platform.

Is this course useful to me if I work with an earlier version of Oracle?

This course uses Oracle10g. If you are evaluating Oracle 10g, or if you are currently working on an earlier version but are planning to move to Oracle10g, then this course is for you. The course highlights the main differences between the Oracle versions with icons ("10g," "9i," "8i").

Will it matter if I use Oracle on a different platform such as UNIX or VMS?

No, most of the topics covered are not operating system-specific. However, issues that are affected by the operating system are highlighted and the differences noted.

How much time is spent on each topic?

What kinds of hands-on exercises are included?

Approximately 40% of class time is devoted to hands-on exercises. Hands-on exercises focus on performing basic and advanced database administration tasks using command line and graphical tools. These include starting and stopping an instance, creating an Oracle 10g database, creating, altering and dropping tablespaces, managing rollback with UNDO tablespaces, creating users, granting system and object privileges to users, creating partitions resuming failed SQL statements, performing flashback operations, setting thresholds and creating alerts, and backing up and recovering tablespaces and databases.

Does this course cover grid computing and RAC?

This course covers fundamental Oracle skills applicable to all Oracle environments. While grid concepts are briefly discussed, grid computing and RAC are specialized installations requiring specific skills and knowledge beyond the scope of this course.

What is the difference between this course and those offered by Oracle?

Learning Tree is dedicated to accelerating the careers of our clients by providing them with world-class technology and management training. Our independence from Oracle (and any other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Oracle by industry experts who bring their real-world experience to the classroom.

How does this course relate to other Learning Tree courses?

• 593, Oracle® Database 10g: A Comprehensive Hands-On Introduction , offers a comprehensive introduction to the relational features of Oracle 10g
• 492, Application Development and Tuning for Oracle® Databases: Hands-On,  provides the skills to create powerful and secure Oracle database applications and tune them for optimal performance on Oracle8i, Oracle9i, and 10g
• 493, Oracle® PL/SQL Programming: Hands-On , provides extensive experience designing PL/SQL applications that solve complex business problems with Oracle8i, Oracle9i, and 10g
• 234, Developing SQL Queries for Oracle® Databases: Hands-On , provides the skills needed to write robust, reliable and efficient SQL queries for Oracle8i, Oracle9i, and 10g
• 382, Relational Database Design, Tools and Techniques: Hands-On , provides a strong foundation for designing, building and working with relational databases

UK Dates