IX223G | Informix 12.10 Database Administration

 

Overview

In this course, students will learn the basic concepts of data management with Informix 12.10.  They 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.

 

Learning Journeys that reference this course:

  • Informix

 

Audience

The main audience for this course is Informix Database Administrators.  It is also appropriate for Informix System Administrators and Informix Application Developers.

 

Prerequisites

Students in this course should satisfy the following prerequisites:

  • IX101 - Introduction to Informix terminology and data types (or equivalent experience or knowledge)
  • Knowledge of Structured Query Language (SQL)
  • Experience using basic Linux functionality

 

Key topics

Unit 1 - Creating databases and tables

Unit 2 - Altering and deleting databases and tables

Unit 3 - Creating, altering, and dropping indexes

Unit 4 - Managing and maintaining indexes

Unit 5 - Table and index partitioning

Unit 6 - Maintaining table and index partitioning

Unit 7 - Cost-based query optimizer

Unit 8 - Updating statistics and data distributions

Unit 9 - Managing the optimizer

Unit 10 - Referential and entity integrity

Unit 11 - Managing constraints

Unit 12 - Modes and violations detection

Unit 13 - Concurrency control

Unit 14 - Data security

Unit 15 - Views

Unit 16 - Introduction to stored procedures

Unit 17 - Triggers

IX223G | Informix 12.10 Database Administration

SKU: IBM-IX223G
NETEC
DESCUENTOS Y PAGOS
Suscríbase a nuestro newsletter
  • Facebook Netec
  • Twitter Netec
  • Linkedin Netec
  • Youtube Netec
  • Instagram Netec

Copyright 2019 Netec. Todos los derechos reservados.