SQL for Argos 2

Designed for the learner who has been through the DataBlock Designer class but does not know Oracle SQL. In this 3-day class the learner, through a combination of class exercises and independent workshops, will learn more about Oracle SQL in Argos, including subqueries, as well as how to create multi-form Dashboards, interactive charts and OLAP cubes. (This is part 2 of a 2-part class.)

AudienceEmployees 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).
• Completed SQL for Argos (Part 1) training.
• 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

Agenda

SQL for Argos (Part 2) Training is conducted remotely over three days. The general agenda is as follows:

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

• Having

• Datasets in Banded and Extract reports

• Multiple data sources

• Dashboard navigation techniques

• Charting

• OLAP

• Subqueries

• Subqueries with in, not in, exist, not exist

• WITH clause