Synopsis
Oracle8: Building Databases shows users how to create and set up new Oracle databases.

Audience
This course is for anyone who is interested in learning about designing and building databases and tablespaces in the Oracle environment.

Time
4 hours

Product Code: ORCC03
After completing Oracle8: Building Databases the user should be able to:
 
Plan and design a database
Prepare for a new database
Create a new database and catalog
Modify a database
Create and modify tablespaces
Manage tablespaces

Database Planning and Design
 
Understanding the process of creating a database
Designing a database

Creating a New Database and Catalogs
 
Creating a database
Creating catalogs

Modifying Databases
 
Modifying with the Enterprise Manager
Modifying with DDL statements
Monitoring databases

Creating Tablespaces
 
Creating tablespaces with Enterprise Manager
Creating tablespaces with Storage Manager

Modifying Tablespaces
 
Bringing a tablespace offline
Modifying a tablespace for backup
Adding datafiles
Altering tablespace properties

Managing Tablespaces
 
Using the storage clause
Making a tablespace read-only
Creating a temporary tablespace
Monitoring tablespaces

This course is distributed with:
 
Exercises that allow users to practice in Oracle8
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to the Oracle8 product
An Oracle8 glossary


 

© 1999-2009 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information