Training

Showcase 9: Query Basics

IBM i

Who Should Attend

This class is intended for anyone with limited or no prior experience in building queries with Showcase 9. The class content minimizes "behind the scenes" technology and presents information from an end user perspective through presentations and hands-on learning experiences.

What to Expect

The class begins with basic query building and progresses through a wide range of topic areas. Learning experiences include:

  • Results filtering
  • File joining
  • Runtime prompts
  • Results formatting
  • Output options
  • Expressions for new column creation (SQL functions)
  • Expressions for filtering (conditions)

This class follows a blended approach to learning that includes:

  • Presentation and live demonstrations
  • Hands-on activities on your own system
  • Participant interaction with the trainer, during sessions
  • Student Training Environment Requirements
  • A high-speed Internet connection
  • Showcase 9 installed on your IBM i
  • IBM i profile and password
  • Showcase IBM i Driver Data Source
  • Showcase 9 Client installed on your PC
  • Read authority to training data tables (SCDBTRAIN library)
Available On Demand
This training is available on-demand.
,


Starts:
Ends:
Event dates and times are calculated from your device's UTC (Coordinated Universal Time) offset.
Available On Demand
$2,100 (up to 4 students). $120 for each additional student.
6 hours (2 x 3-hour sessions)