SEQUEL: Basic Data Access

Learn how to create, modify, and run basic SEQUEL views using SEQUEL ViewPoint to access your System i data.

SEQUEL: Basic Data Access is a 2-part class. Find complete Day 1 and Day 2 dates and times in the Description section.

Type:: Online Training
Cost:: $396
Next Offering:

Description

This live, instructor-led, class focuses on using SEQUEL ViewPoint for access to your System i data. During this two-day introductory course, you'll learn how to create, modify, and run basic SEQUEL views (data retrieval/queries).

The two-day SEQUEL: Basic Data Access class is offered on the following dates:

Class Dates	Class Time
April 10 & 12	9 - 11 a.m.
July 10 & 12	2 - 4 p.m.
October 10 & 11	9 - 11 a.m.
December 11 & 13	2 - 4 p.m.

Topics include:

An overview of SEQUEL & basic SQL
Exploring the ViewPoint environment
Choosing your data source(s)
Selecting and formatting result fields
Creating calculated fields (columns)
Sorting results
Selecting records
Building file relationships
An overview of output options

Who should attend?

The class is designed for anyone who needs to access System i data using SEQUEL.

Training approach

SEQUEL Software uses a blended approach to learning that has proven very successful. The class includes:

Presentation and live demonstrations
Hands-on activities on your own system
Participant interaction with trainers during session

Length

Two, 2-hour sessions

Prerequisites

A high-speed Internet connection (DSL, cable modem, or T1).
A screen resolution of 1024 x 768 or higher.
Current version of SEQUEL installed on your System i.
Current version of SEQUEL ViewPoint installed on your PC (version 9 preferred)
An understanding of the System i concepts of libraries and files.
ViewPoint design authority.
Access to ViewPoint during class for hands-on exercises.
Authority to create SEQUEL objects during class for hands-on experience.
A user library where you can save SEQUEL objects.
Access to the SEQUEL objects in the SEQUELEX library from ViewPoint.
Comfortable in the Windows environment.

Registration

Each person who wants to take the class must register. Class size is limited to give participants the individual attention they need.

Registration is required at least 72 hours before the class. You can cancel your registration up to 72 hours before the class without penalty. No-shows will be billed.

Resources

If you need more in-depth training, you may want to consider: