|
|
|
 |
IN757Advanced Structured Query Language
In the given course external connections (outer join) and correlated subrequests and other constructions SQL of the raised complexity are considered. With the help of practical examples methods of an estimation of productivity represented. To the additional questions included in the given course, principles of operation of the optimizer of inquiries, the analysis of his strategy concern. Having got acquainted with the schedule of inquiries created by the optimizer, you learn use directives of the optimizer accessible in Informix Dynamic Server
After learning course you can
- To use complex SQL operators
- To understand a memory allocation and how to use this new property in Informix Dynamic Server
- To describe the tasks connected to a problem of 2000, behaviour Informix Dynamic Server, and to use toolkit DBCENTURY for adjustment of operation of
- Correctly to use defined SQL transactions
- To use directives of the optimizer
- To parse productivity of yours SQL operators.
Contents of course
- Introduction
- the Browse of bases of structured query language SQL
- Optimizer SQL
- Effect on the optimizer
- Complex connections (complex joins)
- Subrequests
- Transactions and journalizing
- Handle of cursors
- Some questions of productivity
- Introduction in stored procedures
- Creation and fulfilment of stored procedures
- Operators of language of stored procedures
- Processing of exceptions for stored procedures
- Questions of execution of stored procedures
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-111 ?????? ??? ??????
Given cource inserted in next comlex programs:
Dadabases Basics Complex programm
Education coast on cource - USD 390
Cource duration (days) - 3
|
|
