SQL for Argos

Designed for the learner who has been through the DataBlock Designer class, but does not know Oracle SQL. In this 3-day class the learner, through a combination of class exercises and independent workshops, will learn the basics of Oracle SQL, including joins and subqueries. Instruction also covers how to create multi-form Dashboards, interactive charts and OLAP cubes.
Topics
  • Database concepts
  • SELECT, FROM, WHERE, ORDER BY
  • Alias and Data Dictionary
  • Joins: inner, outer right, outer left
  • Call an Oracle function in the SELECT and WHERE clause: upper, to_date, to_char,
    string, sysdate, between
  • Call a Banner function in the SELECT and WHERE clause
  • Use the Object Source DataBlock to find a function and use it correctly
  • Identify when to use a case statement
  • Case and decode
  • Use a column number in the ORDER BY clause
  • Group operations
  • Unions
  • Having
  • Datasets in Banded and Extract reports
  • Multiple data sources
  • Dashboard navigation techniques
  • Charting
  • OLAP
  • Subqueries
  • Subqueries with in, not in, exist, not exist
  • WITH clause
Course details

Length:
3 days

Database requirements:
Oracle Banner

Argos knowledge requirements:
Completed DataBlock Designer training, or have similar familiarity with the tool.

SQL knowledge:
Little or none – Novice.

Maximum class size:
10

Recommended audience:
Employees who are new to the DataBlock Designer role and who do not have much experience in writing SQL queries.

If you’d like to schedule the training above, OR if you’re interested in a training not listed, let us know.
Our Professional Services team will work with you to customize a course to fit your needs.

Get Started