Course Details:

Course Outline:

This course is intended for end users and support staff who need to create, modify and run query reports. The course covers the basics of creating new query definitions and modifying existing queries. It takes users step by step through the options to create and run a query in easy to understand terms. The course is very much hands on and delegates have plenty of opportunity to get to grips with the fundamentals of writing queries

Pre-requisites:

There are no prerequisites for this course but delegates should have basic keyboard skills.

Course content:

• Introduction to query
• Explain Query and database file terminology
• How Queries process in batch and interactive environments
• Use of function keys within Query
• Starting Query
• Exit, Save and Run a Query definition
• Examples of storing Queries in libraries
• How to select the file and library that you wish to report on
• How to select and sequence the fields required in the report
• How to select which records you require in the report
• Detail the different record tests
• Examples of the different record tests
• Using the And and Or options when selecting records
• How to sort the list of records into a logical sequence
• How to define report breaks
• Defining sub totals and final totals
• How to hide sub totals or final totals
• Output a Query to print
• Format the printed output
• Selecting detail and summary output
• Selecting report column formatting
• Formatting numeric and date fields
• How to reduce column heading lengths
• How to change existing Queries
• Query design checklist
• Manipulate printed output using the WRKSPLF command

Follow on Courses:

We recommend that after a suitable period of time of attending this course (e.g. 3 to 6 months hands on experience) then delegates may want to enhance the knowledge they have gained by attending the Advanced Query course (ISQRA).

Schedule:       

Book course:

ISQRY Basic Query booking form

If you are human, leave this field blank.

Company name: *

Your name: *

Your e-mail address: *

Please double check this!

Phone number:

Address:

Commencement date: * Please call or email for details

Purchase order number:

Is this a confirmed or provisional booking: * Please select Confirmed Provisional

Number of delegates: *

Delegate names: *

Please tick the box below to confirm that you agree to the Privacy Policy of Sierra Training.

Terms *

I agree to the privacy policy

Please tick the box below to confirm that you agree to the Terms & Conditions of Sierra Training.

Checkboxes *

I agree to terms and conditions