|
|
|
Oracle 9i Database Fundamentals 1Z0-031 Training Online
 |
This Online Oracle 9i Database Fundamentals 1Z0-031 Training is for anyone preparing for the Oracle 1Z0-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals. |
|
| |
Product Duration: 12 Months Unlimited Access |
Price |
Add to Cart |
| |
Oracle 9i Database Fundamentals 1Z0-031 Training
This online training 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, table spaces, tables, data files, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.
|
£199.99
|
|
|
| Oracle 9i Database Fundamentals 1Z0-031 Course Lessons: |
Oracle 9i Database Fundamentals 1Z0-031: Oracle Architecture and Tools
This course introduces users to the major components of an Oracle server. Explain the Oracle server architecture
Identify how users connect to the Oracle server
List tools used by DBA's to administer Oracle
Describe the benefits of Optimal Flexible Architecture
Install Oracle using Oracle Universal Installer
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Instances and Creating Databases
This course introduces users to managing an Oracle instance, creating a database, and using globalisation parameters. Create and manage an initialisation 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
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing the Database Structure
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Table spaces and Data files
This course introduces users to creating and managing table spaces. Describe the logical structure of Oracle databases
Create table spaces
Manage temporary segments
Take table spaces online and offline
Change table space storage settings
Use Oracle-Managed Files (OMF) with table spaces
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Storage Structures and Undo Data
This course introduces users to the underlying storage structure of a database and to using undo segments. Identify storage needs for different segment types
Control the size allocation of extents and segments
Acquire extents in dictionary-managed table spaces
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
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Tables
This course introduces users to creating and managing table structures. Explain how tables can store data
Create permanent and temporary tables
Manage storage structures
Relocate tables
Drop unused columns
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Indexes and Data Integrity
This course introduces users to indexes and data integrity constraints. 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
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Users and Profiles
This course introduces users to creating and managing users and to control resources using profiles. 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
|
|
Oracle 9i Database Fundamentals 1Z0-031: Managing Privileges and Roles
This course introduces users to system and object privileges and user roles. 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
|
|
Oracle 9i Database Fundamentals 1Z0-031: Exam Preparation
This section tests your knowledge with mock exam questions and answers
|
|
|
If you have a question about our Oracle 9i Database Fundamentals 1Z0-031training or any other careers or training courses
just phone us on 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!) or fill in the simple form below and we will contact you shortly.
|
Telephone: 0871 222 8790 (Hotline Available NOW 24 hours a day, 7 days a week!)
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL
|
What do I get?
Within 30 minutes of placing your order you will receive a username and password and a link to access all of the following:
Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn
Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 9.30am-4.30pm to help you out if you get stuck
Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.
|
