Informix - Database Administration Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

In Informix - Database Administration training course, you will learn the basic concepts of data management with Informix. You will learn how to create, manage, and maintain tables and indexes; how the Informix Optimizer works; and how to use the SET EXPLAIN feature to determine query effectiveness.

By attending Informix - Database Administration workshop, delegates will learn to:

Create and maintain databases, tables, and indexes
Estimate size and extent requirements for tables and indexes
Create index strategies to improve performance
Create and maintain table and index partitioning (fragmentation)
Implement referential and entity integrity
Manage database and table modes
Manage violations logging
Describe how the optimizer builds an optimal query plan
Use the SET EXPLAIN feature to capture optimizer query plans
Use directives and environment variables to influence the optimizer
Optimize the query plan using UPDATE STATISTICS
Manage end-user concurrency
Use permissions and roles to manage data security
Create and use views
Manage smart large objects
Create and manage triggers

Knowledge of Informix terminology and data types
Working knowledge of Structured Query Language (SQL)
Experience using basic Linux functionality

This Informix - Database Administration class is for Informix Database Administrators. It is also appropriate for Informix System Administrators and Informix Application Developers.

Creating databases and tables

Create databases and tables
Determine database logging and storage requirements
Locate where the database server stores a table on disk
Create temporary tables
Locate where the database server stores temporary tables
Use the system catalog tables to gather information
DBSCHEMA, ONCHECK, and ONSTAT

Altering and deleting databases and tables

ALTER
Data space reclamation
Renaming
Dropping

Creating, altering, and dropping indexes

Build an index
Alter, drop, and rename an index
Identify the four index characteristics

Managing and maintaining indexes

Explain the benefits of indexing
Evaluate the costs involved when indexing
Explain the maintenance necessary with indexes
Describe effective management of indexes
Enable or disable indexes

Table and index partitioning

List the ways to fragment a table
Create a fragmented table
Create a detached fragmented index
Understand temporary fragmented table and index usage

Maintaining table and index partitioning

Alter a fragmented table
Alter a fragmented index
Explain how to skip inaccessible fragments

Cost-Based Query Optimizer

Write queries that produce the following index scans: Sequential with a temporary table
Sequential scan with filter; Key-only index scan; Index Scan: lower and upper index filters; Dynamic Hash Join; Key-first index scans

Updating Statistics and Data Distributions

Execute the UPDATE STATISTICS statement and explain the results
Use the system catalogs to monitor data distributions

Managing the Optimizer

Understand how to set OPTCOMPIND
Understand how to set OPT_GOAL
Write optimizer directives to improve performance

Referential and Entity Integrity

Explain the benefits of referential and entity integrity
Specify default values, check constraints, and referential constraints
Determine when constraint checking occurs

Managing Constraints

Determine when constraint checking occurs
Drop a constraint
Delete and update a parent row
Insert and update a child row

Modes and Violation Detection

Enable and disable constraints and indexes
Use the filtering mode for constraints and the indexes
Reconcile the violations recorded in the database

Concurrency Control

Use the different concurrency controls
Monitor the concurrency controls for lock usage
Use the Retain Update Lock feature

Data Security

Use the database, table, and column level privileges
Use the GRANT and REVOKE statements
Use role-based authorization

Views

Create views
Use views to present derived and aggregate data
Use views to hide joins from users

Introduction to Stored Procedures

Explain the purpose of stored procedures
Explain advantages of using stored procedures

Triggers

Working with triggers
Triggers and stored procedures
Dropping a trigger
Cursors and triggers
Triggers and constraint checking
Sysmaster
Managing triggers

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

Informix - Database Administration

COURSE AGENDA