|
This course is for database administrators and application developers
who will be responsible for designing and developing Informix databases.
The participants will lean how to create and optimize Informix databases.
The course includes sections on advanced SQL topics and how to use
triggers and stored procedures. This is a five-day course and includes
the following topics:
Database Schema Design
- Informix OnLine data types
- Calculating table & database sizes
- Using the Informix system tables
- Using data, referential, & entity integrity
- Using referential constraints
- Managing isolation levels & locking levels
- Constraint transaction modes
Optimization
- Using update statistics & distribution schemas
- Table fragmentation across multiple disk drives
- Optimizing disk & database space layout
- Optimizing performance with indexes
- Optimizing client/server transactions
- Using Parallel Database Query (PDQ)
- Reading the query plan
- Using Set Explain to optimize queries
Advanced Informix SQL
- The SQL select statement
- Filters & conditional expressions
- Relationships (joins, outer joins, and unions)
- Aggregates & other advanced features & functions
- Data Manipulation, concurrency, & definition commands
Embedded Informix SQL
- Using SQL statements in programs
- Using the SQLCA structure
- Retrieving multiple rows with cursors
- Developing programs with dynamic SQL
- Executing SQL statements
- Using record locking & concurrency
Stored Procedures
- Creating stored procedures
- Variables
- Flow control
- Error handling
- Running stored procedures
- Debugging stored procedures
- Privileges and stored procedures
Triggers
- Creating triggers
- Specifying trigger events
- Creating trigger actions
- Using stored procedures in triggers
Prerequisites:
Requires a basic understanding of Informix, UNIX and vi commands,
SQL databases, and prior experience with Informix SQL.
|
