Поиск
Расписание курсов
Поиск

+7 (495) 913-75-75 доб.221

+7 (495) 668-08-42

+7 (812) 441-33-15

+7 (901) 374-07-97

+7 (383) 263-31-70

+7 (861) 944-79-98

+7 (391) 272-07-31

Почта

edu@fors.ru

Oracle9i Database Administration: Manage Data Storage

Посмотреть расписание этого курса
  • Код курса: 64314
  • Длительность: 8 д.
  • Цена: 4 480 р.
Записаться Добавить в корзину

Описание курса

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).

Записаться на курс: Oracle9i Database Administration: Manage Data Storage

Начало курса:



Поделиться
Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:

Выберите дату начала курса: