Forgot My Password Support
 
◊ ORACLE9I DATABASE FUNDAMENTALS 1Z0-031 ONLINE TRAINING SERIES

Online Oracle9i Database Fundamentals 1Z0-031 Training

Database » Oracle


Only $99.95

Oracle9i Database Fundamentals 1Z0-031 Series (29 hours)

ONLINE Oracle 1Z0-031 TRAINING FEATURES

  • Learn Oracle 1Z0-031 online with these interactive online Oracle 1Z0-031 courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the Oracle 1Z0-031 courses
  • Retake the Oracle 1Z0-031 courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Oracle Architecture and Tools

Time: 3 hours
This course introduces users to the major components of an Oracle server.

Objectives

  • 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

Topics

  • Oracle Server Architecture
  • The Server Process
  • Connecting to Oracle Servers
  • Processing Queries
  • Processing DML Statements
  • Processing Commit Statements
  • Common Database Administration Tools
  • Oracle Universal Installer
  • Installing Oracle9i Database
  • Optimal Flexible Architecture
  • Oracle Authentication
  • Using Operating System Authentication
  • Using Password File Authentication
  • Oracle Enterprise Manager Components


2. Managing Instances and Creating Databases

Time: 3 hours
This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters.

Objectives

  • Create and manage an initialization parameter file
  • 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
  • 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

Topics

  • Creating an Initialization Parameter File
  • Configuring Oracle-Managed Files
  • Starting an Instance using SQL*Plus
  • Startup Methods and Options
  • Shutting Down an Instance
  • Using Diagnostic Files
  • Planning for Database Creation
  • Preparing the Parameter File
  • Using the Database Configuration Assistant
  • Creating a Database Manually
  • Choosing a Character Set
  • Specifying Language-Dependent Behavior
  • Viewing Globalization Support Information


3. Managing the Database Structure

Time: 3 hours
This course introduces users to data dictionaries, control files, and redo log files.

Objectives

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

Topics

  • 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


4. Managing Tablespaces and Datafiles

Time: 2 hours
This course introduces users to creating and managing tablespaces.

Objectives

  • 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

Topics

  • Oracle's Logical Structure
  • Understanding Tablespaces
  • Creating Tablespaces
  • Changing Tablespace Size
  • Using Temporary Segments
  • Managing Uniform Extent Sizing
  • Changing Tablespace Status
  • Changing Tablespace Storage Settings
  • Using OMF with Tablespaces


5. Managing Storage Structures and Undo Data

Time: 4 hours
This course introduces users to the underlying storage structure of a database and to using undo segments.

Objectives

  • Identify storage needs for different segment types
  • 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
  • Size OLTP and batch undo segments
  • Maintain undo segments manually

Topics

  • Types of segments
  • Acquiring and managing segments and extents
  • Controlling block space usage
  • Obtaining information about storage structures
  • Using undo data
  • Implementing automatic undo Management
  • Creating, configuring, and maintaining undo Segments manually


6. Managing Tables

Time: 3 hours
This course introduces users to creating and managing table structures.

Objectives

  • Explain how tables can store data
  • Create permanent and temporary tables
  • Manage storage structures
  • Relocate tables
  • Drop unused columns

Topics

  • Storing Data
  • Distinguishing Oracle Datatypes
  • Extended and Restricted ROWIDs
  • Row Structure
  • Creating Permanent and Temporary Tables
  • Managing Storage Structures
  • Managing Tables
  • Dropping Columns


7. Managing Indexes and Data Integrity

Time: 3 hours
This course introduces users to indexes and data integrity constraints.

Objectives

  • 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

Topics

  • Index Types
  • Function-Based and Descending Indexes
  • Creating B-Tree and Bitmap Indexes
  • Reorganizing Indexes
  • Dropping Indexes and Getting Index Information
  • Monitoring Use of Indexes
  • Implementing Data Integrity Constraints
  • Using Deferred Constraints
  • Maintaining Integrity Constraints
  • Obtaining Constraint Information


8. Managing Users and Profiles

Time: 2 hours
This course introduces users to creating and managing users and to control resources using profiles.

Objectives

  • 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

Topics

  • Creating New Users
  • User Account Guidelines
  • Altering and Droping Existing Users
  • Monitoring User Information
  • Controlling Resource Use with Profiles
  • Administering Profiles
  • Administering Passwords Using Profiles
  • Obtaining Profile Information


9. Managing Privileges and Roles

Time: 3 hours
This course introduces users to system and object privileges and user roles.

Objectives

  • 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

Topics

  • System Privileges
  • Special and Object Privileges
  • Granting and Revoking Privileges
  • Granting Administrative Abilities
  • Identifying Audit Capablitities
  • Using the Audit Command
  • Managing Auditing
  • Creating and Modifying Roles
  • Controlling Availability of Roles
  • Using Predefined Roles
  • Displaying Role Information


10. Exam Preparation

Time: 3 hours
This course allows users to practice answering questions in order to prepare for taking the exam.

Objectives

  • After completing this course, the user should be familiar with all the exam objectives for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam

Topics

  • This course covers all of the objectives for the certification exam



Resources for Oracle9i Database Fundamentals 1Z0-031