DB2 Web Query for Advanced Users, Administrators, and Programmers

Digi Academy
A Milano

Chiedi il prezzo
Vuoi parlare del corso con un consulente?
Confronta questo corso con altri simili
Leggi tutto

Informazione importanti

  • Corso
  • Milano
Descrizione

Obiettivi  

Informazione importanti
Sedi

Dove e quando

Inizio Luogo
Consultare
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Domande più frequenti

· Requisiti

Prerequisiti

You should have:

  • Getting Started with DB2 Web Query class (OD040) or
  • experience with DB2 Web Query Graph Assistant and Report Assistant.

Cosa impari in questo corso?

Target del corso

This is a intermediate course for End Users, Developers, and Administrators who need to analyze the data in their environment and want to turn it into a business asset.

Programma

Contenuti del corso

Are you already comfortable with the basics of DB2 Web Query and want to take your skills to the next step? Then this is the course for you!

This 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´ll learn how to utilize DB2 Web Query Developer Workbench functions for joining, validating, and giving your end users function that´s consistent across all of the DB2 Web Query Environment. You´ll also learn how to consolidate data from multiple i partitions or systems. Developers will learn how to use the Developer´s Workbench to develop Executive Dashboards KPI reports through hands on labs. You´ll learn how to utilize DB2 Web Query Developer Workbench functions for joining, validating, and giving your end users function that´s consistent across all of the DB2 Web Query Environment. You´ll also learn how to consolidate data from multiple i partitions or systems, including Microsoft SQL Server.

Administrators will learn to effectively manage and secure the DB2 Web Query Environment. Companion products will also be covered. These include DB2 Web Query Report Broker for automated report distribution and the Software Development Kit for integrating DB2 Web Query into your existing web and PC applications.

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

Training Paths that reference this course are:

  • System Operator
  • Application Developer(DB2, WDSc, RPG, COBOL, CL, SQL)
  • End User

Contenuti dettagliati del corso

  • Installation and maintenance
  • User security and licensing
  • Metadata and applications
  • Query/400 conversions
  • HTML Composer
  • Report Broker
  • Software Development Kit
  • Spreadsheet client
  • Microsoft SQL Server integration
  • Performance analysis
  • Advanced reporting techniques
  • Summary


Confronta questo corso con altri simili
Leggi tutto