Database Basics and the ADM
Become familiar with databases, related terminology and how the GIM Suite stores data.
Who should attend?
New GIM Suite users.
1. Explain the features of a Relational Database Management System (RDBMS).
- Discuss the concept of an RDBMS.
- Explain client/server relationship in the context of RDBMS.
- Identify the main database software companies.
2. Describe the fundamental components of the CorpAssay ADM.
- Recognise the relationship between tables, records and fields.
- Define primary keys, foreign keys, required, fixed and virtual fields.
- Explain indexes.
- Explain the different relationships within the CorpAssay ADM, including parent/child relationships and referential integrity.
- Explain check constraints.
- Recognise how cascade updates and deletes support referential integrity.
- Identify and discuss the data types used within the CorpAssay ADM.
- Define NULL and discuss its significance.
- Identify and discuss the main areas within the CorpAssay ADM.
- Summarise the four major table types and the relationships between them.
- Explain the purpose of compound definitions.
- Explain the purpose of stored procedures (SPs) and functions, and the role each plays.
- Explain the purpose of each table in the CorpAssay ADM.
- Discuss the role of triggers.
- Explain the rationale for a meta system.
3. Explain how the CorpAssay ADM is designed to support different workflows.
- Explain the concept of workflow.
- Explain Data Load Order (DLO) and how it assists with workflow management.
- Recognise the significance of the DLO value ”0”.
- Discuss other ADMs offered by acQuire and how they fit into the core CorpAssay ADM.
4. Demonstrate the ability to maintain a database using Microsoft SQL Server Management Studio and create an ODBC connection.
- Connect to a database.
- Backup and restore a database.
- Copy a database.
- Shrink a database.
- Distinguish between case-sensitive and case-insensitive databases and discuss the implications of using each.
- Explain the purpose of user accounts.
- Explain the purpose of database roles with a specific emphasis on ACQ_USER and ACQ_ADMIN.
- Create an ODBC connection for client access.
You can participate in this unit at one of these upcoming courses:
There are currently no upcoming courses that offer this unit. Please email firstname.lastname@example.org to register your interest in this unit, so that we can contact you when it is available.