Training Brochure - Download as DOC

							                        2007 IBM U2 TRAINING GUID E

Below are the U2 courses offered by Workgroup, with a summary description of what the course offers. The latest IBM
U2 product version is the bases of the course material and will be utilized in the course. Prices, contact details and the
booking form are provided. Such information is also available on the www.utwo.co.za website under ‘training’.

For further information and recommendations feel free to contact any of the team members (011 654-6175/8/9) or the U2
switchboard (011 654-6008) or email training@utwo.co.za.




                                 CO URS E OVERVIEW

                                    WORKGROUP IBM U2 Training
                                     January 2007– December 2007
IBM UniVerse Fundamentals

This course introduces the UniVerse 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 application including data input through the UniVerse REVISE processor and reporting using the RETRIEVE
processor. Create menus of stored reports and commands. This course also covers UniVerse commands that perform
ad hoc queries, generate and print reports, and create stored procedures to gather business information. The UniVerse
RETRIEVE syntax is shown, as well as some ANSI standard SQL query usage.




                                                  www.utwo.co.za
IBM UniVerse BASIC / Database Programming

This course is for programmers who develop code for the Universe BASIC environment or who port applications from
other platforms into Universe BASIC. Learn how to work effectively with the Universe development environment. Use the
Universe tools for code development. Implement and manipulate data structures. Implement transactions, concurrency
controls, and secondary keys. Incorporate advanced commands. Write code to interact with sequential files and
nonterminal devices. Create and use cataloged routines. Control formatting of Input / Output (I/O) from screens, printers,
and storage.

Analyse code and optimize execution using system tools and guidelines.

IBM UniVerse Administration / Core Technologies

This course helps administrators develop the skills required 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 behaviour, such as proper arrow key and function key operation.
Use of the different data file types, alternate keys, and transaction logging are addressed in lecture and lab exercises.
Other administrative functions such as print spooler configuration and control, and user process control are also
covered.

IBM U2 SB+ Essentials

In this hands-on course, get an introduction to the functionality and concepts of the IBM SB+ application development
environment. Explore application design that you can use both in character based and Graphical User Interface (GUI)
development. Let your imagination soar as you unleash the power of SB+ and very quickly realize results. Gain
experience building an application from the ground up, starting with file and dictionary definitions

Building Applications Using IBM SB+GUI

In this hands-on course, get an introduction to the functionality and concepts of the SB+ application development
environment using IBM SB+ Graphical User Interface (GUI) technology. Explore application design applicable to both
character base and GUI development. Gain experience building an application from the ground up, starting with file and
dictionary definitions.

       Creating simple and complex data entry screens

       Designing and setting system parameters for the GUI environment

       Building screens using sequential key mechanisms and accumulators

       SB+ expressions

       Paragraph logic




                                                   www.utwo.co.za
IBM U2 SB+ Advanced Development

Learn advanced IBM SB+ development skills through a combination of lecture and laboratory exercises. Build upon an
existing application to acquire a detailed understanding of specific SB+ tools. Create complex process definitions that
update multiple files, update periodically, validate, and use a job schedule process. In addition, learn how to use the
powerful SB+ Report Writer to create complex reports, set up output formats for preprinted forms, generate multipass
reports, and route output to specific locations

       Other tools

       Process definitions

       Query report definitions

       Beginning Report Writer

       Basic Report Writer

       Report Writer

       Transactions and periodic updates

       Menu definitions

       SB+ security

       GUI development

       Logical and global files

       Printer management

       System control and parameters




                                                  www.utwo.co.za
IBM U2 Unidata Fundamentals

In this hands-on, introductory course, focus on how to use UniData. Learn both the process and the theory of querying
the database and creating specialized reports. Build a database file from scratch, including creating a data dictionary,
entering data, and then exchanging data with other database files. Learn the Environment Control Language (ECL) and
the Alternative Editor (AE). Explore advanced ECL topics, including running background processes at scheduled times
and basic administration commands. Also, learn about Process Control Language.

       Introduction to UniData

       Take command!

       LIST statement

       Vocabulary (VOC) file

       Dictionaries (DICT)

       Data models

       Virtual attributes

       UniQuery reporting

       Alternate key indexes

       Select lists

       Advanced ECL

       Process Control Language

       System review
IBM U2 Unidata Administration

Learn how to manage a IBM UniData relational database management system. Learn how to install and configure the
software, manage data files, define and maintain security, and tune system performance. Explore the relationship
between UniData and the Windows & Unix operating system.




                                                   www.utwo.co.za
IBM U2 RedBack Essentials

Focus on the basics of developing Web applications for UniVerse and UniData using IBM RedBack. Learn how to use
RedBack Objects (RBO) and the RBO Designer, as well as RedPages, RedBack Active Server Pages (ASP),
RedBeans, and RedBack Java Server Pages (JSP). Learn skills for RedBack administration and performance
monitoring and tuning.



IBM U2 Universe ODBC

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.



JAVA Application Development Using IBM UniObjects

In this hands-on course, get an introduction to writing Java applications using IBM UniObjects to access IBM UniData
and IBM UniVerse databases.

Explore how to use IBM UniObjects for Java in both client/server and Web applications. Take advantage of the power
and openness of Java and the flexibility of the multivalue database. Using IBM UniObjects you can open files, read and
write records, execute selects, and call subroutines. Put a Java Graphical User Interface (GUI) or Java Web front-end on
your existing business logic.




Workshops

Course material can be customized and workshops held for specific clients on request. Such workshops will need to
coincide with existing scheduled courses. Please provide sufficient notice (at least 3 weeks in advance) of such
requirements. Please see the training schedule for workshop dates. Notification of workshops will be sent prior to the
session and will provide the topic, date, time and venue detail. Attendees booked on workshops that do not attend will
be charged to cover facility costs.

Certification

All students will receive a certificate on completion of the course. A course review by the student and a student review
by the lecturer will be conducted and forwarded to the student manager.




                                                   www.utwo.co.za
                        TRA IN IN G VEN UES & TIM ES
09h00 - 16h00 daily

Training will be conducted at Conferencing On Katherine in Sandton, Gauteng. Training courses held in Durban or Cape
Town will be based on demand and venues will be announced on booking confirmation.

Please confirm the training venue & times one week prior to your employees attending their course!




                                 ACCOMMODATION
Please contact us to obtain a list of accommodation in the area.




                                  CO URS E CAPAC ITY
Courses & Workshops                      Minimum students – 4 / Maximum students – 8

KINDLY NOTE: Should there be an insufficient number of students to complete a reasonable sized class, Workgroup/U2
reserves the right to either postpone or cancel a specific training session.




                                                   www.utwo.co.za
                                             PRICING

UniVerse Fundamentals                                R6,000                 (4 days)

UniVerse Basic Programming                           R6,000                 (4 days)

UniVerse Administration                              R6,000                 (4 Days)

IBM U2 SB+ Essentials                                R6,000                 (4 Days)

Building Applications Using IBM SB+ GUI              R6,000                 (4 Days)

IBM U2 SB+ Advanced Development                      R6,000                 (4 Days)

Unidata Fundamentals                                 R6,000                 (4 days)

Unidata Administration                               R6,000                 (4 days)

IBM U2 RedBack Essentials                            R6,000                 (4 days)

IBM U2 Universe ODBC                                 R3,000                 (2 days)

JAVA Application Development Using                   R6,000                 (4 days)
IBM UniObjects


   Prices quoted are per student, per course and EXCLUDE VAT.

   International courses will be held on demand at U$2000.00 per day for a maximum of 8 students. The cost of the
    trainer’s accommodation and airfare is for the client’s account and must be paid upfront. Please speak to Kurt
    Neumann should you require such a course.




                                               www.utwo.co.za
                              TERMS & CONDITIONS
Note that course reservation works on a ‘first-come first-served’ basis in accordance with the following procedures:

A. The booking form is to be completed and returned via e-mail or fax (please insert an order number, reference number
   or the name and signature of a duly authorised representative.).

B. On receipt of the order, a proforma invoice will be generated and faxed to you.

C. PAYMENT:

         I. Payment shall be made prior to the student attending the first lecture, if payment is not received, the
            student will not be allowed to attend.

        II. Failure to attend the lectures will not entitle the student, company or close corporation to a deduction,
            diminution or subtraction of the enrolment fee. The student, company or close corporation will be
            held liable for the total fee as stipulated in the pro forma invoice.

       III. Cancellations must be in writing. A 50% charge will be levied for any booking cancelled up to 2 weeks
            before course date. A 100% cancellation fee will be levied if the course is cancelled within 3 working
            days prior to the commencement of the course.

D. In the event of a student, company or close corporation paying a deposit, and such student fails to attend the course;
    the deposit will be forfeited and retained by Explix Technologies (t/a Workgroup) for damages, which it has suffered.
    The retention of the deposit by Explix Technologies (t/a Workgroup) will in no way prevent it from exercising all or any
    rights which it may have in law to claim the full amount from the student, company or close corporation.




                                                   www.utwo.co.za
PAYMENT DETAILS




    www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
www.utwo.co.za
                                   CON TAC T D ETA ILS




Uvanka Pote (administration of training schedule & information)




                                                  www.utwo.co.za
www.utwo.co.za
The Summit, 269




,




,




                  www.utwo.co.za
www.utwo.co.za
,H




,




     www.utwo.co.za
654

6008/6175/8/9




                www.utwo.co.za
654

6378




       www.utwo.co.za
training@utwo.co.za




                      www.utwo.co.za
                       TRA IN IN G BOO KIN G FO RM
Please note that the booking form must be completed in full and signed.
All forms should be faxed or emailed to U2 Training: training@utwo.co.za or on +27 11 654 6378


DELEGATE DETAILS
Delegate Names___________________________________________________________________________________
_________________________________________________________________________________________________
_________________________________________________________________________________________________
Special Dietary Requirements ______________________________Quantity____________________________________
Contact Name for Billing Purposes ____________________________________________________________________
Company Name____________________________________________________________________________________
Company Address__________________________________________________________________________________
_________________________________________________________________________________________________
_________________________________________________________________________________________________
Telephone Number__(______)_____________________________Fax Number__(______)________________________
Email Address_____________________________________________________________________________________
Order Number _____________________________________________________________________________________


COURSE DETAILS
Course Title_______________________________________________________________________________________
Date of course_____________________________________________________________________________________
Fee_________________________________________ Total due (excl. VAT):___________________________________




Signature______________________________________________Date_______________________________________
PAYMENT CONDITIONS: Please see our TERMS AND CONDITIONS OF PAYMENT in the brochure.




                                                  www.utwo.co.za