Oracle 9i Database Fundamentals Training Courses

Course List
Specials
Site Map
Free Training Tutorials
Oracle Certification




Computer Training Courses Catalog
(PDF Format)

You will receive Unlimited Access to all of the Oracle 9i Database Fundamentals 1Z0-031 tutorials listed below. Your online training courses will be available from anywhere you have internet access.

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.

This e-learning computer training series includes all of the online training tutorials listed below and is provided in an interactive e-learning format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit .

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 40 countries.

Certification: Oracle Certification

Includes:

Oracle 9i Database - Oracle Architecture and Tools

• 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

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

• 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

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

• 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

• 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

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

• 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

• 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

• 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

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit CEU credit.


Questions about Oracle 9i Database Fundamentals 1Z0-031? We now offer 24x7 online support with access to real live experts! Get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your Oracle 9i Database Fundamentals 1Z0-031 questions quickly answered anytime from anywhere.

Oracle 9i Database Fundamentals 1Z0-031... ... $59.95
Oracle 9i Database Fundamentals 1Z0-031 + 1 Year Instant Mentoring... ... $99.95

You might also be interested in our Technical Package which includes all of the Oracle 9i Database Fundamentals 1Z0-031 training courses listed above plus over 1056 hours of additional courses.

About Us News Contact Us Features Certification

Reviews:

"this is a must have resource"
TheTechMag.com

"this is the Ultimate Career Development Package."
MidWest Technology Journal

Great Service and Excellent Training Product - Great People
Kenosha, WI

Excellent program, this is a real winner. Thanks. A+
Arlington, TX

Read more customer reviews about our e-learning training tutorials.