Chapter 1: "Informix databases" covers the fundamental concepts of databases and define some terms that are used throughout the subject
Chapter 2:“Composing Simple SELECT Statements,” shows how you can use the SELECT statement to query and retrieve data. This chapter discusses how to tailor your statements to select columns or rows of data from one or more tables, how to include expressions and functions in SELECT statements, and how to create various join conditions between relational database tables.
Chapter 3: “Composing Advanced SELECT Statements,” increases the scope of what you can do with the SELECT statement and enables you to perform more complex database queries and data
manipulation.
Chapter 4:“Modifying Data,” discusses solutions to problems such as the security of user access to the database and its tables. It also explains how to minimize the risk of system failure caused by
external events.
Chapter 5:“Programming with SQL,” is an introduction to the concepts that are common to SQL programming.
Chapter 6:“Modifying Data Through SQL Programs,” covers the issues that arise when a program needs to modify the database by deleting, inserting, or updating rows.
Chapter 7:“Programming for a Multiuser Environment,” addresses concurrency, locking, and isolation level issues as they pertain to a database that is accessed simultaneously by multiple users.
Chapter 8:“Building Your Data Model,” contains a cursory overview the first step towards constructing a data model—a precise, complete definition of the data to be stored.
Chapter 9:“Implementing Your Data Model,” covers the decisions that you must make to implement the data model.
Chapter 10:“Understanding Complex Data Types,” describes row types and collection types and shows the different ways you can use these types. The chapter also explains inheritance and shows how to
create an inheritance hierarchy for row types and tables.
Chapter 11:“Granting and Limiting Access to Your Database,” discusses how you can restrict access to your database. By using statements such as GRANT, REVOKE, and CREATE VIEW, you can
deny access to some or all of the data to specified users.
Chapter 12:“Accessing Complex Data Types,” shows how to query and modify complex data types. The chapter provides examples of SELECT, UPDATE, INSERT, and DELETE operations on row types and
collection types.
Chapter 13:“Casting Data Types,” introduces user-defined routines. This chapter explains the concepts of routine overloading and routine resolution and includes two examples that show how to
create and register casts to convert between data types. The chapter also describes how to use SQL to register and use external routines.
Chapter 14:“Creating and Using SPL Routines,” discusses how you can write procedures usingSQL and additional statements belonging to the Stored Procedure Language (SPL), and store the procedures in
the database. These stored procedures are effective tools for controlling SQL activity.
Chapter 15:“Creating and Using Triggers,” describes the purpose of each component of the CREATE TRIGGER statement, illustrates some uses for triggers, and describes the advantages of using a stored procedure as a triggered action.
