Opleidingen
68.923
resultaten
Oracle SQL performance (EN/NL/FR)
This 2-day ABIS course covers SQL query tuning and optimisation. Useful for anyone tasked with (and interested in) query optimisation. Interactive session, live classroom training. Prior knowledge of SQL, and basic knowledge of Oracle databases is recommended.
The cause of many database performance problems can still be traced back to the coding of defective, inefficient SQL statements. Writing SQL statements seems simple; the rules for doing so are generally known. But it is not possible to write efficient SQL without knowledge of the operation of the Oracle optimizer. Hence, we will focus on the various tasks of the optimizer in this course; and we will investigate where and how the application developer can influence this optimizer. A number of techniques are discussed: use of indexes, hints, importance of statistics, ... The tools we can use to evaluate the optimization process and our SQL statements in terms of performance evaluation are also discussed: Explain, SQL Trace, autotrace, ...
The purpose of this course is:
to explain the 'parsing' of Oracle SQL statements;
to focus on specific parts of that parsing - optimization, statistics, ...
to explain the measures and actions that are available to influence optimization - and parsing;
to review the various tools that are traditionally available to evaluate the efficiency of the coded SQL statements - QEP access path generation;
to analyze QEP access paths, in order to indicate where and possibly why certain suboptimal execution plans are generated.
Intended for
Analist-programmers, technical designers, DBA's, functional analysts. Everybody interested in how Oracle SQL statements are analyzed and optimized.
Backgroud
A basic knowledge of SQL (see SQL and relational databases fundamentals) is required; insights into the Oracle database structure is useful (see Oracle fundamentals course).
You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals'.
Main topics
Introduction to performance tuning - available tools and techniques (explain, SQLTRACE, autotrace, ...)
Identification of performance problems
The SQL optimisation process
Tuning table access (single value, ranges, multi-column lookup, ...)
Table join methods (types, optimization, join order) - Subqueries (simple, correlated)
Sorting, Grouping
The use of hints in SQL statements
Query tuning
Performance improvement through the use of PL/SQL
Advanced techniques for performance optimization
Training method
Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion
Delivered as a live, interactive training: available in-person or online, or in a hybrid format.
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.
Certificate
At the end of the course session, the participant receives a 'Certificate of Completion'.
Duration
2 days.
€1.310
Klassikaal
max 12
JCL (EN/NL/FR)
In this two-day ABIS training, you learn all syntax details of JCL, the Job Control Language of IBM.
JCL, the Job Control Language of IBM, is mainly used in a mainframe environment or on a MicroFocus Enterprise Server. JCL instructions allow us to launch applications in a non-interactive (i.e., "batch") way.
During this course you learn
to write JCL statements to obtain a correct execution of programs and to pass them the correct (input and output) data sets;
to interpret the returned (error) messages via SDSF (Spool Display and Search Facility);
to write, use and test JCL procedures.
Intended for
Programmers, operators, system programmers, schedulers.
Backgroud
Basic knowledge of ISPF is necessary (see course ISPF/PDF basics).
You can test yourself to see if you have enough background by filling out the online selftest.
Main topics
The Job Entry Subsystem (JES) and batch processing
The different statements and their function:
JOB statement: accounting information, job scheduling parameters, execution parameters, job output specification
EXEC statement: PGM, PROC, PARM, COND, TIME, etc.
DD statement: data set description, resource specification, output description, in-stream data sets, etc.
IF-THEN-ELSE construction
OUTPUT statement
Job log and job output • SDSF manipulation
Special datasets and associated parameters:concatenation • partitioned and sequential data sets • temporary data sets • backward references • GDG • SMS parameters • JOBLIB • STEPLIB • ...
INCLUDE and JCLLIB
Use of procedures:definition • parameters • changing and adding • symbolic parameters
Debugging of JCL, frequent abends, ...
JES2 control statements
Training method
About half of the time is spent on practical exercises.
Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a "Certificate of Completion".
Duration
2 days.
€1.260
Klassikaal
max 12
Patterns in Java (EN/NL/FR)
Leuven (BE)
do 18 jun. 2026
en 1 andere data
During this training, we will learn how to structure a Java application by use of (design) patterns. In this two-day ABIS course, we will focus on applying the main GoF patterns.
Patterns (such as the famous GoF Design Patterns) are essential if you want to develop reliable and maintainable software according to the proven OO principles. To start with, patterns are frequently incorporated in existing frameworks, programming languages and class libraries: if you understand patterns, you will use these programming resources more efficiently. In addition to that, being able to recognize problem situations and to actively apply patterns to them is the key to a more robust design.
In this course we will:
explain what patterns are
how we go from OO good practices to using patterns
give a detailed discussion of the most common design patterns (the problem, the solution, the motivation, the usage examples). and their (subtle) relations and differences
apply these patterns in an integrated Java exercise
Intended for
Java programmers that want to apply patterns in the development of their programs.
Backgroud
Students should have a good basic knowledge of Java SE (cf. Java programming). Familiarity with OOAD and UML principles (cf. OO analysis and design with UML) is a plus.
You can test yourself to see if you have enough background by filling out the online selftest "Java" and the online selftest "UML".
Main topics
Overview
What are patterns and why are they used?
How to learn patterns
Types of patterns
From OO design principles to Patterns
OO building blocks
OO design principles
SOLID
GRASP patterns
GoF Patterns
The GoF design patterns and template
Common design patterns in detail (Strategy, Singleton, Composite, Decorator, Chain-of-Responsibility, Factory Method, and many others...), applied in Java
Architectural Patterns
System Architecture Patterns (e.g. MVC)
Enterprise Architecture Patterns
Other Patterns
Analysis patterns
SOA patterns
Training method
Theory alternated with practical examples. A large amount of time will be spent on applying the 10 most common patterns using an integrated exercise.
Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the course session, the participant receives a 'Certificate of Completion'.
Duration
2 days.
€1.370
Klassikaal
max 12
DB2 for z/OS database administration (EN/NL/FR)
Obtain a deep, broad understanding of Db2 for z/OS during the 4-day intensive training at ABIS.
At the end of this course, the participant will:
have a clear overview of the very versatile tasks of a DBA in Db2;
have a thorough technical insight into the physical and logical structure of the different objects in Db2;
have learned to translate a logical data model into a physical database in test/acceptance/production environments;
have practical skills to define and prepare procedures for the management of the databases.
Intended for
New database administrators on Db2, and other Db2 users occupied with (part of) the tasks of a DBA.
Database administrators of Db2 who want a refresh, specifically regarding new possibilities in versions 12 or 13.
Backgroud
Sufficient practical experience with Db2 (see course Db2 for z/OS fundamentals course).
You can test for yourself to see whether you have sufficient background by filling out the online self-test "Db2".
Main topics
PART 1: Database Implementation
Overview of the versatile tasks of a DBA.
Physical design and implementation of Db2 objects:
Db2 object definition: decision rules
Possibilities for the implementation of a logical and physical design:
normalisation, datatypes, referential integrity (primary/foreign keys);
check constraints, triggers, sequence objects and identity columns;
XML, LOBs, views, aliases, ...;
index and tablespace design;
partitioning;
"time travel" tables
schema evolution: possibilities of ALTER (esp. for tablespaces and tables); pending changes
implementing a test environment: DDL • test data • statistics
preparing for migration
prepare the database for performance analysis (but see also course Db2 for z/OS SQL performance)
Access control on Db2 objects:
scenarios for efficient security management and auditing requirements
details regarding the different possibilities: owner-based, role-based, multilevel-based, or object-based; trusted context; "separate security" possibilities (incl. row permissions and column masks)
RACF-based access control
plans, packages, and bind & rebind options
The Catalog and the Directory:
contents • usage • management
effective use of the real-time statistics (RTS)
manipulation of a.o. optimizer statistics
PART 2: Database maintenance & integrity control
Data Utilities:
Using utilities: DB2I & JCL • listdef and templates • exec sql • tablespace sets • terminate and restart
online reorg • load & unload • check data & check index • rebuild index • runstats • statistics profiles • catmaint
Related aspects:
dynamic allocation of datasets (with or without SMS)
(re)partitioning of tables; moving data to other volumes
the use of data compression
possibilities of and potential problems with foreign keys
PART 3: Database recovery
Internal physical structure of Db2 data objects:
tablespaces and indexspaces, partitions; page sets and fan sets; VSAM; BSDS
using DSN1PRNT and DSN1COPY
Db2 backup and recovery utilities & service aids:
using utilities & service aids to backup, recover & verify integrity of data
inspect and copy the contents of Db2 datasets or selective pages
point-in-time recovery and disaster recovery: best practices
Training method
Theory with ample room for practical exercises.
Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a "Certificate of Completion".
Duration
4 days.
€2.740
Klassikaal
max 12
Big data in practice: text analytics (EN/NL/FR)
Leuven (BE)
vr 12 jun. 2026
en 1 andere data
Learn how "text mining" works in this one-day ABIS training.
"Big data" has everything to do with "analytics": analysing large amounts of data in order to extract "business intelligence" hence information from the data. Speaking of "data", we often think of numbers and tables, and statistical analysis of those. But there is a lot of knowledge hidden in textual data: ordinary messages, written by humans, either in full phrases or not: like e.g. emails, job application letters, Twitter and Facebook messages, newspaper articles, websites, you name it. The extracted information can then be used for e.g. a "simple" application like searching for a text fragment, sorted by relevance, based on a search keyword. A kind of "Google Search", otherwise said. Or for an application like sentiment analysis.
Quickly it will become clear that automated text analysis is more complicated than it might seem: aspects like language, grammar, spelling mistakes, synonyms, negation, order of words, punctuation marks ... complicate the analysis. This is because text is in the first place meant as a communication means between humans, not to be understood by computers. Even the "simple" Google Search application turns out to be a real "machine learning" challenge.
During this training
we'll first introduce the most important concepts and terminology related to text analysis and "text mining", like tokens, normalisation, lemmatisation, part-of-speech, language models, text classification, ...
we will work with some software packages and libraries (specifically in Python and R) that have been developed to take care of the technical foundation of "natural language processing" (NLP), like the NLTK toolkit.
Also the use of regular expressions will be treated.
At the end of this training, you will have built up sufficient basic expertise to set up a specific application which uses one of the NLP libraries, and which implements a text mining application.
Intended for
This training is intended for those who want to start practising "text analytics": developers, data architects, business analysts, and market researchers wanting to obtain a better idea of the building blocks and technologies behind text analytics.
Backgroud
Some familiarity with statistical concepts (histogram, classification, hypothesis tests), see e.g. Statistics fundamentals. Also, a minimal programming background is helpful.
Main topics
What is text?
Building blocks of text: characters and words; grammar; punctuation; word order; language dependencies
Tokenisation: conceptual and technical; normalisation, a.o. composite words
Lemmatisation; part-of-speech tagging
Use of word lists and of corpora
Syntax and parsing
Introduction to some popular parsing techniques
Regular expressions
Language models
Statistical models
"Bag of words"
TF-IDF (term frequency & inverse document frequency)
n-grams and frequency distributions
Natural language processing (NLP)
overview of the aspects studied by NLP, like semantics, context, similarity, sentiment analysis
text categorisation; clustering techniques; measures for similarity
NLP software
overview of the current state-of-the-art and freely available software toolkits
practical examples and exercises with one of the toolkits
Training method
Classroom training, with practical examples and supported by extensive exercises.
Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a "Certificate of Completion".
Duration
1 day.
€630
Klassikaal
max 12
Oracle DBA 1 - Core competences (EN/NL/FR)
In this 4-day ABIS course, the physical and logical properties of the Oracle database system are thoroughly explained and practically practiced. Useful for anyone who will start working as a (junior) Oracle DBA - but also for analysts, DevOps developers, .... Live, interactive classroom sessions. Prior knowledge of SQL, and basic knowledge of Oracle databases is recommended.
The database administrator (DBA) plays a key role in the data management process. The DBA is the scriptwriter and director in the design, implementation and maintenance of database structures; and is partly responsible for setting up and maintaining a high-performance database system. This course therefore offers a thorough technical and logical overview of the Oracle database management system. The training is primarily aimed at (starting) application DBAs.
This course:
gives you a clear overview of the various tasks of an Oracle DBA;
provide a detailed overview of the Oracle instance and database structures, and how to manage them;
provides a thorough technical overview of the physical and logical structure of the applicational Oracle objects;
provides an overview of the standard tools and utilities to monitor and manage these objects;
indicates how to set up these objects with a view to security.
Intended for
Database administrators (junior role); other users who perform part of the DBA's duties; application developers in a DevOps environment; Oracle system administrators who want to gain insight into the logical Oracle object structures.
Backgroud
Some familiarity with Oracle as relational database system, with the application development process, and with SQL (see Oracle fundamentals course and SQL and relational databases fundamentals).
You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals' and the on-line self-test 'Oracle fundamentals course'.
Main topics
The Oracle system:
instances • databases • overview
Physical structure of Oracle objects:
files • segments • extents • blocks
Logical structure of Oracle objects:
databases • table spaces • rollback segments • tables • partitions • views • synonyms • indexes • object dependent
Management of Oracle objects:
Oracle catalog views • use of the catalog for monitoring • reorganisation techniques
Access control:
creation of new users • creation of 'roles' • characteristics and control on the given privileges • set-up of scenarios
Backup and recovery procedures:
introductory concepts
Oracle utilities:
import/export • loader • utilities for the calculation of statistics and object validation • scenarios
Training method
Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion
Delivered as a live, interactive training: available in-person or online, or in a hybrid format.
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.
Certificate
At the end of the course session, the participant receives a 'Certificate of Completion'.
Duration
4 days.
€2.620
Klassikaal
max 12
Java SE advanced course (EN/NL/FR)
Leuven (BE)
wo 24 jun. 2026
en 1 andere data
During this training, we will dive deeper in the Java programming language. In this three-day ABIS course, we will study some of the most used Java SE libraries in more detail. In order to create more complete applications, an introduction into JUnit testing and logging will be given.
In this course:
the participant will deepen his knowledge of the Java programming language to build well structured applications
we will focus on topics like String handling and formatting, i18n, NIO2, functional programming, logging, testing, generics and multithreading
Intended for
Developers who are going to use Java to build well structured applications on a Java SE platform.
Backgroud
Participants should be familiar (at least 3 months of practice) with the basic Java SE environment (see course Java programming).
You can test yourself to see if you have enough background by filling out the online selftest "Java".
Main topics
Advanced Functional Programming
predefined functional interfaces
advanced stream topics
use of Optional
Comparing objects
equals() and hashCode()
Collections and Generics
collections and functional programming
custom generic classes and methods
Working with Strings
String vs. StringBuilder
formatting
tokenizing
Date/Time and I18N
Java SE8 DateTime API
Date and Number formatting
Localization and I18N
Advanced I/O Topics
Files and Paths
I/O enhancements in Java SE8 for reading/writing files
File manipulation: file attributes - moving and copying files - directory walking and searching
Multithreading and Concurrency
creating threads
thread interaction
Executors and ThreadPools
concurrent collections
parallel streams
Logging and Testing basics
log4j2
JUnit testing
Training method
Classroom instruction and demonstrations. A lot of time is spent on exercises.
Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a 'Certificate of Completion'.
Duration
3 days.
€1.965
Klassikaal
max 12
DB2 for z/OS SQL performance (EN/NL/FR)
Discover all secrets of the Db2 optimizer, and use this knowledge to spectacularly increase the speed of SQL queries, in this three-day training at ABIS.
Quality and efficiency are the main concerns for application developers. This also applies to the aspects of data access.
After following this course, participants
will be able to understand how the Db2 optimizer is able to optimally implement SQL queries;
will be able to apply techniques to further optimize those SQL queries.
Query optimization and a good concurrency are emphasized. Also discussed are some aspects of logical and physical design, and the statistical information in the Db2 catalog used by the optimizer.
During the practical sessions the participants will have ample opportunity to practise all the discussed topics.
Intended for
Application developers, analysts and database administrators. Also anyone responsible for the optimization of ad-hoc queries, for example in an infocenter environment, or the queries used in the context of a Data Warehouse.
Backgroud
Knowledge of Db2 (see Db2 for z/OS fundamentals course) and of SQL (courses SQL and relational databases fundamentals and SQL workshop).
You can test for yourself to see if you have enough background by filling out the on-line self-test "SQL Intermediate" and the on-line self-test "Db2".
Main topics
The Db2 access paths: tablespace scan • matching and non-matching index use • index-only access • list prefetch • direct access via RowID • hash access
Relation between the SQL query and the access paths: stage-1 versus stage-2 • multiple index use • correlated versus non-correlated subqueries • the join methods • influence of the clauses ORDER BY, OPTIMIZE FOR, and FETCH FIRST • views and CTEs • materialisation (work files)
The EXPLAIN function: exercises in reading and interpreting the access path descriptions, both for static SQL as well as through the Dynamic Statement Cache (DSC), with and without Visual Explain
Strategy: steps, actions and required information
Logical design and physical structure: normalization and denormalization • optimal implementation of table spaces, indexes and tables
The catalog: content • significance and use of the information • update by means of RUNSTATS or SQL • simulation of the production environment in a test environment • types of statistics information, runstats profiles, and optimizer feedback
Query optimization: what do we know about the optimizer? • how do we use this information? • how to transform a stage-2 predicate into a stage-1 indexable predicate? • which filter factors are assumed by the optimizer? • are these realistic? • how to choose the optimal alternative for joins, correlated/non-correlated subqueries? • how do we know which index is the optimal one? • how do we influence the optimizer's decision? • case studies
Use of one or more of the explain tables in the performance investigation: PLAN_TABLE, DSN_STATEMNT_TABLE, DSN_DETCOST_TABLE, DSN_FILTER_TABLE, and DSN_PREDICAT_TABLE
Use of "hints" (new style) to influence the Db2 optimizer • predicate selectivity
Use of the "virtual index" possibilities for carrying out a "what if" analysis
Concurrency: choosing the application structure and the right Db2 parameters, lock levels and locking strategy
Training method
Lecturing with practical exercises.
Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a "Certificate of Completion".
Duration
3 days.
€1.965
Klassikaal
max 12
ISPF/PDF: efficient use (EN/NL/FR)
Learn to use ISPF efficiently in this one-day ABIS training: its editor, its screens, and the most important utilities.
During this course, you'll learn
to use the ISPF interface efficiently: navigating between different screens and using the correct options;
to configure your own ISPF environment;
to take advantage of some less known possibilities of the editor;
to make use of the basic utilities and commands.
Intended for
Each participant who is going to use ISPF: programmers, analysts, job schedulers, system programmers, end users.
Backgroud
We expect you've already worked with the ISPF editor for some time (see course ISPF/PDF basics).
You can test for yourself to see if you have enough background by filling out the online selftest.
Main topics
Overview of TSO and ISPF:
logon procedure • TSO and ISPF dataset naming
ISPF user customization:
definition and utilisation of the PF keys and labels • log and list dataset • key lists • navigation possibilities
Edit advanced topics:
concatenation of libraries • defined find commands: picture strings, use of labels • use of exclude commands • text entry, text split and text flow • recursive edition • tabulations • sort • edit profile: line numbers, autosave, recovery, masks... • highlighting • compare
Utilities for dataset manipulation:
allocate, library utility, dataset list, compare and search-for utility
Some frequently used TSO and ISPF commands:
HELP, ALLOCATE, FREE, LISTALC, TRANSMIT/RECEIVE
Training method
This is a mainly practical course: most of the time is spent on practical exercises.
Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the session, the participant receives a "Certificate of Completion".
Duration
1 day.
€630
Klassikaal
max 12
Patterns in practice (EN/NL/FR)
During this training, we will learn how to structure object oriented applications by use of (design) patterns. In this two-day ABIS course, we will focus on applying the main GoF patterns.
Patterns (such as the famous GoF Design Patterns) are essential if you want to develop reliable and maintainable software according to the proven OO principles. To start with, patterns are frequently incorporated in existing frameworks, programming languages and class libraries: if you understand patterns, you will use these programming resources more efficiently. In addition to that, being able to recognize problem situations and to actively apply patterns to them is the key to a more robust design.
In this course we will:
explain what patterns are
how we go from OO good practices to using patterns
give a detailed discussion of the most common design patterns (the problem, the solution, the motivation, the usage examples). and their (subtle) relations and differences
Intended for
System architects and developers of object oriented applications.
Backgroud
Students should be familiar with basic OOAD and UML principles (cf. OO analysis and design with UML) and have experience with an object oriented programming language (e.g. Java, C#,...).
You can test yourself to see if you have enough background by filling out the online selftest "UML".
Main topics
Overview
What are patterns and why are they used?
How to learn patterns
Types of patterns
From OO design principles to Patterns
OO building blocks
OO design principles
SOLID
GRASP patterns
GoF Patterns
The GoF design patterns and template
Common design patterns in detail (Strategy, Singleton, Composite, Decorator, Chain-of-Responsibility, Factory Method, and many others...)
Architectural Patterns
System Architecture Patterns (e.g. MVC)
Enterprise Architecture Patterns
Other Patterns
Analysis patterns
SOA patterns
Training method
Theory alternated with practical examples (demos).
Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.
Certificate
At the end of the course session, the participant receives a 'Certificate of Completion'.
Duration
2 days.
€1.310
Klassikaal
max 12