SQL for Argos
(Part 1)

In this 3-day, 4-hours per day class, attendees will learn the basics of Oracle SQL in Argos, including joins and subqueries. (Part 1 of a 2-part class.)

Upcoming Classes • Click to register

No Events

Course Description

SQL for Argos (Part 1) Training

Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics Covered:

  • 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 statements
  • Use a column number in the ORDER BY clause
  • Group operations

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

Audience Requirements:
Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).

Little to no SQL experience required.

Attendees will also need:

  • Strong internet connection
  • Dual monitors
  • Headset (for better audio and interaction)
  • Once registered, print out all materials sent by trainer