Training

Introduction to Showcase Query

IBM i

Reigster today for Introduction to Showcase Query being held March 26-28 from 1 p.m. to 4 p.m. Eastern each day.

During this live, instructor-led three-part, introductory course, you will become familiar with Showcase Query. Learn how to create, modify and run basic Showcase queries (data retrieval/queries). Master the 5 basic SQL clauses used for data retrieval. Add run-time prompts to those views and work with dates (conversion and aging in days) too.

Topics covered include:

  • An overview of Showcase Query
  • Joining files
    •  Using inner, left-outer and exception joins
    • Creating join conditions
  • Formatting results
    • Using edit masks to format data
    • Creating break groups and subtotals
  • Creating calculated fields (columns)
    • Using case statements
    • Using the date function to convert numeric and character fields to usable dates for use in date calculations and selection criteria
    • Using date functions for aging and date calculations
    • Using set (aggregate) functions to create summary results
    • Creating formula calculations
  • Selecting records
    • Use of run time prompts and variables
    • Using SQL functions in conditions
    • Creating complex selection criteria using and, or and grouping
  • Sorting results
  • An overview of saving results

Prerequisites:

  • A high-speed Internet connection (DSL, cable modem, or T1)
  • A screen resolution of 1024 x 768 or higher
  • Showcase 9x installed on your IBM i
  • Showcase Query client 9.1 installed on your PC
  • Access to Query and the SCSAMPLE90 Showcase sample data library during class for hands-on exercises – the library can be restored if needed prior to class, please request instruction on restoring

This class follows a blended approach to learning that includes:

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

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.

Mar
26 - 28
1553619600 Tuesday
March 26, 2019

12:00pm
TO
1553803200 Thursday
March 28, 2019

3:00pm
$895 per person
Three 3-hour Sessions