Database Courses > FasTrack Informix Dynamic Server (IDS) Training Course

This course is designed for database administrators and database server administrators moving from other relational databases to Informix Dynamic Server (IDS) or those who have a good knowledge or relational databases and need to get up and running quickly. Key topics are taken from 2 other courses normally totaling 10 days, so not all topics from the full courses can be covered and it is very fast paced.

Use of Unix file system and vi editor - basic vi commands only are necessary or Windows file sytem.

Knowledge of Unix or Windows administration would also be useful

Topics covered on the 5 day FasTrack Informix Dynamic Server (IDS) course

SQL

• What is SQL and sample database
• Single Table Select
• Select Clauses
• Joins
• Subqueries

IDS Database Administration

• Terminology
• Creating and altering databases and tables
• Indexes
• Partitioning
• The opimiser and statistics
• Data Integrity
• Concurrency control
• Data security
• Views

IDS System Administration

• Architecture
• Configuration
• Client-server Connectivity
• Monitoring
• Memory Management
• Virtual Processors and threads
• Managing and monitoring disc
• Logging
• Buffer pool
• Fault Tolerance
• Backup and Restore - ontape
• Temp files and tables
• Performance features
• Monitoring user activity
• Registering a DataBlade

   (excl.VAT)