|
|
|
 |
IN848Managing and Optimizing Informix Dynamic Server.2000 Databases
The given course is intended for managers of databases Informix Dynamic Server (IDS) and IDS.2000, and also developers of applications. In course questions of creation of databases, tables and indexes with help INFORMIX Dynamic Server are studied. Safety issues, supports of data integrity, multi-user access, and also improvement of productivity in INFORMIX environment are considered. Questions of migration and reorganization of the data
After learning course you predefined types of the data of server Informix Dynamic Server
are studied can
- To apply - To estimate a size and quantity of extents for tables and indexes
- To apply triggers
- To create databases, tables and indexes
- To select the strategy of improvement of productivity
- To create fragmented tables and indexes
- To provide execution of parallel inquiries (PDQ)
- To understand, As the optimizer creates the schedule of execution of inquiry
- To apply SET EXPLAIN ON directive to obtaining the protocol of solutions of the optimizer
- To use directives and environment variables for handle of the optimizer
- To understand mechanisms of support of multi-user access to databases
- To realize reference integrity and integrity сущностей
- To use the Advanced Big Objects (SLOBs - Smart Large Objects)
- To create and use "representations" (views)
- To inspect safety of the data - To use stored procedures and to improve productivity of their execution
- To know possibilities of various utilities for import / export of the data, and to apply them
Contents of course
- Introduction in administration of databases
- the Terminology connected to product Informix Dynamic Server (IDS)
- Data types of server Informix Dynamic Server
- Creation of databases and tables
- Creation of indexes and operation with them
- the Fragmentation of tables in IDS
- Reference integrity and integrity of essence
- Modes of database objects and detection of violations of integrity
- the Optimizer of inquiries
- Optimization of multi-user access
- Upgrade of statistics and statistical allocations
- Handle of multi-user access
- Safety of the data
- "Representations" (Views)
- Storage of the multimedia information. Smart Large Objects
- Triggers and stored procedures
- Operating conditions for stored procedures and triggers
- Usage of Global Language Support (GLS)
Preliminary preparation
IN611 " Designing of relational databases " IN613 "Structured query language" Knowledge of the editor vi and Unix operating system on a user level (necessary skills can be gained, having heard course 3-day's S215 " Introduction in SCO Unix ").
This course will help you to prepare for the next tests:
660-112 Managing and Optimizing Informix OnLine Dynamic Server Databases
Given cource inserted in next comlex programs:
ADM-IDS-9 Complex programm
Education coast on cource - USD 650
Cource duration (days) - 5
|
|
