logo
Powered by QM on a Rpi server
Home
About OpenQM
Sales and Downloads
Help and Support
About
Login

UniVerse and Unidata Developer

The Developer course is available for both UniVerse and Unidata. It is intended for users involved in application development and covers all development areas of the core database product except for programming which has a separate course. The course is also relevant for users in a system administration or management role.

The course includes many practical exercises to explore the topics presented and is accompanied by a detailed student manual which will be a useful book for later reference.

The main topics covered are:

The multivalue data model. This module discusses the general relational database model and the extensions to provide the multi-valued fields that make this database so powerful and easy to use. This section is primarily intended as revision for students who have not recently taken the Essentials course.

Dictionaries: I-type records. This module covers development of virtual attributes stored in I-type dictionary items. The module includes all of the basic concepts covered on the Essentials course and then builds on these to explore the more advanced features of I-type expressions.

Query processing. This is the main module of the course and covers all of the major features of the query processor. Built around many example queries and practical exercises, the module explores the query processor verbs, the selection clause, the sort clause, the display clause, and reporting options. Field modifiers, arithmetic operations and breakpoints are discussed in detail. The module also includes an extensive discussion of select lists and the associated commands.

Alternate key indices. This module discusses the substantial performance improvements that can be achieved by use of alternate key indices. The procedures for creating, testing and deleting indices are discussed together with a description of how indices are used by the query processor. The module also includes a brief discussion of related topics applicable to system administrators and to application programmers.

The VOC file: Paragraph development. Building on the basic features of paragraphs introduced in the Essentials course, this module explores inline prompts, the DATA statement, conditional processing and loop constructs.

Menus. This module discusses the types of menu and their components. Creation and maintenance of menus using the menu processor is explored in detail. There is also a brief discussion of Motif style menus (UniVerse only).

Database design exercise. This exercise brings together all topics from this course and many from the Essentials course to take the student through the process of designing a simple database together with reports and a menu front end.