Provided by: 123-CBT Computer Based Training Oracle9i Database Admin Manage Data Storage Click here for more information or to take this course

---

---

Training Provided by 123-CBT Computer Based Training

Course Overview

This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.

Learn To

• Identify the row storage method used by the various tables and the components of the row structure in an Oracle database.
• Identify the features of the Oracle datatypes and ROWID.
• Identify the guidelines for creating tables and the situations resulting in row chaining, and create tables.
• Identify the characteristics of table parameters and high-water mark, change the parameter value, manually allocate extents, validate table structure and detect row migration.
• Identify the effects of truncating a table, drop and truncate a table, and deallocate free apace.
• Retrieve the table, extent and row location information from data dictionary.
• Identify the features of index-organized tables and alter tables.
• Identify the various types of database triggers and the methods to disable and enable the triggers.
• Identify the guidelines for implementing constraints and create the two types of constraints.
• Disable, enable and drop constraints and triggers in the validate and the novalidate mode, and identify the steps for using the EXCEPTIONS table.
• Retrieve constraint, constraint columns, PK-FK relationship information and trigger information by using Oracle SQL*Plus Worksheet.
• Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables.
• Identify the uses of the export and import utilities, the export modes, and the export paths.
• Reorganize data using export and import, identify the features and process of transportable tablespaces and the restrictions while using them.

Audience

The intended audience for this course include Database administrators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).

Content Emphasis

Conceptual

Deployment Options

Accreditation

NASBA credits: 4 CPE Credits

Language Options

American English

Total Learning Time

6 to 8 hours

64314 Objectives

Unit 1: Managing Tables

---

Training Avaliability and Delivery

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English

About 123-CBT Computer Based Training - Training Provider

More Oracle9i Training from 123-CBT Computer Based Training

• Oracle 9i New Features Backup Recovery Performance Tuning
• Oracle 9i New Features Database Administration
• Oracle9i Database Admin Create a Database
• Oracle9i Database Admin Manage an Instance
• Oracle9i Database Admin Manage Security
• Oracle9i Database Admin Manage Storage Structures
• Oracle9i Database Admin Perform Database Backups
• Oracle9i Database Admin Recover Databases
• Oracle9i Database Admin Set Up Oracle Net Services
• Oracle9i Database Fundamentals I Curriculum
• Oracle9i Database Fundamentals II Curriculum
• Oracle9i Database Performance Tuning Curriculum
• Oracle9i Peformance Tuning Managing Memory and Disk I O
• Oracle9i Performance Tuning Architecture Strategy
• Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention
• Oracle9i SQL Basic SELECT Statements
• Oracle9i SQL Curriculum
• Oracle9i SQL Data Retrieval Techniques
• Oracle9i SQL DML and DDL