<<< Go back to Public Class Schedule Page

Full Price Tuition Includes Post Lab Environment

Course Description


Reporting Concepts for Relational Databases

Course 402  |  CEUs:  1.2  |  2 days
US $1700  Canada $1700

This class is not currently scheduled. If you are interested in this subject drop us a line!

    Release 7.x

    How can you optimize reporting from your Relational Database Management Systems (RDBMS), while maintaining the accuracy and integrity of the reports? This course enables you to analyze your reporting results from the RDBMS, determine where any potential performance gains can be found, and make any necessary adjustments to speed the process from raw data to finished report.

    You will learn how to:

    • Describe the process of adapter optimization
    • Recognize potential report inefficiencies
    • Analyze database metadata and know what attributes affect reporting efficiency
    • Explore syntax that relates to the RDBMS
    • Determine where optimization commands can be best utilized
    • Enable RDBMS optimization for all reports
    • Write efficient code with hands-on techniques that work with your RDBMS
    • Save time in your report request processing
    • Improve reporting system performance from your RDBMS

    Who should take this class:

    Application developers and report developers who use WebFOCUS, iWay Data Adapter Server, or FOCUS to report from relational databases.

    

    Also available as eGuide

     

    Prerequisites:

    Additional Knowledge:  Building Reports with Report Painter (Part 1) and/or Basic Reporting, an understanding of SQL syntax, and at least one month of extensive experience creating reports.

    Next recommended courses: