1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"I learned what I had hoped to from this class. I would definitely take another course from Webucator..." More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ ONLINE ORACLE9I DATABASE FUNDAMENTALS 1Z0-031 TRAINING

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online Oracle 1Z0-031 Training

Only $99.95
12-month subscription

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.

Oracle9i Database Fundamentals 1Z0-031 Series (26 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 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA