Designed to expand beyond the learner’s basic knowledge of SQL to leverage the functionality of their Oracle database and develop custom Arg
About this Event

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