 SQR
Training Course Overview
Using a comprehensive, hands-on approach, our instructor provides a solid understanding
of Structured Report Writer, SQR. This SQR training course covers both the fundamentals of
SQR and many of the language's advanced features. The fundamentals include understanding
the syntactical structure of the language, defining the characteristics of your report
file and a very powerful feature called break processing. Advanced features covered
include varying queries at run time, array processing, working with flat files, creating
multiple reports from one SQR script and other programming strategies. Experience
programming in a 3GL or 4GL languages and SQL are a must.
You Will Learn How To
 | Run SQR programs and modify the command environment |
| Master the SQR language syntax and structure |
| Define and manipulate SQR variables |
| Use Break technology |
| Dynamically define Query statements |
| Use nested SQL statements |
| Create data extracts & interface files |
| Array Processing |
| Multiple Reports |
| Debug and tune your reports |
Audience
To gain the most out of this class you need a working knowledge of SQL and experience
writing 3GL or 4GL software programs. It is also helpful to be familiar your operating
system and a programmer's editor.
Looking for Something More or Something Less?
We recognize that there may be features of the language that one customer may rely on
heavily while another customer will never use. Perhaps you prefer a 3-day course instead
of a 4-day course. Allow us to customize the curriculum to fit your specific needs.
|
