PTR - People, Training ResultsPeople, Training, Results
Independent Technical IT Computer Training Courses

Scheduled Classroom based Training Courses

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

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.


Course Fee = £1900   (excl.VAT)

Scheduled course dates

September 2010October 2010November 2010December 2010January 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