CamSIS Query Manager Prerequisites
Mon 20 Mar, Fri 31 Mar, ... Fri 7 Apr 2017
Description
CamSIS Query Manager is a tool designed for administrative users to write their own queries in CamSIS.
Target audience
By invitation only. Not for students.
- Further details regarding Student Systems' eligibility criteria are available
Prerequisites
- Participants should have knowledge of the CamSIS interface, and an understanding of the data.
Sessions
Number of sessions: 4
| # | Date | Time | Venue | Trainer | |
|---|---|---|---|---|---|
| 1 | Mon 20 Mar 2017 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | John Hocking |
| 2 | Fri 31 Mar 2017 10:00 - 13:00 | 10:00 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | John Hocking |
| 3 | Mon 3 Apr 2017 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | John Hocking |
| 4 | Fri 7 Apr 2017 10:00 - 13:00 | 10:00 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 2 | map | John Hocking |
Topics covered
- Tab Tour
- Creating a query
- Replacing a record
- Select fields to display, fields display order and sort order
- Changing heading text, and translating field codes
- Adding criteria to filter the data
- Prompts
- Expressions
- Aggregate Functions
- Joins 1 – Record Hierarchy
- Joins 2 – Related Record
- Joins 3 – Any Record
- Outer Join – steps
- Outer Join - Belongs To
- Subqueries - Checking for Existence
- Subqueries - Single Value
- Unions
Objectives
Delegates will learn how to use CamSIS Query Manager to write their own custom queries.
Aims
To be able to: Write new queries Edit existing queries
Format
Presentations, demonstrations and practicals
Duration
Four half-day sessions
Frequency
On demand
Related courses
Booking / availability