Evisions
aMenu

Course · 3 days

SQL for Argos

For the person who has been through DataBlock Designer training and can use the tool, but hits a wall the moment a request needs a join. Three days of Oracle SQL taught through class exercises and independent workshops, ending with multi-form dashboards, interactive charts, and OLAP cubes.

At a glance

Length

3 days

Maximum class size

10

SQL knowledge required

Little or none. Novice.

Argos prerequisite

Completed DataBlock Designer training, or similar familiarity with the tool

Database

Oracle Banner

Recommended for

Employees new to the DataBlock Designer role who do not have much experience writing SQL

Overview

The course that turns a tool user into a report builder

Most people arrive at Argos able to run what already exists and change it a bit. The gap between that and building something new is SQL. No manual closes it.

So this course teaches it against the database you actually report on. The joins are Banner joins. The functions are the ones already sitting in your Object Source DataBlock. Three days of class exercises, then workshop time on your own, which is the part where it stops being theory.

Curriculum

What the course covers

01

Foundations

  • Database concepts
  • SELECT, FROM, WHERE, ORDER BY
  • Alias and Data Dictionary
  • Using a column number in the ORDER BY clause

02

Joining and filtering

  • Joins: inner, outer right, outer left
  • Group operations
  • Unions
  • HAVING

03

Functions and logic

  • Calling an Oracle function in the SELECT and WHERE clause: upper, to_date, to_char, string, sysdate, between
  • Calling a Banner function in the SELECT and WHERE clause
  • Using the Object Source DataBlock to find a function and use it correctly
  • Identifying when to use a case statement
  • Case and decode

04

Subqueries

  • Subqueries
  • Subqueries with in, not in, exist, not exist
  • The WITH clause

05

Building the output

  • Datasets in banded and extract reports
  • Multiple data sources
  • Dashboard navigation techniques
  • Charting
  • OLAP

Audience

Who this is for

01

New DataBlock designers

You have been given the role and the tool, and now you need the language underneath it.

02

Report writers moving up

You have built plenty of reports on other people's DataBlocks. Now you want your own.

03

Anyone inheriting objects

Somebody left and you now own their DataBlocks. This is the course that lets you change them safely.

Related

Where to go next

SQL Advanced Techniques

The follow-on course, for once you write basic SQL comfortably.

Argos 3-Day Basic Training Package

If your team needs the tool first and the SQL later.

All training options

Group, individual, and free on-demand.

Next step

Tell us who would be in the room

Numbers, roles, and what they need to be able to do afterwards. That tells us whether this course, another one, or a custom session is the right fit.

Ellucian Partner Award

2025: Customer First

Ethos Connected

since 2020

Ellucian partner

22 years