Test 000-718: IBM U2 UniVerse V10.2 Administration

Course title: IBM UniData and UniVerse Database Programming
Course duration: 4 days
Course number: U2120
Abstract: Build on your existing programmer skills by exploring many of the diverse commands and options available with IBM UniData and UniVerse programming. In the lecture and hands-on lab exercises, focus on learning how to use the commands and options that lead to increased programming proficiency and productivity. Explore fundamentals of the development environment, through the primary system tools, and the intricacies of manipulating the native data structures of strings, dynamic arrays, and multivalued fields.

Course title: IBM U2 UniVerse Fundamentals
Course duration: 4.0 Days
Course number: U2800
Abstract:

This course provides an introduction to the UniVerse extended relational database environment. Learn about the tools and commands used to input data into storage files, modify data records, and extract the records to produce and print reports. Build a sample database file, including data input through the editor and reporting using the RetrieVe processor. Explore UniVerse commands that perform ad hoc queries, generate and print reports, and create paragraphs to gather or report business information. This course is the classroom delivered version of 3U800 Instructor Led Online course. This course replaces course UV900.

Course title: Using SQL with the IBM UniVerse Database
Course duration: 3.0 days
Course number: UV140
Abstract:

In this hands-on, introductory course, focus on how to use SQL with the IBM UniVerse database. Learn how to build, modify and delete table definitions and rows into tables. Learn how the extended relational database model used by UniVerse can be reported on, using standard SQL commands. Build views and subviews to allow multiple perspectives of the data. Explore the basics of SQL based security.

See Remarks for Special Note.

Application users, database and system administrators, and programmers, who have recently purchased, or who are considering purchasing, IBM UniVerse on UNIX or Windows NT.

Course title: IBM UniVerse Administration
Course duration: 4.0 days
Course number: UV904
Abstract:

Develop the system administration skills you need to manage, maintain, and troubleshoot UniVerse systems. Gain experience analyzing sample database files and system parameters to tune and optimize performance. Learn how to modify terminal definition files to correct terminal behavior, such as proper arrow key and function key operation. Learn about and use the different data file types, alternate keys, and transaction logging in lecture and lab exercises. Also, explore other administrative functions, such as print spooler configuration and control, and user process control.

See Remarks for Special Note.

System administrators and operators and programmers.

Course title: IBM Universe Theory and Practice
Course duration: 4.0 days
Course number: UV910
Abstract:

Expand on the concepts learned in IBM UniVerse Administration (UV904).

Get the information you need to make further administrative decisions regarding configuration, tuning, and monitoring. Explore the interaction between the UNIX operating system and the UniVerse database environment, including disk file access, memory usage, and interprocess communications. Develop an understanding of the UniVerse architecture to aid in troubleshooting and problem avoidance.

See Remarks for Special Note.

This is an advanced course for system administrators, operators, and programmers.

Course title: IBM UniVerse ODBC
Course duration: 2.0 days
Course number: UV911
Abstract:

Learn how to connect to and retrieve data from the UniVerse database using Microsoft Open Database Connectivity (ODBC). In addition, learn how to prepare the UniVerse database for access by ODBC. In this hands-on workshop, learn about both UNIX and NT platforms.

See Remarks for a Special Note.

End users and analysts.