Per-Seat Remote Training
Per-seat remote training is an affordable, convenient option for getting one or two staff members the hands-on knowledge and skills they need. Whether you’re working with a tight budget and/or recent personnel changes require staff members to take on new tasks and responsibilities, per seat remote training may be just what you need.
Argos Kickstarter (Basic)
Course Description
Audience Requirements:
Intermediate knowledge of Banner, and an understanding of query logic or basic SQL.
Attendees will also need:
- Strong internet connection
- Dual monitors
- Headset (for better audio and interaction)
- Once registered, print out all materials sent by trainer
Does NOT Cover:
This class will not teach analytical reporting (OLAP cubes and charts.)
Days 1 – 2
4 hrs each day, 12:00-4:00pm ET
In this hands-on training, we will show the basics of building a DataBlock dashboard and report query.
Topics covered:
- DataBlock creation
- Dashboard variables
- Writing SQL using the Visual Designer
- Using and updating the Data Dictionary
- Object level security
- Scheduling reports
- Library of Objects
Day 3
4 hours, 12:00-4:00pm ET
In this hands-on training, we will show the attendees how to build and modify CSV, Extract, Crosstab, and
Banded reports.
Topics Covered:
- Creating each report type (CSV, Extract, Banded)
- Expressions
- Sorting & filtering
- Library of Objects
- Scheduling Reports
Upcoming Dates | Click to register
Argos Advanced - DataBlock Designer
Course Description
Audience Requirements:
Intermediate knowledge of Banner, and an understanding of query logic or basic SQL.
Attendees will also need:
- Strong internet connection
- Dual monitors
- Headset (for better audio and interaction)
- Once registered, print out all materials sent by trainer
Does NOT Cover:
This class will not teach creation of Extract, Banded, or Cross-tab reports.
Advanced DataBlock Designer Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET
Topics covered:
- DataBlock creation
- Dashboard variables
- Report query
- OLAP cube
- Dashboards with multiple forms
- Drill through charts
- Using the Visual Designer with subqueries, functions, and unions
- Security
- Object level security
- Report query field level security
- Scheduling reports
- Library of Objects & templates
- Using and updating the Data Dictionary
- Support Resources
Argos Advanced - Report Writer
In this 3-day hands-on training, we will dive more in depth and show the advanced features of building and modifying CSV, Extract, Crosstab, and Banded reports.
Course Description
Audience Requirements:
Intermediate users who use pre-built DataBlocks to build a variety of reports. These users should be comfortable learning new software tools and basic report creation.
Attendees will also need:
- Strong internet connection
- Dual monitors
- Headset (for better audio and interaction)
- Once registered, print out all materials sent by trainer
Does NOT Cover:
Creation of DataBlocks.
Advanced Report Writer Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET
Topics covered:
- Creating each report type (CSV, Extract, Banded, Crosstab)
- Expressions
- Sorting & filtering
- Grouping in Banded and Extract reports
- Library of Objects and templates
- Scheduling Reports
- Using Datasets in Banded reports
SQL for Argos 1
Course Description
Audience
Employees who are new to the DataBlock Designer role and who do not have much experience in writing SQL queries.
Audience Requirements:
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
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET
Topics covered:
- Database concepts
- SELECT, FROM, WHERE, ORDER BY
- Alias and Data Dictionary
- Joins: inner, outer right, outer left
- Call an 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
No Events
SQL for Argos 2
Course Description
Audience
Employees who are new to the DataBlock Designer role and who do not have much experience in writing SQL queries.
Audience Requirements:
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
SQL for Argos (Part 2) Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET
Topics covered:
- 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
MAPS Admin
Course Description
Audience
Employees who are new to the MAPS Administrator role or need a refresher.
Attendees will also need:
- Strong internet connection
- Dual monitors
- Headset (for better audio and interaction)
- Once registered, print out all materials sent by trainer
MAPS Admin Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET
Topics covered:
- Data source connections
- Connections to MAPS and Argos internal databases
- LDAP connection setup for users/groups from Active Directory
- API configurations
- Email server connection
- FTP server connection
- Installation of Argos Data Dictionary
- Installation and setup of Windows printers
- Setup of Users/Groups
- SSL setup
- API security
- Database (ADO) security
- Log files and audit setup
- Backups
- Universal Launcher
SQL Advanced Techniques
Course Description
Audience
Employees with a good grounding in how to create basic SQL and are looking to expand their knowledge to optimize SQL and leverage Oracle functionality to create custom functions and tables. This class does not cover basics of SELECT, FROM, WHERE.
Audience Requirements
Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).
Strong novice, with a good understanding of basic SELECT FROM WHERE statement and joins.
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 Advanced Techniques Training
SQL Advanced Techniques Training is conducted remotely over six days across two weeks.
The general agenda for each day is as follows:
6 days over 2 weeks
5 hrs. each day, 11:00am-4:00pm ET
Topics covered:
WEEK 1
Day 1
- Database concepts
- Alias and Data Dictionary
- Object Security in Argos
- Introduction to Oracle Functions
- Call Oracle Functions in Select/Where
Day 2
- Joins
- Unions, including Them Unions
- Aggregate Functions and Group By
Day 3
- Introduction to Banner Functions
- Call Banner Functions in Select/Where
- If-Then-Else Logic (Includes CASE)
- Advanced Order By Options
WEEK 2
Day 4
- Introduction to Subqueries (Scalar, Noncorrelated, Correlated)
- Advanced Subqueries (Inline Views and With)
Day 5
- SQL for Charting
- OLAP Cubes
- Using Datasets in Reports and Extract Reports
Day 6
- SQL Variables
- PL/SQL
- Insert, Update, Delete
No Events
Questions?
If you can’t find the information you need on the linked pages above, or if you have additional questions, please contact Jaclyn Tocco, Evisions Account Representative.