Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > SQL and QMF for End Users Training

SQL and QMF for End Users Training

Course#: WA1335

This course is designed to provide end users with concepts and techniques for accessing DB2 Data. SQL is used to formulate queries to obtain data. QMF is used to modify the appearance of this data through QMF FORMS. Various techniques for using QMF are highlighted through class notes and practice in exercise activities.

Objectives:
  After completing this course the student should be able to:
  • Have an understanding of relational database concepts
  • Be able to use basic components of SQL
  • Be able to code SQL to select data from one or more tables
  • Know basic components and commands of QMF
  • Be able to use QMF forms for report customization
Duration:
  Three days.

Outline of WA1335 SQL and QMF for End Users Training

Day 1

  • Basic Theory
  • Introduction to SQL
  • QMF Basics
  • SQL Lab 1
  • QMF FORMS
  • QMF Lab 1 (2 workshops)
  • Basic SQL
  • SQL Lab 2

Day 2

  • Basic SQL (continued)
  • SQL Lab 3
  • Joining Tables with SQL
  • SQL LAB 4
  • SQL Subselects
  • SQL LAB 5

Day 3

  • Additional QMF techniques
  • QMF LAB (workshop #3)
  • Some Advanced SQL
  • SQL LAB 6
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.