FasTrack Informix Dynamic Server (IDS) Course
Course Description
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.
Course pre-requisites:
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
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
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| - | - | - | - | - |
View full schedule of Informix courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Database Training and bespoke Database courses