This complimentary series of nine tutorials has been developed to help you prepare for the IBM® Informix® Dynamic Server (IDS) 11.50 Fundamentals certification exam (555). This certification exam will test your knowledge of entry-level administration of IDS 11.50, including basic SQL (Structured Query Language), how to install IDS 11.50, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and data replication technologies and purposes. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
Tutorials
Each tutorial should take about an hour to complete. You can take the tutorials online or download a PDF.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 1: IDS planning and installation
Learn how to plan, install, and start an IDS instance—a great place to start to successfully understand and use IDS.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 2: Security
Get an introduction to the concepts of authentication, authorization, and privileges as they relate to IDS 11.50.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 3:
DBMS instances and storage objects
Learn how to identify and connect to Informix database servers and databases. Learn also how to create and configure database storage objects, and gain an understanding of system databases and system catalog tables.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification
preparation, Part 4: IDS tables, views, and indexes
Gain an understanding of the objects you can create and use inside Informix Dynamic Server to hold raw data, improve performance, and maintain data integrity.
- Informix Dynamic Server 11.50 Fundamentals Exam 555 certification
preparation, Part 5: Using SQL
Get an introduction to SQL, and learn how Informix Dynamic Server uses SQL to manipulate data in a relational database.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification preparation, Part 6: Data concurrency
Gain an understanding of the data concurrency mechanisms in IDS to help maintain the integrity of your data in a multi-user environment.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification
preparation, Part 7: Tools and utilities
Learn about the tools and utilities available in Informix Dynamic Server that make monitoring and administering IDS easier.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification
preparation, Part 8: Backup and restore
Understand essential Informix Dynamic Server 11.50 database backup and restore concepts. Learn how to use the ON-Bar and ontape utilities to back up and restore database server data.
-
Informix Dynamic Server 11.50 Fundamentals Exam 555 certification
preparation, Part 9: Informix replication technologies
Explore the different replication and high availability technologies offered by Informix Dynamic Server. Learn how to set up an IDS server for replication and high availability.


