EncartaLabs

DB2 Web Query

( Duration: 3 Days )

The DB2 Web Query training course covers the advanced topics that developers and administrators need to know. We start by converting existing Query/400 queries into DB2 Web Query. This will allow attendees to quickly get into the product and to modernize their existing reports. Advanced options of the DB2 Web Query product will be covered. These include Run Time User Enablement, Spreadsheet Client, and Microsoft SQL Server integration.

Developers will learn how to use the Developer's Workbench to develop Executive Dashboards KPI reports through hands on labs. They will learn how to utilize DB2 Web Query Developer Workbench functions for joining, validating, and giving their end users function that is consistent across all of the DB2 Web Query Environment. They will also learn how to consolidate data from multiple partitions or systems. They also learn how to consolidate data from multiple i partitions or systems, including Microsoft SQL Server.

Administrators will learn to effectively manage and secureThe DB2 Web Query Environment.

By attending DB2 Web Query Workshop, attendees will learn:

  • Dashboards
  • Scorecards
  • Key Performance Indicators (KPI)
  • Convert existing Query/400 reports into Web Query
  • Basic performance tuning techniques
  • Automatically distribute reports
  • Link to Microsoft SQL Server

  • Experience with DB2 Web Query Graph Assistant and Report Assistant

The DB2 Web Query class is meant for End Users, Developers, and Administrators who need to analyze the data in their environment and want to turn it into a business asset.

COURSE AGENDA

1

Installation and maintenance

2

User security and licensing

3

Metadata and applications

4

Query/400 conversions

5

HTML Composer

6

Report Broker

7

Software Development Kit

8

Spreadsheet client

9

Microsoft SQL Server integration

10

Performance analysis

11

Advanced reporting techniques

12

Summary

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top