October 7
@
8:00 am
–
October 11
@
4:00 pm
PDT
PeopleTools Batch Processing and Reporting
- App Engine Overview and Structure
- SQL and Control-of-flow
- State Records
- Temp Tables
- SQR Syntax and Symantics
- Understanding SQR Page Layout
- Program Structure
- Graphics and Fonts
App Engine Topics
- App Engine Sections, Steps, and Actions
- Action execution sequence
- SQL actions
- Database commands (PL/SQL, etc.)
- Libraries
- State records (AET)
- State record initialization
- Parallel processing
- Temporary tables (TAO)
- Testing and debugging
- Trace files
- Performance tuning
- PeopleCode
- Set processing
- Process definitions
- Run control records
- Run control pages
- Security
SQR Topics
- SQR Basics
- Text Editors
- Print Coordinates
- Headers and Footers
- SQL SELECT Statements
- Column Variables
- Conditional Statements
- Flow-control Statements
- Variables
- Substitution Variables
- Built-in Functions
- Print Commands
- Formatting
- Functions
- Edit Masks
- SQC Files
- Local and Global Procedures
- Run Control Pages and Records
- User Input and Parameters
- Debugging and Tracing
- Lookup Tables and Arrays
- Interfaces and Integration
- Graphics
Who Should Attend
- Developers should attend the entire class
On-Demand
Prefer to learn at your own pace? Get this same training on demand!
