Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases: Advanced Database Maintenance

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers, database and system administrators, and technical support personnel

Prerequisites

The previous course in the Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases suite; the course Relational Principles and the SQL Programming suite; a knowledge of UNIX is necessary (refer to the UNIX curriculum); an understanding of client/server technologies, though not a strict prerequisite, would be useful

Course Aim

To familiarize the student with some of the more advanced database utilities

Learning Objectives

Create and drop views. Import and export data between the database and disk. Alter database tables. Reclaim data space. Modify database elements.

Topics Covered

Views - Creating and dropping views - Uses of views - Restrictions on views - Hands-on: Creating a view Table maintenance - The ALTER TABLE statement - Hands-on: Altering a table - Data-space reclamation - The dbschema utility - Renaming and dropping tables Data-handling utilities - Moving a database as ASCII - Using dbexport - Using dbimport - The dbload utility - Moving data in binary format