Back to the list

Date
09.11. - 23.11.2016
Teachers
  • Annette de la Vega
  • Martin Nyffenegger
Price excl. VAT (CHF)
2'100.00
Course delivery
Please note that this is an online training.
For more details regarding the Avaloq e-learning please see the Academy Website www.learning.avaloq.com/en/online-training/online-training or get in touch with the Academy Contact Centre at academy@avaloq.com
Course description
Avaloq’s scripting language is the centrepiece of the Avaloq Banking System and used in almost every parameterisation area. Due to its ubiquity, Avaloq Script has become a very powerful and sophisticated tool. The language currently lacks high-performance debugging and optimisation tools. It is therefore the parameterisation professional's responsibility to understand the impact of what he is doing to ensure the correct and responsive behaviour of the software.
 
This course will provide tools in form of best practices, optimisation and debugging techniques, programming tricks and explanations of common pitfalls. At the end of the course day, the parameteriser will have a better understanding of the language, its possibilities, shortcomings and strengths in order to produce more robust and flexible and high-performance customisation of the Avaloq software.
 
This course has been developed in collaboration with www.unafortis.com
Objectives
Upon successful completion of this course every participant will:
  • Understand how the compiler works
  • Create and use tasks using Avaloq Script
  • Understand and master order processing using Avaloq Script
  • Take advantage of existing script utilities to enhance both flexibility and performance
  • Understand and evaluate different implementations in regards to their performance
Target audience
All Avaloq Certified Professionals who have contact with Avaloq Script on a regular basis
Prerequisites
Before attending this course, prior attendance of the course “Fundamentals of Avaloq Customisation (ACP)” is mandatory.
Participants must have either attended the course “ (BSC)” or have equivalent knowledge.
Additionally, participants must have at least 2 years of in-depth customisation expertise.
Course content
Avaloq Script Explained
  • Block-Structure, Variables, Constants, Initialisation
  • Exception Handling
  • Source overriding and overwriting
  • Understand compilation results
  • Execute Avaloq Script dynamically
  • Dependencies
 
Task Engine Techniques related
  • Create your own task
  • Synchronise the task execution
  • Execute work in another business unit (BU)
 
Efficient order processing with Avaloq Script
  • Memory management and optimisation
  • Commit efficiently and use bulk processing
  • Used named transactions to control complex workflows
  • Postpone workflow execution
 
Avaloq Script Libraries
  • Buffers, Arrays and table equivalents in Avaloq Script
  • Optimisation tricks and best Practices
  • Performance measurement
 
Logging
  • Logging possibilities in Avaloq
  • Log generation in Avaloq Script and in PL/SQL
  • Monitoring of Avaloq with built-in Tools
  •  
  • Tracing and Profiling
  •  
Using a PL/SQL debugger in Avaloq
Duration
2 x 6 hours of hands-on training and
10 hours of self-study
Avaloq Certified Specialist
This course is part of the specialisation in the area of competence
  • Technology & Security
Availability
Fully booked

Back to the list