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 you to quickly get into the product and to modernize your 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. You will learn how to utilize DB2 Web Query Developer Workbench functions for joining, validating, and writing end users function that is consistent across all of the DB2 Web Query Environment. You will also learn how to consolidate data from multiple partitions or systems. You 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, you 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.