SQL for Argos 1

In this 3-day class the participant, will learn the basics of Oracle SQL in Argos, including joins and subqueries through a combination of class exercises and independent workshops. (This is part 1 of a 2-part class.)

Audience

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

Prerequisites

• 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

SQL for Argos Part 1 Training Agenda

Days 1-3 (4 hrs. each day, 12:00-4:00pm ET)

• Database concepts

• SELECT, FROM, WHERE, ORDER BY

• Alias and Data Dictionary

• Joins: inner, outer right, outer left

• Call 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