Informix DBA Home
 Informix DBA eCertifications

The following outline describes the content of the Informix DBA eCertification.  To qualify as a Certified Informix DBA, you must pass the examination with a score of 60% or higher. To be certified as a Master Informix DBA, you must obtain a score of 75% or higher.

Topic

Subtopic

Additional Concepts

Concept

Additional Concepts

Replication

Architecture

APIs

Architecture

Concept

Architecture

Data Dictionary

Architecture

Integration Approaches

Architecture

Role of RDBMS

Architecture

Schema

Cursors

Concept

Design Funamentals

Concept

Design Funamentals

Data Modeling

Design Funamentals

Database Denormalization

Design Funamentals

Logical vs. Physical

Design Funamentals

Normalization

Design Funamentals

Normalization Forms

Design Funamentals

Redefining Tables

Indexes

Concept

Indexes

Considerations

Record Locking

Concept

Record Locking

Deadlocks

Performance Measuers

Common Bottlenecks

Performance Measuers

Common Problems/Causes

Performance Measuers

Concept

Performance Measuers

Dimensions

Performance Measuers

Tradeoffs

Procedures

Concept

Referential Integrity

Cascades

Referential Integrity

Concept

Referential Integrity

Keys

Roles

DBA

Roles

System Administrator

SQL Basics

Basic Rules

SQL Basics

Concept

SQL Basics

Result Sets

SQL Functions

Examples

SQL Object Creation

Concept

SQL Object Creation

Table, View, Index Mgmt

SQL Programming Constructs

Batches

SQL Programming Constructs

Conditions

SQL Queries

Table Joins

Transactions

Concept

Transactions

Recoverability

Triggers

Concept

Table Views

Concept

Informix DBA  Content Outline

Topic

Subtopic

Backup & Recovery

Concepts

Backup & Recovery

DBEXPORT & DBIMPORT

Backup & Recovery

load & unload

Backup & Recovery

ontape

Configuration

Configuration files

Configuration

Connectivity

Configuration

Disk

Configuration

Multiple Instances

Configuration

Server Components

Configuration

Shared Memory

Database Administration

Indexes

Database Administration

Indexing

Database Administration

Security

Database Administration

Tables

Installation

Environment

Logging

Database logging modes

Logging

Logging Events

Logging

Logical logs

Logging

Physical logs

Monitoring Activity

Disk

Monitoring Activity

Disk activity

Monitoring Activity

Resource utilization

Monitoring Activity

Session activity

Performance Management

Fragmentation

Performance Management

Indexing

Performance Management

Isolation levels

Performance Management

Locking

Performance Management

Monitoring

Performance Management

Parallel Data Queries

Resource Management

Consistency checking

Resource Management

Disk

Resource Management

Shared memory

Server Administration

Fast recovery

Server Administration

Flushing activity

Server Administration

Server modes

Server Administration

Virtual processors

All eCertification examinations are delivered through the web and use computer adaptive testing (CAT), in which the degree of complexity for questions areas based on previous answers.  Additionally, questions are selected from large question banks, so that it is not productive to memorize questions. 

The expected time to complete the Informix DBA eCertifications examination is 60 minutes.  In addition to registration with eCertifications.com, all certified professionals may use one of the logos below on their resume followed by a professional certificate which is suitable for framing.

Informix DBA Informix DBA - Master

 

 


This page and its contents are Copyright 2010- www.ecertifications.com.
All Rights Reserved.