Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases: Working with Databases

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

Previous courses from 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 enable the student to create and manage databases and tables

Learning Objectives

Choose between the two types of OnLine database. Choose between logging modes. Create and drop an OnLine database. Describe the system catalog. Choose the appropriate datatype. Manage extents. Calculate extent sizes. Create and manage tables. Identify lock modes.

Topics Covered

Creating a database - Choosing a database - Creating and dropping databases - Hands-on: Creating a logged database - System catalog tables Datatypes - Character datatypes - Numeric datatypes - Date datatypes - BLOBs Creating tables - Using extents - Calculating extent sizes - Storing table data - Creating a table - Hands-on: Creating a new table