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.

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

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

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

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 (Part 1) Training
Days 1 – 3
5 hrs each day, 11:00am-4:00pm ET

Topics covered:

• Database concepts
• Alias and Data Dictionary
• Field security in Visual Designer
• Call Oracle functions in the select and where clause: upper, to_date, to_char, between, sysdate
• 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
• Use a case order in a drop-down box

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

Completed SQL Advanced Techniques (Part 1) training.

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 (Part 2) Training
Days 1 – 3
5 hrs each day, 11:00am-4:00pm ET

Topics covered:

• Use a column number in the order by clause
• Distinct – when to use.
• Max, min, average, count, sum
• Group by: Describe and use
• Create SQL for chart
• Describe and use the pivot function
• Unions: Describe the 4 types of unions: union, union all, intersect and minus
• Describe when to use them Unions
• Create and use a union operator
• Having Datasets in Banded and Extract reports

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

Completed SQL Advanced Techniques (Part 1 & Part 2) training.

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 (Part 3) Training
Days 1 – 3
5 hrs each day, 11:00am-4:00pm ET

Topics covered:

• Joins: inner, outer right, outer left
• Create joins in the visual designer
• Add joins to data dictionary
• Create joins with free type
• Subqueries: Scalar, Noncorrelated, Correlated, In line view
• Subqueries with in, not in, exist, not exist
• With clause
• Insert, Update and Delete using SQL Variables and Banner Letter Generation

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

Completed SQL Advanced Techniques (Parts 1, 2, & 3) training.

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 (Part 4) Training
Days 1 – 3
5 hrs each day, 11:00am-4:00pm ET

Topics covered:

• SQL Tuning
• SQL Best Practices
• Change table order in Argos
• Explain Plan
• What is PL/SQL
• Creating functions on the database
• Calling PL/SQL functions within Argos
• Create tables and views
• Create cursors in anonymous blocks in Argos