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.

Location, current term course



Brno
10/12/2020 - 10/15/2020
Order
1/4/2021 - 1/7/2021
Order
VirtualPro
9/8/2020 - 9/11/2020
Order
11/3/2020 - 11/6/2020
Order
Vlastní Školení na míru (termín, lokalita, obsah, délka)

The course:

Hide detail
  • 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
Assumed knowledge:
You should have a working knowledge of Structured Query Language (SQL).
Schedule:
4 days (9:00 AM - 5:00 PM )
Course price:
1 685.71 € (2 039.71 € incl. 21% VAT)
Language:
English