Informix 11.7 Database Administration (IX222CZ)

IBM, DB2, Informix

In this course, you will learn the basic concepts of data management within Informix. You will learn how to determine correct data types; how to create, manage, and maintain tables and indexes; how the Informix optimizer works; how to manage data; and how to use the SET EXPLAIN feature to determine query effectiveness.

Lokalita, termín kurzu



Brno
online
Vlastní

Náplň kurzu:

Skrýt detaily
  • 1. Introduction to Informix Terminology
  • 2. Informix Data Types
  • 3. Creating Databases and Tables
  • 4. Altering and Deleting Databases and Tables
  • 5. Create, Alter, and Drop Indexes
  • 6. Managing and Maintaining Indexes
  • 7. Table and Index Partitioning
  • 8. Maintaining Table and Index Partitioning
  • 9. Cost-based Query Optimizer
  • 10. Updating Statistics and Data Distributions
  • 11. Managing the Optimizer
  • 12. Referential and Entity Integrity
  • 13. Managing Constraints
  • 14. Modes and Violation Detection
  • 15. Concurrency Control
  • 16. Data Security
  • 17. Views
  • 18. Introduction to Stored Procedures
  • 19. Triggers
Předpokládané znalosti:
You should have a working knowledge of Structured Query Language (SQL).
Časový rozvrh:
4 dny (9:00hod. - 17:00hod.)
Cena kurzu:
47 200,00 Kč (57 112,00 Kč včetně 21% DPH)
Jazyk:
English