fbpx

+1 (509) 888-PROS

Find A Course

Log in

Please log in to continue.

Forgot your password? Click here to reset.

Not a member? Register Now. Registration is Free!

Register

Fantastic! Before you enroll, do you have an account with us? If so, please log in to continue. Otherwise, we have a simple three-step process:

① REGISTER
② Confirm your e-mail Address
③ Purchase this course

① REGISTER

Already a member? Log in.

A username may contain letters, numbers, spaces, underscores, hyphens, periods, and the @ symbol

Privacy Policy | Terms of Use

By clicking register, I agree to receive communications from JSMpros. I understand that I can opt-out of communications at any time and that opting out may result in missed notices regarding my account.

① LOG IN

Login

Forgot Password?
Register

② Confirm your e-mail Address

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

③ Purchase this course

Check your e-mail (and spam/junk) for an e-mail from us asking you to confirm your e-mail address. After confirmation, return to this dialog to complete step 3: Enroll in this course.

Begin Purchase

« All Events

App Engine/SQR Accelerated

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
Enroll

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!

Enroll

Tickets

The numbers below include tickets for this event already in your cart. Clicking “Get Tickets” will allow you to edit any existing attendee information as well as change ticket quantities.
All Five Days!
Includes activity guides and access to training servers
$8,827.50
Quantity: 0
Total: $0.00

Related Events