Opleidingen
68.951
resultaten
Workshop BIAB Treatment
Hip, hot & happening: BIAB treatment! Instagram, Pinterest, je komt het tegenwoordig overal tegen. Dé treatment die je niet meer mag missen in je salon. Leer hoe je met het geweldige product Bottle Builder (buildergel in een flesje, ook wel bekend als Builder in a bottle & BIAB) dunne maar toch stevige nagels kunt creëren. Het product geeft extra stevigheid, hardheid en flexibiliteit. Ook is het product zelf-pinchend waardoor de natuurlijke nagel een mooie c-curve krijgt.
Voor wie is deze training: Voor de ervaren nagelstyliste. Must: ervaring met gelpolish & elektrisch vijlen
Tijd: 09:00 – 15:00 uur
Model nodig: Ja, korte natuurlijke nagel met lang nagelbed. Géén nagelbijter of probleemnagels. Geen kunstproduct op de nagels.
Kosten: €99,- incl. lunch en certificaat
Tijdens deze workshop leggen we de focus op de applicatie van het product Bottle Builder. We behandelen een stukje theorie, het stappenplan van een verkorte e-manicure met de elektrische vijl, hygiëne, het voorbereiden van de natuurlijke nagel en het plaatsen van de Bottle Builder op de natuurlijke nagel en het creëren van een apex (bolling) met het product waardoor de nagel sterker wordt maar ook optisch veranderd en er slanker uit komt te zien.
€114
Klassikaal
max 16
SQL for BI and Data Science (EN/NL/FR)
During this two-day ABIS training, you will learn how to use SQL for analysing data.
It may come as a surprise that so-called "in-database" analytics is used much less than it could be: most often, the (production) data is first copied to an analytics platform or BI tool to do the "data science" there. For large data volumes, or for data "in the cloud", this is not the best choice since precious time is lost by copying the data. This course will teach you how you can perform data analytics in the database itself. The learned techniques will of course also be applicable on data which has been copied, to an environment that supports SQL, e.g. to a data warehouse (DW), or to a Big Data environment like Hadoop (with Hive) or Spark.
After a short introduction on data warehouses, data lakes, business intelligence (BI) and Data Science topics, we dive into a thorough discussion on the syntactic possibilities offered by SQL. More specifically, statistical, analytical and OLAP functions will be treated, as well as the use of SQL for ETL, for data exploration, and (if applicable) for MapReduce. The most important ones are individually discussed and demonstrated; realistic labs should allow the participant to get an idea of the applicability of these SQL functions and options.
The SQL syntax covered in this course is platform independent. When relevant, platform specific syntax will be pointed out with respect to Oracle, Db2, SQL Server and Hive/Spark.
At the end of this training, participants will be able to:
understand how SQL (i.e., the SELECT instruction) can be used for reporting and explorative purposes in the context of DW, BI, Big Data and Data Science;
write effective SQL from a DW / BI / Big Data perspective;
write problem-based SQL statements, and evaluate possible alternative SQL constructs for their effectiveness
Intended for
This course targets everyone involved in the development of business reports, by means of SQL statements on relational database systems or Hadoop (Hive) or Spark SQL.
Backgroud
In order to have the full benefit of this course, it is important to be really proficient with SQL (level SQL workshop and being familiar with complex queries; having followed the SQL advanced course is an advantage). Furthermore it's important to be aware of some elementary statistical terminology (see e.g. Statistics fundamentals).
You can test for yourself to see if you have enough background by filling out the on-line self-test "SQL Intermediate knowledge".
Main topics
Data warehouse, business intelligence, Data Science -- positioning
Extract / Transform / Load (ETL)
the dimensional model
Statistics and analytics -- support in SQL
Purpose and context -- multi-platform support.
AVG, CORRELATION, COUNT, COVARIANCE, MAX, MIN, RAND, STDDEV, SUM, VARIANCE, MEDIAN, ...
Online analytical processing in SQL
Purpose and context -- multi-platform support.
RANK, DENSE_RANK, ROW_NUMBER, PARTITION BY, ORDER BY, ROWS, RANGE, GROUP BY, GROUPING SETS, ROLLUP, CUBE, OVER
WINDOWING functions: SUM ... OVER ..., LEAD; LAG and similar aggregation functions, and their application in a.o. trend analysis
Modelling: histograms; linear regression; normality testing; trend analysis; confidence intervals; ...
Text analytics; regular expressions
Training method
Class training alternated with exercises. These can be done on Db2, Oracle, SQL Server, MariaDB, Hive, or Spark. (Please indicate your choice on the enrolment form.)
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
CICS application programming (EN/NL/FR)
Learn to build CICS applications in COBOL or PL/I which will bring ISPF panels to life, during this three-day ABIS workshop.
CICS TS, or the "Customer Information Control System" Transaction Server of IBM, is a popular transaction manager for (principally) graphical applications on z/OS.
In this workshop,
you'll get an overview of the different CICS TS components which are related to the building of applications;
you become familiar with the different aspects of working in a CICS environment by using this information and by doing exercises;
message processing, data management, the use of different communication options and synchronisation are also discussed.
At the end of this course delegates will be able to write complete programs in COBOL or PL/I using CICS "command level" instructions.
Intended for
Application programmers who need to develop CICS applications using 'command level' instructions.
Backgroud
The students should be experienced in COBOL (see COBOL programming - part 1) or PL/I (see PL/I programming: fundamentals course). No knowledge of CICS is required.
You can test yourself to see if you have enough background by filling out the online selftest "COBOL" or the online selftest "PL/I".
Main topics
CICS coding: How to code CICS 'command level' instructions • their format, syntax and use • program preparation, development and testing
Controlling terminals: Coding CICS programs to facilitate interactive conversation with terminals • use of Basic Mapping Support
Error handling: CICS instructions to trap conditions, warnings or exceptions • the use of development tools and trace and debug facilities
Interprogram communication: LINK, XCTL and RETURN • the use of communication areas, of channels and containers, of temporary storage, of transient data • automatic task initiation
Data management: CICS instructions to read and change VSAM files • the browse commands • data base access
Performance aspects
Recovery: System and application recovery: the commands for commit and rollback • pseudo-conversational programming
Distributed working • CICS and the internet • CICS and web services
Training method
About half of the time is spent on doing exercises on terminal.
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
Big data architecture and infrastructure (EN/NL/FR)
What precisely is covered by the term "big data"? And how do companies benefit from analysing it? Come and learn this (and more) during this one-day course at ABIS.
These days everybody seems to be working with "big data". But what does this mean precisely? What kind of data are we speaking about? Which infrastructure does one need for it? And what does it buy us? During this training, we are pursuing answers to these questions!
Data is gradually becoming more and more vital to any kind of enterprise. Analysing large amounts of data aimed at optimizing enterprise processes, marketing, important decisions, ... is not new. But because of the steadily increasing data volumes, the increasing diversity of data sources, and the broader availability of data, such an analysis is expecting always more from the infrastructure, the software, and the data models. In so far even that it seems like a new framework will be necessary. The traditional, established relational model seems to fall short in describing and guiding the new challenges of "data analysis for business intelligence".
"Big data analytics" is the name of this coordinating framework, in which both old models and techniques (like date warehousing, online analytic processing, Hadoop, cluster analysis, ...) and newer insights (data in motion, emotional text analytics, ...) have found each other. The capability to condense relevant insights from more diverse, larger, and rapidly changing data, can help managers and other decision makers to better support their decisions.
This course
gives a general picture of big data and what it represents;
gives an overview of the technologies on which it is based;
goes through the frequently heard technological terms which we need to get acquainted with;
places these terms in context and perspective.
Intended for
The course is designed for everybody who wants to learn about big data: IT personnel, people confronted with big data technologies. Also for non (IT) technical collaborators.
Backgroud
Elementary knowledge of database management systems is an advantage.
Main topics
Introduction: about data, databases, and data warehouses - and now big data
What is big data?
Perspective: problem formulation - why big data?
data centric management
the 4 Vs: volume, variety, velocity, variability - types of data - examples
data quality, consistency, and reliability (veracity)
Big data architecture - components - technologies - towards an integrated data architecture
Overview of new data sources: web statistics ("click streams"); social media; Twitter feeds; Google Maps; sensor data (e.g. surveillance cameras) ant the Internet of Things (IoT); ...
NoSQL databases versus relational databases - types and use - and popular today: MongoDB, Cassandra, ...
Big Data Frameworks
The "divide & conquer" model: Hadoop and MapReduce - distribute data and analyse it through massively parallel algorithms
Spark: in-memory hence speed - supporting a plethora of data sources
Machine learning
Performance considerations
Big data analytics - know your data -- or: the role of the data scientist!
How to judge data quality; risk analysis - and the importance of statistics
Use of programming languages: Python, R, Scala, ...
Use of visualisation tools in order to keep an overview and to estimate the relative importance of the different data sources
Overview of often used (open source) products/technologies on the market
Training method
Classroom training.
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
two half days.
€655
Klassikaal
max 12
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