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