Before you start
This tutorial gives an overview of the Informix Dynamic Server (IDS) implementation of Structured Query Language (SQL).
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, how to install IDS 11.50, 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 introduces you to SQL and helps to give you a good understanding of how IDS uses SQL to manipulate data in a relational database.
This tutorial is designed to help you become familiar with:
- How to perform a query on a table
- How to manipulate data using SQL
- The concept of a transaction
- The use of stored procedures and user-defined routines
This tutorial is written for IDS database professionals whose skills and experience are at a beginning to intermediate level. You should be familiar with basic database concepts.
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).