COMMON Virtual Labs
Virtual Lab Benefits:
- All-day educational lab workshops on leading edge topics
- Focused, interactive education presented by industry experts
- A cost-effective option for in-depth education, right from your PC
- Access to your own lab computer for exercises through just a browser window
- Hands-on lab exercises for each attendee with one-on-one interaction with the presenter
- Workshop handouts including Lab scripts and presentation slides
Virtual Lab Pricing:
- $299 for COMMON members
- $399 for non-members
Upcoming Virtual Labs
DB2 Web Query Virtual Lab
by Gene Cobb, IBM
November 3, 2011 • 9:00 am - 4:00 pm Central Time
This virtual lab is designed for the developer and database administrator who would like a modern query and reporting tool to deliver timely and quality reports, graphs, and dashboards to meet the reporting requirements of their company. This session introduces, DB2 Web Query for IBM i, the strategic query and reporting tool for the IBM i operating system. The instructor uses lecture, demonstrations, and labs to help attendees understand the capabilities of the new product and the steps and skills necessary to deliver this content back home in their production environment.
Learning Objectives:
- The attendee will learn how to create metadata and understand the advantages of this abstraction layer.
- The attendee will learn how to take existing Query/400 objects and "webify" them using the DB2 Web Query import tools.
- The attendee will learn how to create reports and graphs using the DB2 Web Query development tools.
- Along the way, the attendee will learn several best practices, tips and techniques, and pitfalls to avoid.
Workshop Syllabus/Agenda:
- DB2 Web Query overview and demo
- Metadata - what is it and how can it help your reporting environment
- Labs that will show you how to create reports and graphs using the development tools
- Modern report output formats such as HTML, Excel spreadsheets, PDF, and Active Reports
Audience: This workshop is designed for programmers and database administrators who understand the query and reporting needs of their company and need a modern tool to deliver those requirements. Attendees should have an understanding of the DB2 for i database and the general database design of their company. Knowledge of SQL is helpful but not required.
About the Speaker:
Gene Cobb is a DB2 for i technology specialist in the IBM Systems Software DB2 for i Development team. He joined IBM in 1988 and spent over 10 years as an application consultant in the IBM STG Lab Services group, formerly the Client Technology Center (CTC) in Rochester, Minnesota. His current responsibilities include the promotion, education, enablement, and technical support of IBM DB2 Web Query, the strategic query and reporting solution for the IBM i platform. He speaks and writes regularly about DB2 for i and DB2 Web Query topics, and was a co-author of the IBM Redbook "Getting Started with DB2 Web Query for System i". He can be reached at This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Virtual Labs


