India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

IBM Informix DBA Online Training

Pre-requisites
Basic knowledge on Structured Query Language (SQL).
Introduction to Informix Dynamic Server (IDS) Terminology
  • Define basic Informix Dynamic Server terms
  • Query the sysmaster database for information about the server
IDS Installation & Setup
  • Identify the right product
  • Extract & Install the IDS product
  • Setup raw chunks for space
  • Setup Environment
  • ONCONFIG parameter changes
  • SQLHOSTS file changes
  • Instance creation
  • Bounce Informix Server Instance
  • Switching between server modes
Managing disk space
  • Physical Units
  • Logical Units
Shared memory
  • Resident portion
  • Virtual portion
  • Message portion
Monitoring Message log file
Managing configuration parameter file
SMI Tables
Monitor/Manage Database Server activity using tools
  • onstat
  • onmode
  • oncheck
  • onparams
  • onmonitor
  • oninit
  • ondblog
  • onspaces
Backing up data and logical log files (ontape, onbar) Data migration tools
  • load/unload
  • dbexport/dbimport
  • onunload/onload
  • dbschema
Checkpoints
finder utility Update statistics SET EXPLAIN Database Logging
  • Physical Logging
  • Logical Logging
Lock Management Session Management IDS Isolation Levels IDS Data Types
  • Identify the Informix data types
  • Choose the appropriate data type for a data column
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
  • Use the dbschema utility
Altering and Deleting Databases and Tables
  • Drop a database
  • Drop a table
  • Alter a table
  • Convert a simple large object to a smart large object
Create, Alter, and Drop 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
  • ist the ways to fragment a table
  • Create a fragmented table
  • Create a detached fragmented index
  • Describe 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
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
  • Create and execute a trigger
  • Drop a trigger
  • Use the system catalogs to access trigger information

If you want to know more about IBM Netezza Developer Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com