**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**

Oracle 9i Database Fundamentals 1Z0-031 Online Course Details

Total Lessons: 10
Total Time: 29 hour(s)
Subscription Term: 12 month(s)

Summary:

This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z0-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.

Features and Benefits of our Tutorial:
* 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
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment



Lesson 1 Oracle Architecture and Tools - 3 hours

Objectives: After completing this lesson, students will be able to:
* Explain the Oracle server architecture
* Identify how users connect to the Oracle server
* List tools used by DBAs to administer Oracle
* Describe the benefits of Optimal Flexible Architecture
* Install Oracle using Oracle Universal Installer

Lesson 2 Managing Instances and Creating Databases - 3 hours

Objectives: After completing this lesson, students will be able to:
* Create and manage an initialization parameter file
* Create a database with the create database command
* Define a character set for your database
* Configure language-dependent behavior for the your database
* Retrieve NLS information from the your database
* Configure Oracle-managed files
* Use the startup command
* List the different options available for starting Oracle
* Shut down an Oracle instance
* Describe the two types of diagnostic files used in Oracle
* List the prerequisites necessary for database creation
* List values that must be set in the parameter file
* Use the Database Configuration Assistant

Lesson 3 Managing the Database Structure - 3 hours

Objectives: After completing this lesson, students will be able to:
* Use data dictionary views
* Query the data dictionary
* Use control files
* Work with redo logs

Lesson 4 Managing Tablespaces and Datafiles - 2 hours

Objectives: After completing this lesson, students will be able to:
* Describe the logical structure of Oracle databases
* Create tablespaces
* Manage temporary segments
* Take tablespaces online and offline
* Change tablespace storage settings
* Use Oracle-Managed Files (OMF) with tablespaces

Lesson 5 Managing Storage Structures and Undo Data - 4 hours

Objectives: After completing this lesson, students will be able to:
* Identify storage needs for different segment types


* Size OLTP and batch undo segments
* Maintain undo segments manually
* Control the size allocation of extents and segments
* Acquire extents in dictionary-managed tablespaces
* Use multiple extents when using parallel processors
* List the keywords that control block space usage
* Obtain information about storage from the data dictionary
* Describe the purpose of undo data
* Implement automatic undo management
* Create and configure undo segments

Lesson 6 Managing Tables - 3 hours

Objectives: After completing this lesson, students will be able to:
* Explain how tables can store data
* Create permanent and temporary tables
* Manage storage structures
* Relocate tables
* Drop unused columns

Lesson 7 Managing Indexes and Data Integrity - 3 hours

Objectives: After completing this lesson, students will be able to:
* Describe the different types of indexes and their uses
* Create various types of indexes
* Reorganize and drop indexes
* Monitor index usage
* Implement data integrity constraints
* Maintain integrity constraints
* Obtain index and constraint information from the data dictionary

Lesson 8 Managing Users and Profiles - 5 hours

Objectives: After completing this lesson, students will be able to:
* Create new database users
* Manage existing users
* Monitor information about existing users
* Control resource use with profiles
* Administer profiles
* Manage passwords using profiles
* Obtain profile information from the data dictionary

Lesson 9 Managing Privileges and Roles - 3 hours

Objectives: After completing this lesson, students will be able to:
* Identify system and object privileges
* Grant and revoke privileges
* Identify auditing capabilities
* Create and modify roles
* Control availability of roles
* Remove roles
* Use predefined roles
* Display role information from the data dictionary

Lesson 10 Exam Preparation - 3 hours

Objectives: After completing this lesson, students will be able to:
*Practice for and evaluate your current skill level for the Oracle9i Database Fundamentals 1Z0-031 Exam