Comentarios sobre Curso de Managing and Optimizing IBM Informix Dynamic Server Databases FN848XMX - Presencial - Álvaro Obregón - CDMX - Ciudad de México
-
Objetivos del curso
Gain experience creating, modifying, and removing databases, tables, and indexes. Learn how to control security, maintain data integrity, maintain concurrency control, and improve performance in the IBM Informix Dynamic Server environment.
-
Curso dirigido a
This is a basic course for IBM Informix Dynamic Server database and system administrators, application developers, and technical support individuals.
-
Titulación
IBM Certification for Managing and Optimizing IBM Informix Dynamic Server Databases
-
Contenido
KEY TOPICS
- Introduction to IBM Informix Dynamic Server terminology
- IBM Informix Dynamic Server data types
- Creating databases and tables
- Altering and deleting databases and tables
- Create, alter, and drop indexes
- Managing and maintaining indexes
- Table and index partitioning
- Maintaining table and index partitioning
- Cost-based query optimizer
- Updating statistics and data distributions
- Managing and optimizer
- Referential and entity integrity
- Managing constraints
- Modes and violation detection
- Concurrency control
- Data security
- Views
- Introduction to stored procedures
- Triggers
*Precio no incluye IVA