oracle tutorial - Courses UK

Affordable Online Computer Courses



CCNP Training Pack CCNA Training Pack Cisco Training Pack COMPTIA Certification .NET Training Microsoft MCSE 2003 Microsoft MCSA 2003 Microsoft MCAD Microsoft MCDBA Microsoft MCSD MCDST Training Microsoft Office XP Microsoft Office 2003

"Realistic Simulations"
So you can see how the application really works. All Courses also include pre and post-test which identifies individual strengths and weaknesses, allowing you to take only the units you haven't mastered and test how well you've mastered the completed Module.

The course provides students with a comprehensive examination of PL/SQL. PL/SQL offers procedural integrity, security enhancements, and performance gains in a client-server environment. PL/SQL is also used to code triggers in Oracle Forms and Reports. PL/SQL will be of particular interest to individuals developing applications in a client-server environment.

Too Busy to Train?
You can Login 24 hours/day -7 days/week. Learn before bed, first thing in the morning, or in the middle of the night. It's always available. You're always in control.


		The Instant Mentoring window appears directly within your courses. Instant Mentoring allows you to type a question and receive a immediate response from a subject matter expert available 24/7 to help you succeed! MORE...

Oracle 9 i Database Fund 1Z1-031 Training




Try a Demo

Usual Price
£~~245~~

Our Price
12 Months Access:
UK:149
US:$261
Eur:€219


	65%

This series is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z1-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 1Z1-031

EASY.....start your online training course within the hour
Available 24 hrs/day 7 days/week
High quality Web-based Training / e-Learning
Train ALL YEAR for 1 low price


	Click the "Sign up Button" (above) to sign up for 12 months access to this course or buy our Technical General Value pack (this Course plus 34 other courses), if bought separately £~~5,066.~~ Value Pack price: Only £399! Save £4,667 MORE...

Oracle9i Database Fund 1Z1-031 Modules Outline:

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

Oracle9i Database Fundamentals 1Z1-031- Managing Instances and Creating Databases

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

Oracle9i Database Fundamentals 1Z1-031- Managing the Database Structure

Use data dictionary views
Query the data dictionary

Use control files
Work with redo logs

Oracle9i Database Fundamentals 1Z1-031- Managing Tablespaces and Datafiles

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

Oracle9i Database Fundamentals 1Z1-031- Managing Storage Structures and Undo Data

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

Oracle9i Database Fundamentals 1Z1-031- Managing Tables

Explain how tables can store data
Create permanent and temporary tables
Manage storage structures

Relocate tables
Drop unused columns

Oracle9i Database Fundamentals 1Z1-031- Managing Indexes and Data Integrity

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

Oracle9i Database Fundamentals 1Z1-031- Managing Users and Profiles

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

Oracle9i Database Fundamentals 1Z1-031- Managing Privileges and 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

Oracle9i Database Fundamentals 1Z1-031- Exam Preparation

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

Training Tutorials - e-Learning - Distance Learning - Self paced - Courses