Take your skills to the next level by learning how formulas can give you access to more information in Ajera and PORTFOLIO inquiries.

This intermediate-level session is intended for users with no knowledge of SQL. You will receive a brief introduction to some SQL functions and learn about the different kinds of Inquiry formulas.

Step-by-step exercises will show you how to use CASE and DATENAME functions to:

• Filter amount columns.
• Parse through a data field.

Note: This session does not describe the Ajera database structure or how to program in SQL. If you are interested in those topics, please contact an Ajera/PORTFOLIO consultant.

Duration: 1.5 hours
Registration Fee: $225
*A credit card is required for payment.