Computer Based Training - Oracle9i Database Fundamentals 1Z1-031: Managing the Database Structure

Summary:

This course introduces users to data dictionaries, control files, and redo log files.

Objectives:

After completing this course, students will be able to:

Use data dictionary views
Query the data dictionary
Use control files
Work with redo logs

Outline:

Constructing Data Dictionary Views
Tables and Views
Data Dictionary Contents
Querying the Data Dictionary
Using Control Files
Control File Contents
Using Oracle-Managed Files
Viewing Control File Information
Multiplexing Control Files
Redo Log Files
Controlling Log Switches and Checkpoints
Maintaining Redo Log Files
Using OMF to Manage Redo Log Files

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Activities that allow users to apply course concepts in an interactive questioning environment
A glossary
A Skill Assessment

Applicability:

This course is for anyone preparing for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Prerequisites:

Experience working with relational database systemsCourses on SQL or equivalent experienceGeneral knowledge of networkingOracle9i Database Fundamentals 1Z1-031: Oracle Architecture and ToolsOracle9i Database Fundamentals 1Z1-031:Managing Instances and Creating Databases

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Terms of Use:

None