computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

Oracle9i Database Fundamentals 1Z0-031Online Course

12 Month Subscription - $70
Live Mentor +$30

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.

Certification:
Oracle 9i Database Fundamentals 1Z0-031

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

Features:
●  Exercises allow learners to practice in the actual application being studied.
●  A file containing the text of the exercises
●  Activities allow learners to apply course concepts in an interactive questioning environment.
●  A glossary provides a reference for definitions of unfamiliar terms.
●  A skill assessment generates a customized learning path based on the results of a pre-test.

Topics included in this course:
Oracle9i Database Fundamentals 1Z0-031 : Oracle Architecture and Tools
Oracle9i Database Fundamentals 1Z0-031 : Managing Instances and Creating Databases
Oracle9i Database Fundamentals 1Z0-031 : Managing the Database Structure
Oracle9i Database Fundamentals 1Z0-031 : Managing Tablespaces and Datafiles
Oracle9i Database Fundamentals 1Z0-031 : Managing Storage Structures and Undo Data
Oracle9i Database Fundamentals 1Z0-031 : Managing Tables
Oracle9i Database Fundamentals 1Z0-031 : Managing Indexes and Data Integrity
Oracle9i Database Fundamentals 1Z0-031 : Managing Users and Profiles
Oracle9i Database Fundamentals 1Z0-031 : Managing Privileges and Roles
Oracle9i Database Fundamentals 1Z0-031 : Exam Preparation

Oracle9i Database Fundamentals 1Z0-031 : Oracle Architecture and Tools
Summary:
This course introduces users to the major components of an Oracle server.

Objectives:
After completing this course, 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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Instances and Creating Databases
Summary:
This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters.

Objectives:
After completing this course, students will be able to:
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
top

Oracle9i Database Fundamentals 1Z0-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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Tablespaces and Datafiles
Summary:
This course introduces users to creating and managing tablespaces.

Objectives:
After completing this course, 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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Storage Structures and Undo Data
Summary:
This course introduces users to the underlying storage structure of a database and to using undo segments.

Objectives:
After completing this course, students will be able to:
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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Tables
Summary:
This course introduces users to creating and managing table structures.

Objectives:
After completing this course, students will be able to:
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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Indexes and Data Integrity
Summary:
This course introduces users to indexes and data integrity constraints.

Objectives:
After completing this course, 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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Users and Profiles
Summary:
This course introduces users to creating and managing users and to control resources using profiles.

Objectives:
After completing this course, 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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Managing Privileges and Roles
Summary:
This course introduces users to system and object privileges and user roles.

Objectives:
After completing this course, 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

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
top

Oracle9i Database Fundamentals 1Z0-031 : Exam Preparation
Summary:
This course allows users to practice answering questions in order to prepare for taking the exam.

Objectives:
After completing this course, students will be able to:
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
top

12 Month Subscription - $70
Live Mentor +$30