Audience :

  • Technical Consultant
  • System Analyst
  • Application Developer
  • Reports Developer
  • Business Analyst

Topics :

  • SQR Basics
  • Important SQL Concepts
  • Fundamentals of SQR Reporting
  • Flow Control Commands
  • Variables
  • Built-In Functions
  • Print Commands - Beyond the Basics
  • SQC Files - Libraries
  • Writing Procedures - Both Global and Local
  • The Five Sections of an SQR Program
  • Techniques for Launching SQRs
  • Creating Online Interfaces for SQRs
  • Run Control Records, Pages, and Process Definitions
  • Process Security
  • User Input and Report Parameters
  • Dynamic SQL
  • Debugging Strategies
  • Lookup Tables and Arrays
  • Writing Interface Programs
  • Error Handling
  • Generating Multiple Reports
  • Graphics and Creating Forms