CamSIS Query Manager Prerequisites
Thu 26 Nov, Tue 1 Dec, ... Fri 11 Dec 2015
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 | Thu 26 Nov 2015 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | John Hocking |
2 | Tue 1 Dec 2015 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | John Hocking |
3 | Wed 9 Dec 2015 14:00 - 17:00 | 14:00 - 17:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | John Hocking |
4 | Fri 11 Dec 2015 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