SQL for Argos 1

SQL for Argos 1

Actions and Detail Panel

$750

Date and time

Location

Online event

Refund policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Designed for participants who have attended the DataBlock Designer class, but does not know Oracle SQL.

About this event

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

Share with friends