Advanced SQL, Script Objects and Data Tracking
Take your SQL knowledge to an advanced level in order to get more out of your GIM Suite configuration via custom scripts and audit tools such as data tracking.
Who should attend?
- Database managers who require advanced SQL skills, proficiency in complex script object development, and in-depth knowledge of the acQuire Data Model (ADM).
- Anyone seeking GIM Suite Professional (3000) accreditation.
Learning Outcomes
1. Develop and utilise advanced SQL functionality.
- Demonstrate the use of conditional processing in a SQL script.
- Explain and use a SQL sub-query in a SQL script.
- Distinguish between IN or EXISTS in a WHERE clause.
- Explain and use a database view.
- Differentiate between the types of temporary tables.
- Explain triggers.
- Demonstrate the use of SQL variables.
- Recognise the SQL conditional tests IF/ELSE and WHILE and use these.
- Explain cursors and recognise when to use these.
- Recognise the difference between stored procedures and user-defined functions and when to use either.
- Differentiate between scalar and table-valued user-defined functions.
- Create stored procedures and user-defined functions.
- Use acQuire 4 provided stored procedures and functions.
- Explain dynamic SQL and its advantages/disadvantages.
- Create a script using dynamic SQL.
- Recognise how to use SQL Server Management Studio debugging tools to debug SQL.
2. Develop and utilise acQuire 4 script objects.
- Explain the purpose of a script object.
- Explain the options in script sheet settings.
- Demonstrate a script sheet which utilises SQL.
- Explain the purpose of the control sheet.
- Demonstrate control sheet programmability.
- Create a control sheet consisting of controls which pass values to the datasheet.
- Create a data sheet which utilises DOS commands.
- Explain the purpose of the Copy with Control Variables feature.
- Demonstrate how to debug a script object.
- Demonstrate the use of some common acQuire 4 client-side functions.
3. Install and use object/record tracking
- Recognise the difference between object tracking and record tracking.
- Demonstrate how to install and use object tracking.
- Demonstrate how to install and use record tracking to audit or rollback changes to data.
This course/unit is available on request. Please email learning@acquire.com.au to register your interest.
Code
400
Duration
5 days
Medium
Face-to-face Prerequisites
