u2 Training

Register an interest in UniVerse or UniData training course

UniData Fundamentals Course

This course focuses on hoe to use UniData. Learn the process and theory of querying the database and creating specialised reports. Build a database file from scratch, including creating a data dictionary, entering data, and then exchanging data with other database files. Learn the Environement Control Language (ECL) and the Alternative Editor. Explore advanced ECL topics. A module on Process Control Language is also included.

Skills you will learn

– probe a data file using LIST and SORT

– use ECL and the Alternative Editor to build a database file

– create a data dictionary

– add virtual attributes to files that perform mathematical calculations and import data from other files

– use the MERGE-LIST command to create select lists and merge two lists

– Create and maintain alternative key indexes

– use ECL to run background processes at scheduled times

– use basic administration commands including COMO and STATUS

– use Process Control Language to link several statements into one piece of code

– describe the UniData data model

Who should attend

Applications users, database and system administrators, programmers. No prerequisite

Length

3 days

UniData System Administration for UNIX

In this course, database and systems administrators learn how to manage a UNIX-based UniData relational database management system. Learn how to install and configure the software, manage data files, define and maintain security, and tune system performance. The relationship between UniData and the UNIX operating system is also covered.

Skills you will learn

– install UniData

– configure UniData in a UNIX environment

– manage data files and accounts

– define and maintain system security

– backup and restore data

– monitor and tune system performance

– work with multi-version UniData environments.

Who should attend

Database and system administrators. Prerequisites are UniData Fundamentals (or equivalent knowledge) and a basic understanding of UNIX.

Length

5 days

UniData System Administration for Windows

The same as for UniData System Administration above but for the Windows environment.

UniVerse Fundamentals

Learn about the UniVerse tools and commands used to input data storage files, modify data records and extract records to produce and print reports. Build a sample database application including data input through the UniVerse REVISE processor and reporting using the RETRIEVE processor. Create menus of stored reports and commands. Learn UniVerse commands that perform ad hoc queries, generate and print reports, and create stored procedures to gather business information.

Skills you will learn

– use common UniVerse commands

– create data files and dictionaries

– enter and update data records

– use the UniVerse Records Editor (ED)

– create pre-stored UniVerse commands

– create menus of commands

– format and print simple reports

– use RETRIEVE commands to access data records

– list and display the available data fields in a database file

– create and print custom reports

– define sentances and paragraphs with prompting for repetitive tasks

– define I-Descriptors and correlatives for advanced reporting

Who should attend

End users, managers, database and system administrators, programmers.No prerequisite

Length

3 days

UniVerse System Administration for UNIX

This course helps database and systems administrators develop the skills required to  manage and maintain and trouble shoot a UNIX-based UniVerse relational database management system. Gain experience analysing sample database files and system parameters to tune and optimise performance. Learn how to modify terminal definition files to correct terminal behaviour. Use different data file types, alternative keys, and transaction  logging addressed in lecture and lab exercises. Learn administrative functions such as print spooler configuration and control and user process control.

Skills you will learn

– configure UniVerse for improved system performance

– determine the optimal file system layout

– create and maintain database files-static, dymanic, distributed

– create alternative keys for database files

– set up and use transaction logging

– add peripherals to the UniVerse environment

– modify terminal definitions for UniVerse

– monitor and control user processes and locks

– control printing and print spooler

– calaogue programs and use shared memory.

Who should attend

Database and system administrators. Prerequisites are UniVerse Fundamentals (or equivalent knowledge) and a basic understanding of UNIX.

Length

5 days

UniVerse System Administration for Windows

The same as for UniVerse System Administration above but for the Windows environment.