Now, you can learn PQL in bite-sized chunks and while you’re on the go with new microlearning courses from Celonis Academy. Microlearning courses are short e-learning modules that cover a single topic and usually take less than 15 minutes. The new PQL courses are all designed to take 6 minutes or less, so you can learn almost anywhere.
PQL Microlearning: Learn process query language on the go with these free courses
Knowing PQL, the process query language, can be a useful skill for both Celonis EMS users and those applying for in-demand, data-centric jobs. PQL is a domain-specific, programming language used to run process-related queries on the custom-built Celonis PQL Engine.
Celonis Academy PQL microlearning courses
Celonis Academy offers dozens of microlearning courses on process mining, task mining, execution management, sustainability and the Celonis EMS (execution management system). In May 2022, they released a series of new courses on PQL:
Celonis PQL: Design Goals & History - (video, 4 min): Find out about the five main pillars and history of Celonis PQL.
Basic Coding with PQL - CASE WHEN (video, 3 min): Have a look at what you can do with the CASE WHEN function.
CALC_THROUGHPUT - Basic Coding with PQL (video, 3 min): Calculate the time between two activities.
Process Index Functions - Basic Coding with PQL (video, 6 min): What is an index and what are index functions doing?
MATCH_PROCESS_REGEX - Basic Coding with PQL (video, 5 min): Look at specific process variants with this powerful regex function.
PROCESS EQUALS - Basic Coding with PQL (video, 4 min): Define a specific process pattern.
DateTime Modifications - Basic Coding with PQL (video, 2 min): Modify your timestamps and dates.
ISNULL and IS NULL - Basic Coding with PQL (video, 2 min): Check for NULL values.
LIKE - Basic Coding with PQL (video, 3 min): Let's do a fuzzy match.
BETWEEN - Basic Coding with PQL (video, 2 min): Use this function to look at a specific value range.
CASE WHEN - Basic Coding with PQL (video, 3 min): Have a look at what you can do with the CASE WHEN function.
COALESCE - Basic Coding with PQL (video, 4 min): Have a look at what you can do with CASE WHEN function.
Understand Basic SAP P2P Data (video, 2 min): Familiarize yourself with tables in SAP on a P2P process.
Introduction to the P2P Process (video, 1 min): What does a P2P Process consist of?