Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provides the best learning Environment. Obtain all the training by our expert professionals which is having working experience from Top IT companies.
The Training in is every thing we explained based on real-time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.
Course Content
IBM Informix Training Introduction:
The IBM Informix server supports an object-relational model that provides data type support & language extensions that permit performance of domain-specific queries & efficient storage for the datasets. IBM Informix 12.10 was code-named “Centaurus” during development of enhanced built-in index compression, integration of JSON collections & permitting database objects to be partitioned across multiple servers in a grid. IBM Informix Training increase advanced Informix performance tuning skills of the student.
IBM INFORMIX ONLINE COURSE CONTENT:
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
MANAGING DISK SPACE
- Physical Units
- Logical Units
SHARED MEMORY
- Resident portion
- Virtual portion
- Message portion
MONITOR/MANAGE DATABASE SERVER ACTIVITY USING TOOLS
- onstat
- onmode
- oncheck
- onparams
- onmonitor
- oninit
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
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
ALTERING AND DELETING DATABASES AND TABLES
- Drop a database and Drop a table
- Alter a table
- Convert a simple large object to a smart large object
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
For More Details