Per-Seat Remote Training

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.)

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

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

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.

Argos 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

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.

Argos 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

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

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

Prerequisites
Intermediate knowledge of Banner or Colleague, and an understanding of query logic or basic SQL.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Print out all materials sent by trainer (post-registration)

FormFusion Training
Days 1-2
4 hrs each day, 12:00-4:00pm ET

FormFusion Training – Introduction

Day 1 (4 hrs., 12:00-4:00pm ET)

• FormFusion Application Introduction
• User Interface & Navigation
• Processes and Print Parameters
• MapForm Template Component
• MapForm Properties and Field Mapping (Floating & Offset Fields)
• Basic Exercise (PO Template)
• FormStamp Template Component
• FormDirector Template Component
• Directors: Print, Email, Imaging, Script, DocuSign

FormFusion Training – Advanced Topics

Day 2 (4 hrs., 12:00-4:00pm ET)

• Continuation of any topics overflowed from Day 1
• CaptureForm Template Component
• CaptureForm Variables and Queries
• Template Copy (FormStamp & FormDirector)
• Additional Form Options
• Conditional Logic of Object, Form and Output
• Basic Template Design Exercise (Transcript or Student Bill Template)
• Test Print Template Option
• Additional Material (if there is remaining training time)
• Template Security Configuration
• FormFusion Troubleshooting Process Deep Dive
• Comprehensive FormFusion Support Options Overview

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

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