Opleidingen
69.016
resultaten
Command line voor Data Engineers (Bash/WSL + Azure CLI)
Omschrijving
Werk je in Azure of Fabric en kom je steeds vaker in aanraking met de command line? In deze training krijg je een snelle, praktijkgerichte start met shell‑werken: je leert bestanden en mappen vlot beheren, log‑ en data‑bestanden inspecteren en transformeren, krachtige pipes en one‑liners bouwen en JSON verwerken met jq. Je oefent specifiek in de Windows‑/WSL‑ en Azure‑context en zet Azure CLI in voor veelvoorkomende data‑taken. Alles wat je leert in Bash kun je ook makkelijk toepassen op andere sh‑achtige shells (zoals zsh).
Voor wie is de training "Bash voor Data Professionals"?
Voor data engineers, BI‑ontwikkelaars en data scientists die vooral in Windows/Azure werken en hun productiviteit willen verhogen met de command line. De training is geschikt voor starters zonder CLI‑ervaring én voor wie al eens met PowerShell of Git Bash werkte en Bash/Shell beter wil leren begrijpen. (Hiermee sluiten we opzet en doelgroep aan op de huidige pagina.)
Doelstellingen
Na deze training kun je:
Het verschil tussen shell, terminal en Bash uitleggen en kiezen welk middel je wanneer inzet.
Bestanden en mappen navigeren en beheren (incl. wildcards/brace‑expansion).
Tekst en JSON inspecteren, filteren en transformeren met o.a. grep , sort , uniq , cut , sed (intro) en jq .
Pipes, redirects en command substitution effectief combineren tot krachtige one‑liners.
Processen beheren en kleine scripts schrijven met variabelen, condities en loops.
Bash slim gebruiken op Windows met WSL, en Azure CLI toepassen in veelvoorkomende data‑scenario’s (resources opvragen, output met jq verwerken).
Voorkennis om de training te volgen
Voor deze training is geen voorkennis van de commandline vereist. Ervaring met cmd (ook wel bekend als de "DOS box"), PowerShell, Git Bash of een andere shell is altijd mooi meegenomen, maar niet noodzakelijk.
Onderwerpen
Kick‑start Shell & Terminal: wat is een shell, verschillen met PowerShell; filesystem‑basics ( cd , ls , mkdir , rm , mv , cp ).
Werken met data (tekst & JSON): less , head , tail ; zoeken/filtreren ( find , grep ), sorteren/unieken ( sort , uniq , cut , paste ), bewerken met sed (intro); JSON‑analyse en ‑transformatie met jq .
Kracht van compositie: stdin / stdout / stderr , redirects, pipes, command substitution; veelgebruikte patronen voor data‑teams.
Scripten & productiviteit: shebang, variabelen, loops, functies, exit‑codes, foutafhandeling, shell‑history en personalisatie ( .bashrc , .profile ).
Bestandsrechten: chmod , chown ; paden en line endings (Windows <-> Unix/Linux).
Bash op Windows (WSL): padverschillen, rechten/performance‑tips, werken vanuit VS Code/Dev Containers.
Azure CLI & Cloud‑taken: resources query’en, output als JSON verwerken met jq , en basisoperaties voor storage. (Haakt aan op de Azure/WSL‑context in de huidige beschrijving.)
Studiemateriaal
We werken met zelf ontwikkeld lesmateriaal en concrete, herhaalbare oefeningen. Je ontvangt alles wat je nodig hebt bij de start.
€1.599
In-company / Maatwerk
IBM Db2 12: SQL Workshop [2LA22G]
OVERVIEW
This course provides an introduction to the SQL language. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments.
This course introduces SQL, including syntax, retrieving data from a Db2 table, coding inner joins, arithmetic operations, and scalar and columnar functions. Learners will also explore the UNION function, inserting, updating, and deleting rows, and will use the create table and create view statements. Additionally, learners will be introduced to advanced functions and performance optimization features in Db2 v12.
Learners will participate in hands-on exercises to practice what they have learned.
OBJECTIVES
After completing this course, learners should be able to:
Explain the role and use of SQL dialects (DDL, DML, and DCL) in managing and interaction with Db2 databases
Summarize the new and deprecated features of Db2 v12, such as enhanced query optimization
Retrieve rows based on comparisons to numeric or alphanumeric column values
Implement correlation names in queries to simplify table references
Implement rounding and truncation functions, including ROUND and DECIMAL
Utilize the GROUP BY clause to categorize data into meaningful subsets and the HAVING clause to filter grouped results based on aggregate conditions
Apply date and time functions to extract, manipulate, and compare date, time, and timestamp values in SQL queries
Identify the impact of special registers, advanced window functions, and AI-driven query optimization on database performance and workload management
Differentiate between UNION and UNION ALL and explain how each affects query performance and result set behavior
Explain the role of subqueries in SQL and how they differ from standard joins in retrieving data
Explain the role of transaction management using COMMIT, ROLLBACK, and SAVEPOINT to control database changes
CONTENT
Unit 1: SQL Introduction
Unit 2: Simple SQL Queries
Unit 3: Retrieving Data from Multiple Tables
Unit 4: Scalar Functions and Arithmetic
Unit 5: Column Functions and Grouping
Unit 6: Advanced Functions
Unit 7: Performance Optimization
Unit 8: UNION
Unit 9: Using Subqueries
Unit 10: Maintaining Data
€520
E-Learning
IBM Db2 12: SQL Workshop for Experienced Users [2LA32G]
OVERVIEW
This course covers fundemental and advanced SQL techniques for efficient data management, optimization, and analytics in Db2 12. Participants will learn how to navigate the Db2 system catalog and explore query performance optimization techniques, including indexing strategies, predicate pushdown, and query access plans to improve efficiency.
The course also introduces advanced SQL functions, such as LISTAGG, PERCENTILE_CONT, and PERCENTILE_DISC. Participants will learn how to create and manage database objects and gain expertise in utilizing advanced join techniques such as inner and outer joins, hash joins, lateral joins, and set operators like UNION, INTERSECT, and EXCEPT to merge and analyze data from multiple tables.
The course also covers the use of subqueries and query optimization techniques, including correlated subqueries, EXISTS/NOT EXISTS, and quantified predicates to enhance data retrieval efficiency.
Through hands-on exercises and real-world scenarios, they will develop the skills necessary to handle large datasets efficiently and implement best practices for high-performance database management.
OBJECTIVES
After completing this course, learners should be able to:
Demonstrate the use of OLAP ranking functions (RANK, DENSE_RANK, ROW_NUMBER) to analyze and order query results
Optimize queries with expression-based indexes for computed values
Utilize set operators like UNION, EXCEPT, and INTERSECT for advanced data merging
Leverage summary tables and MQTs to precompute and store aggregated data
Apply EXISTS, NOT EXISTS IN, IN, and NOT IN predicates for conditional data retrieval
Perform numeric and mathematical operations, including logarithmic, exponential, and trigonometric calculations
Implement recursive SQL to process hierarchical relationships
Leverage ARRAY data types to pass structured lists of values within SQL queries and procedures
Analyze and optimize SQL execution plans with EXPLAIN and VISUAL EXPLAIN
CONTENT
Unit 1: SQL Introduction
Describe the structure and purpose of Db2 v12, including its system catalog, database organization, and key SQL components
Explain how Db2 catalogs and system tables store metadata, and how they can be queried for database object information
Demonstrate the use of OLAP ranking functions (RANK, DENSE_RANK, ROW_NUMBER) to analyze and order query results
Unit 2: Create Objects
Create and modify tables, columns, and constraints
Use generated columns to automate calculations and reduce dependency on triggers
Optimize queries with expression-based indexes for computed values
Implement referential integrity, check constraints, and triggers for enforcing business rules
Leverage views and materialized query tables to simplify data access and reporting
Unit 3: JOIN
Use inner and outer joins to retrieve related data across tables
Optimize query performance with hash joins for large datasets
Leverage lateral joins for more flexible row-by-row processing
Perform self-joins to analyze hierarchical or recursive relationships
Utilize set operators like UNION, EXCEPT, and INTERSECT for advanced data merging
Unit 4: CASE, CAST, Summary (Materialized Query) Tables, and Temporary Tables
Use CASE expressions to apply conditional logic within queries
Perform data type conversions using CAST
Leverage summary tables and MQTs to precompute and store aggregated data
Implement temporary tables and SGTTs to handle intermediate results
Unit 5: Using Subqueries
Use basic subqueries to filter and retrieve data dynamically
Leverage correlated subqueries for row-dependent queries
Apply EXISTS, NOT EXISTS, IN, and NOT IN predicates for conditional data retrieval
Utilize LATERAL subqueries to execute row-by-row subqueries for sequential logic processing
Optimize query performance by structuring subqueries efficiently
Unit 6: Scalar Functions
Use string functions to extract, modify, and format text data
Perform numeric and mathematical operations, including logarithmic, exponential, and trigonometric calculations
Apply LISTAGG to concatenate multiple row values into a single string
Work with data and time functions to extract, manipulate, and format timestamps
Unit 7: Table Expressions and Recursive SQL
Use nested table expressions to create temporary result sets for complex queries
Leverage common table expressions (CTEs) for modular and reusable SQL structures
Implement recursive SQL to process hierarchical relationships
Apply performance optimization techniques to improve efficiency in recursive queries
Unit 8: An Introduction to UDTs / UDFs and Stored Procedures
Define User-Defined Distinct Types (UDTs) to create custom data types for specialized business needs
Implement User-Defined Functions (UDFs)
Utilize stored procedures to encapsulate complex database logic for performance efficiency
Leverage ARRAY data types to pass structured lists of values within SQL queries and procedures
Unit 9: SQL and Db2 Performance
Use indexes, clustering, and predicate pushdown
Analyze and optimize SQL execution plans with EXPLAIN and VISUAL EXPLAIN
Improve filtering and sorting performance using predicate processing techniques
Leverage RUNSTATS enhancements to ensure up-to-date statistics for query optimization
€720
E-Learning
IBM Cognos Analytics 12: Modeling with Data Modules [J5320G]
OVERVIEW
This course provides a high-level overview of the IBM Cognos Analytics v12 Data Module tool and its underlying architecture to provide learners with the skills necessary to master data modeling using the web-based, self-service capabilities of IBM Cognos Analytics v12 Data Modules. Learners will explore the essential steps in building data modules, from understanding the purpose and workflow of data modeling to creating, refining, and optimizing data structures. The course covers various topics, including managing relationships, advanced features and performance optimization, data enrichment with calculations and filters, creating groups and navigation paths, and managing data security.
Learners will gain hands-on experience through exercises that enhance their ability to create and customize data modules, review and modify column properties, creating calculations, filters and data groups, and adding column dependencies. These hands on activities ensure learners practice consistency and usability for reporting, dashboarding, and exploration purposes.
By the end of this course, learners should be proficient in developing data modules that integrate multiple data sources, support business analysis, and facilitate informed decision-making within the IBM Cognos v12 environment.
OBJECTIVES
After completing this course, learners should be able to:
Describe the data modeling workflow, including identifying sources, enriching the module, and testing it.
Navigate the Cognos Analytics v12 Data Modules user interface and upload a source file.
Demonstrate how to create, edit, and optimize relationships in Cognos Analytics v12, including utilizing the Null Safe option and configuring cardinality for accurate data integration.
Organize data modules by hiding, renaming, or removing fields.
Use SQL to create a new table by writing and validating a custom query.
Configure custom sorting for a specified column and validate its application in reports or dashboards.
Utilize the Enhanced Expression Editor to create a custom calculation combining fields from two tables.
Design a navigation path and validate functionality in dashboards.
Configure row-level security filters, assign permissions, and utilize security definitions.
Configure advanced data module functionalities, including column dependencies, bridge tables, and summary tables.
And more
CONTENT
Course Introduction
Unit 1: Data Modeling in Cognos Analytics v12
Unit 2: Creating Data Modules
Unit 3: Managing Relationships
Unit 4: Reviewing and Organizing Data Modules
Unit 5: Advanced Features and Performance Optimization
Unit 6: Customizing Data Modules with Filters and Calculations
Unit 7: Grouping Data and Creating Navigation Paths
Unit 8: Organizing and Sharing Data Modules
Unit 9: Advanced Functionality in Data Modules
€550
E-Learning
IBM Cognos Analytics 12: Overview of Dashboards [J5370G]
OVERVIEW
This course provides a comprehensive introduction to building interactive, insightful dashboards and stories using IBM Cognos Analytics version 12.
Through a combination of demonstrations, hands-on practice, and best practices, you will learn how to create compelling visualizations, develop dynamic stories, build explorations for advanced analysis, and apply forecasting and drill-through techniques to enhance user interactivity. The course covers both foundational and advanced features, including new visualization properties, customization options, and predictive insights.
By the end of the course, you will be able to design professional, data-driven dashboards and deliver actionable insights to support better business decision-making.
OBJECTIVES
After completing this course, learners should be able to:
Customize dashboard visualizations
Explore and use the AI Assistant for dashboard design
Select and integrate at least two different types of data sources into a dashboard
Add visualizations using drag-and-drop, AI Assistant queries, and Pinned tabs
Implement and customize filters in a dashboard
Use the AI Assistant to generate visualizations, apply filters, and perform aggregations
Leverage native insights to automatically generate natural-language summaries of key data patterns
Adjust the timeline of objects in a scene to control appearance and disappearance during playback
Enhance a story by adding animations to objects and highlighting key data points to emphasize insights
Create an exploration from a visualization, dashboard, story, or data asset
Leverage suggested starting points and AI-driven recommendations to expand and refine your analysis
Explain how to create and import a custom visualization into a dashboard
Apply forecasting techniques and configure drill-through definitions to create dynamic, context-driven dashboards
CONTENT
Course Introduction
Unit 1: Introduction to Dashboards
Unit 2: Create a Basic Dashboard
Unit 3: Advanced Dashboard Functions
Unit 4: Create a Story
Unit 5: Create an Exploration
Unit 6: Visualizations
Unit 7: Advanced Data Interactions and Analysis Features
€550
E-Learning
IBM Maximo Manage: Advanced Work Management [MAX4352G]
OVERVIEW
This courses focuses on some of the more advanced features of Work Management in Maximo Manage including Reliability Strategies, Work Order Intelligence, Dynamic Job Plans and process flow control. This course contains lectures, demonstrations, and hands-on labs as well as an end of course quiz which you should pass in order to receive the course badge.
OBJECTIVES
Discuss Reliability Strategies.
Use the Operational Dashboard.
Create Work Queues.
Understand Work Order Intelligence.
Create dynamic Job Plans.
Generate conditional Work Orders.
Use process flow Control.
Create Inspections.
CONTENT
Introduction to Reliability Strategies
Demo: Reliability Strategies
Operational Dashboards and Work Order Summary application
Work Queues
Intro to Work Order Intelligence
Demo: Work Order Intelligence
Maximo Mobile: Inspectors
Process Flow Control
Demo: Process Flow Control
Conditional Job Plans
Demo: Conditional Job Plans
Dynamic Job Plans
Demo: Dynamic Job Plans
Demo: Dynamic Job Plans on Linear Asset
€550
E-Learning
IBM Maximo Mobile: Customization using MAF and Configuration [MAX4353G]
OVERVIEW
This course is designed for administrators and developers who are tasked with customizing Maximo Mobile applications and configuring Maximo Mobile application in MAS. In this course, you will learn to install the Maximo Application Framework (MAF) Configurator tool, using the tool to customize Maximo Mobile applications, and publishing the customized application and validating them from the mobile devices. Along with that, you will learn about the authentication mechanisms for MAF, configuring maps for mobile, and setting up push notifications and preloaded database for user groups. This course includes carefully curated demonstrations and hands-on labs.
OBJECTIVES
After completing this course, you will be able to:
Install MAF.
Run the MAF configurator container.
Explain the authentication mechanisms of MAF.
Understand and clone an application in MAF.
Modify XML code in app.xml and JS code in AppCustomizations.js to customize the application.
Discuss about the usage of datasource, object structures, and saved queries in customizing applications in MAF.
Preview and publish the customized application.
Learn about upgrading applications in MAF.
Set up Preloaded database for user groups.
Set up and generate push notifications from MAS to mobile devices.
Learn about map configuration in Maximo Manage for mobile applications.
Explain the properties and set up in MAS Manage to enable mobile app customization and configuration.
Discuss the best practices for customizing and configuring Maximo Mobile applications.
CONTENT
Build a foundational understanding on customizing and configuring Maximo Mobile
Introduction to Maximo Mobile
Customizing Maximo Mobile using MAF
Datasource, Object Structures, and Saved Queries
Configuring Maximo Mobile
Maximo Manage setup and best practices
Learn about customizing Maximo Mobile applications using Maximo Application Framework
Maximo Application Framework (MAF) configurator tool setup
Introduction to MAF configurator tool
Demo: Customizing TECHMOBILE application from MAF
Demo: Maximo Mobile upgrade
Learn about configuring Maximo Mobile from MAS
Demo: Preloaded database setup
Demo: Map configuration
Demo: Push notifications
Practice what you have learned (hands-on-lab)
Earn a badge
€550
E-Learning
IBM Maximo Manage: Fundamentals of Application Designer [MAX4354G]
OVERVIEW
In this course, you will explore how to modify existing applications and create new ones in Maximo Manage. You will gain a comprehensive understanding of the different types of applications available, their functionalities, and how to configure them effectively. To reinforce learning, you will have access to a lab environment where you can practice modifying and creating applications using the Application Designer in Maximo Manage.
OBJECTIVES
Explore the various types of applications available in Maximo Manage and their specific uses.
Gain a brief overview of Database Configuration concepts.
Understand the different domain types and learn how to configure lookups in applications.
Set up the environment required for application development.
Configure system properties and understand their roles and applications.
Learn how to implement restrictions for applications.
Examine signature options and their functionalities.
Understand the purpose and usage of User Information in applications.
Walk through the steps to modify or create an application effectively.
CONTENT
Database configuration
Overview of domains and lookups
ALN domain
NUMERIC domains
SYNONYM domain
TABLE domain
CROSSOVER domain
Demo: Creating domain and lookups
Introduction to Application Designer
Environment preparation for application development
Creating and modifying applications
Application Designer control properties
Creating restrictions
Defining signature options
Providing user information
Demo: Creating and modifying applications
Hands-on lab
Quiz
€590
E-Learning
Hoe jouw lichaam bevalt
In deze bevalcursus leer je hoe je lichaam werkt tijdens de bevalling en hoe je je fysiek en mentaal kunt voorbereiden. Voor vrouwen die bewust willen bevallen, op een manier die bij hen past.
In je eigen kracht bevallen? Deze bevalcursus helpt je bewust voorbereiden
Zwanger, of wil je dat binnenkort worden? Dan heb je vast al gemerkt dat er veel op je afkomt. Goedbedoelde adviezen, medische termen, standaardvoorlichtingen — maar waar blijf jij zelf in het verhaal? Hoe voel jij je bij de gedachte aan bevallen? Met deze bevalcursus leer je hoe je op jouw manier kunt bevallen. Zonder ruis, zonder opgelegde richtlijnen, maar mét vertrouwen in je lichaam en je keuzes. Je krijgt praktische kennis, nuchtere uitleg en ruimte voor wat jij nodig hebt. Zodat je straks niet alleen voorbereid bént, maar je dat ook écht voelt.
Waarom deze bevalcursus anders is dan je gewend bent
Veel zwangerschapscursussen richten zich op wat er kan gebeuren. Deze cursus laat je vooral zien wat jij zélf kunt doen — met je hoofd, hart en lijf. Valerie, doula en geboortecoach, neemt je stap voor stap mee in de processen van de bevalling. Ze combineert haar ervaring als verpleegkundige met haar rol als begeleider van vrouwen die bewust willen leren over bevallen. Je leert wat je lichaam doet, hoe je ruimte kunt maken voor vertrouwen, en hoe je je mentaal voorbereidt op de overgang naar het moede
€27
E-Learning
1 uur
Geschiedenis van de beschaving
Leer in deze complete geschiedenis cursus hoe beschavingen ontstonden, groeiden en veranderden. Van oermens tot digitale tijdperk: je krijgt inzicht in revoluties, religie, macht, oorlog en technologi
Complete geschiedenis cursusVraag je je weleens af waarom onze wereld is zoals hij is? Wat ons gevormd heeft, waar onze ideeën vandaan komen, en waarom samenlevingen telkens veranderen? In de cursus Geschiedenis van de beschaving krijg je het grotere plaatje helder. Van de eerste mensen tot vandaag de dag: je leert hoe beschavingen ontstaan, groeien, botsen én verdwijnen. Je hoeft geen historische achtergrond te hebben om deze cursus te volgen. In heldere videolessen word je stap voor stap meegenomen langs belangrijke periodes, gebeurtenissen en ideeën die de wereld gevormd hebben. De lessen zijn kort, duidelijk en goed te volgen, waar en wanneer je maar wilt.De geschiedenis van de mensheidDeze complete geschiedenis cursus is perfect voor iedereen die meer wil weten over de mens, macht, cultuur, technologie, oorlog en ideeën. Je ontdekt hoe samenlevingen zijn opgebouwd, hoe veranderingen ontstaan en wat we vandaag nog steeds kunnen leren van het verleden. Geen lange lappen theorie of saaie jaartallen, maar begrijpelijke uitleg en concrete voorbeelden die geschiedenis tot leven brengen.Dit leer je in de cursus:In deze complete geschiedenis cursus leer je hoe beschavingen zijn on
€123
E-Learning
10 uren