CamSIS Query Manager Prerequisites
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.
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
Events available