Welcome to the e-Learning Oracle 9i Database Fundamentals 1Z0-031 course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning Oracle 9i Database Fundamentals 1Z0-031 course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning Oracle 9i Database Fundamentals 1Z0-031

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning Oracle 9i Database Fundamentals 1Z0-031 course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning Oracle 9i Database Fundamentals 1Z0-031 course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning Oracle 9i Database Fundamentals 1Z0-031 online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

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.

This online training is designed to help users  prepare for the Oracle 9i 1Z0-031 exam

About the course

Oracle Architecture and Tools - Duration 3 Hour(s)

• 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

Managing Instances and Creating Databases - Duration 3 Hour(s)

• 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

Managing the Database Structure - Duration 3 Hour(s)

• This course introduces users to data dictionaries, control files, and redo log files. Use data dictionary views Query the data dictionary Use control files Work with redo logs

Managing Table spaces and Data files - Duration 2 Hour(s)

• 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

Managing Storage Structures and Undo Data - Duration 4 Hour(s)

• 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

Managing Tables - Duration 3 Hour(s)

• 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

Managing Indexes and Data Integrity - Duration 3 Hour(s)

• 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

Managing Users and Profiles - Duration 2 Hour(s)

• 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

Managing Privileges and Roles - Duration 3 Hour(s)

• 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

Exam Preparation - Duration 3 Hour(s)

• This section tests your knowledge with mock exam questions and answers

Qualification

Oracle 9i Database Fundamentals 1Z0-031

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here