Mindmajix
For individuals


Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend


  • Start training at your convenient time
  • For business


    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    The IBM Informix server supports the object-relational model that provide data type support and language extensions that permit performance domain specific queries and efficient storage for datasets. IBM Informix 12.10  was code-named “Centaurus” during development enhanced built-in index compression, integration of JSON collections and permitting database objects to be partitioned across multiple servers in a grid. It supports heterogeneous clusters and deployment options including very high levels of data redundancy with fault tolerance. IBM Informix Training increase advanced Informix performance tuning skills of the student.

    IBM Informix Training Overview

    We are specialized in Informix training where students get to enhance skills to create index strategies so as to improve performance, implement referential and entity integrity, manage user end concurrency and triggers. The sessions are designed with interactive explaination of examples of real-time scenarios by proficient and certified experts followed by regular exercises.

    IBM Informix Training Curriculum

    Define basic Informix Dynamic Server terms
    Query the sysmaster database for information about the server

    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

    Physical Units
    Logical Units

    Resident portion
    Virtual portion
    Message portion

    onstat
    onmode
    oncheck
    onparams
    onmonitor
    oninit
    ondblog
    onspaces

    load/unload
    dbexport/dbimport
    onunload/onload
    dbschema

    Physical Logging
    Logical Logging

    Identify the Informix data types
    Choose the appropriate data type for a data column

    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

    Drop a database and Drop a table
    Alter a table
    Convert a simple large object to a smart large object

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

    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

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

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

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

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

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

    Create and execute a trigger
    Drop a trigger
    Use the system catalogs to access trigger information

    Faqs

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    New York, New jersey, Dallas, Seattle, Baltimore, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, St. Louis, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Alexandria, Sunnyvale, Santa clara, Carlsbad, San Marcos, Franklin,Tacoma, Bellevue, Austin, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubbai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…

    SEND A QUERY

    Course Reviews

    4.5

    112 ratings
    • 578
    • 417
    • 311
    • 24
    • 11

    Drop Us A Query


    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.