Before you start
This tutorial teaches you about the objects that can be created and used inside of a database. Some of these objects are there to hold the raw data, while others exist for pure performance reasons, and still others help keep the integrity of the data intact.
The objects being discussed in this tutorial are tables, views, indexes, triggers, constraints, synonyms, and sequences.
This tutorial discusses a little bit about their purpose as well as how to create them.
The tutorial then ends with a little discussion on a built-in tool to print out the SQL statements that could help recreate or duplicate the objects.
This complimentary series of nine tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11.50 Fundamentals certification exam (555). This certification exam will test your knowledge of entry-level administration of IDS 11.50, including basic SQL (Structured Query Language), how IDS 11.50 is installed, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and data replication technologies and purposes. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
This tutorial is dedicated to covering the topics in Section 4 of the exam titled "IDS Tables, Views, and Indexes."
When you finish this tutorial, you should be able to do the following:
- Explain what the purpose of a database table is and how to create one
- Explain the difference between a non-fragmented, fragmented, and partitioned table
- Describe what a constraint is and the different types of constraints available for use in an Informix database
- Explain how to create constraints in the database
- Describe the concept of a view and how it differs from a table
- Explain how to create a view
- Describe what role indexes play in a database and how to create them
- Explain what synonyms and sequences are, and how to create them
- Describe what a database trigger is and how to create one
- Explain how to print out the SQL statements (schema) of the objects in the database
This tutorial is written for up-and-coming database administrators (DBAs). Although some basic database concept knowledge may help, it is not necessarily needed.
To complete this tutorial, you do not need a copy of IDS. However, if you have one available to use, you will definitely get more out of the tutorial. If you don't have a copy already, you can download the free trial version (see Resources). .