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
• Charting
• OLAP
• Subqueries
• Subqueries with in, not in, exist, not exist
• WITH clause
Event Venue
Online
USD 750.00