CTPM Academy

Seminars, workshops and learning formats

Choose a topic and then the right delivery format. If you are not yet sure what fits, we will advise you personally.

Seminar finder

Which seminar matches your goal?

Search directly or narrow the selection by subject, duration and knowledge level.

Reset filters

3 matching seminars

15 carefully designed seminars – from a clear introduction to practical transfer.

SQL fundamentals and relational databases

Live online seminar

Databases & Data Integration

SQL fundamentals and relational databases

In plain language Select, join and analyse data safely

Show content and terminology

Start with tables, rows and columns, then select, filter, sort, join and aggregate data. Differences between standard SQL, Oracle, MySQL and MariaDB are explained where they matter in practice.

Technical terms you will learn Relational database, table, primary key, foreign key, SELECT, WHERE, JOIN, GROUP BY, NULL, DML

What you will work on
  • Understand relational databases
  • Select, filter and sort data
  • Aggregate and group data
Live online seminar1 dayFoundation
Next dateOct 14, 2026, 10:00–17:00Online
990.00 € 1,178.10 € incl. 19% VAT
Data modelling and SQL for relational databases

Live online seminar

Databases & Data Integration

Data modelling and SQL for relational databases

In plain language Organise data meaningfully and query it reliably with SQL

Show content and terminology

You learn what business objects need to be stored, how they relate and how clear and correct SQL queries are built.

Technical terms you will learn Datenmodellierung, Entität, Beziehung, Normalisierung, SQL, relationales Datenmodell

What you will work on
  • Practical examples & exercises
  • Quality & control points
  • Concrete transfer result
Live online seminar2 daysProfessional
Next dateDec 14, 2026, 10:00 – Dec 15, 2026, 17:00Online
1,790.00 € 2,130.10 € incl. 19% VAT
Oracle databases and PL/SQL in practice

Live online seminar

Databases & Data Integration

Oracle databases and PL/SQL in practice

In plain language Understand Oracle databases and build robust PL/SQL solutions

Show content and terminology

You combine SQL foundations with PL/SQL program logic and learn to build structured, transparent and reliable database code.

Technical terms you will learn Oracle Database, SQL, PL/SQL, Package, Transaktion, Performance

What you will work on
  • Practical examples & exercises
  • Quality & control points
  • Enterprise IT & project cases
Live online seminar2 daysProfessional
Next dateDec 16, 2026, 10:00 – Dec 17, 2026, 17:00Online
1,790.00 € 2,130.10 € incl. 19% VAT

Learning matrix

Compare seminars by learning content

The matrix shows which modules are a focus, included or explored in another seminar.

Compare the complete learning matrixOpen the detailed view to compare every module across seminars.
Everything considered market standard today is naturally included.CTPM+ describes what makes our seminar additionally valuable.
Distinguish market standard and CTPM+Show or hide each value class separately.
FocusIncludedOrientationOptional extensionNot included
Learning moduleSQL fundamentals and relational databasesData modelling and SQL for relational databasesOracle databases and PL/SQL in practice
Market standardCurrent models, tools & applicationsDistinguish language models, AI services, copilots and specialised tools by task, data access and degree of integration. Criteria such as output quality, data protection, cost, currency and integration into existing workplaces make selection transparent.Not includedNot includedNot included
Market standardCapabilities, limits & common failure modesLearn which tasks generative AI can support reliably and where probabilistic output, hallucinations, bias, context limits or outdated knowledge create risk. Common failure modes are recognised, assessed and connected to appropriate checks.Not includedNot includedNot included
Market standardSystematic promptingTranslate unclear work requests into structured prompts containing context, task, inputs, objective, quality criteria and output format. This makes requirements transparent, results easier to compare and follow-up questions more focused.Not includedNot includedNot included
Market standardImprove & reuse promptsImprove prompts in controlled steps, compare variants and distinguish professional weaknesses from wording or context problems. Proven patterns are versioned, documented and made reusable for similar tasks.Not includedNot includedNot included
Market standardReview & optimise resultsReview AI output for professional accuracy, completeness, contradictions, source grounding and fitness for purpose. Checklists, challenge questions and human approval points help correct weak results deliberately.Not includedIncludedIncluded
Market standardText, documents, research & knowledge workWork on common tasks such as drafting, summarising, comparing, extracting, classifying and preliminary research. Clarify required inputs, result validation and where AI usefully supports the existing workflow.Not includedNot includedNot included
Market standardConfidential information & organisational dataClassify personal, confidential and business-critical information and decide what data an AI service may process. Anonymisation, permissions, provider settings, internal rules and safer alternatives are assessed through practical situations.Not includedNot includedNot included
Market standardPractical examples & exercisesApply the methods to transparent tasks, compare alternative approaches and reflect on the impact of your decisions. Exercises combine explanation, hands-on work, feedback and a transferable improvement.Not includedFocusFocus
Market standardCourse materials & job aidsReceive and use checklists, structures, examples and concise references that remain useful after the seminar. Materials are not merely distributed; they are explained and related to common application situations.Not includedNot includedNot included
CTPM+Workflows & process chainsMap a real workflow with triggers, inputs, roles, decisions, handovers and outputs. Assess where AI can help, which controls are required and how a reliable pilot fits into the process chain.Not includedNot includedNot included
CTPM+Use documents & knowledge systematicallyDiscover existing text, documents and knowledge through source structure, metadata, terminology and suitable search or retrieval approaches. Quality, currency, permissions and the limits of a RAG or knowledge solution are made explicit.Not includedNot includedNot included
CTPM+Databases, interfaces, ETL & enterprise softwarePlace data objects, databases, interfaces, ETL pipelines and enterprise software into one coherent solution view. System boundaries, data flows, responsibilities, error paths and operational requirements are considered.Not includedIncludedIncluded
CTPM+Quality & control pointsDefine measurable expectations, validation rules and approval points for inputs, processing and outputs. Sampling, logging, escalation and human accountability create controlled use instead of blind trust.Not includedFocusFocus
CTPM+Enterprise IT & project casesWork on realistic cases from requirements engineering, business analysis, project management, development, architecture, quality and testing. Roles, system dependencies, trade-offs and technical constraints are explicitly included.Not includedIncludedFocus
CTPM+Reusable prompt, analysis & workflow templatesDevelop prompt structures, analysis templates and workflow patterns that can be reused with clear inputs, checks and ownership. Versioning and adaptation prevent templates from becoming uncontrolled one-off solutions.Not includedIncludedIncluded
CTPM+Concrete transfer resultCreate a tangible result for your own work, such as a prompt template, analysis, checklist, process sketch or pilot description. Next steps, ownership and success criteria make the transfer actionable.Not includedFocusFocus
CTPM+Adaptation to audience, knowledge & assignmentBefore an in-house session, audience, knowledge level, systems, assignment and desired outcomes are aligned. Examples, depth, exercises and transfer tasks are adapted to the actual organisational context.Not includedOptional extensionOptional extension
CTPM+Collaboration with sector expertsFor regulated, safety-critical or highly specialised content, the roles and responsibilities of a dual-instructor team are defined. CTPM covers AI, IT, data, architecture and methodology; the sector expert adds processes, terminology and binding requirements.Not includedNot includedNot included
Market standardRequirements engineering & business analysisStructure stakeholders, objectives, system boundaries and requirements using suitable elicitation, modelling and documentation techniques. Quality criteria, acceptance conditions, reviews and traceability connect business and delivery.Not includedNot includedNot included
Market standardSoftware architecture & modernisationDerive architecture goals from business and quality requirements and structure components, interfaces and responsibilities. Architecture decisions, risks, modernisation steps and transparent documentation are assessed together.Not includedNot includedNot included
Market standardData modelling, SQL & databasesTransform business concepts and rules into conceptual, logical and relational data models. Keys, relationships, normalisation, integrity, SQL queries and performance are treated as connected design decisions.Not includedFocusNot included
Market standardETL, interfaces & data integrationDesign the path from source to target systems with mappings, transformations, loading approaches and quality rules. Delta logic, error handling, restart, monitoring, metadata and lineage are considered from the start.Not includedNot includedNot included
CTPM+Legacy analysis & knowledge retentionCapture functions, data, interfaces, dependencies, documentation and implicit knowledge in an established solution. Risks and unknown areas become visible so modernisation can proceed incrementally without uncontrolled changes to current behaviour.Not includedNot includedNot included
Market standardUnderstand relational databasesPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardSelect, filter and sort dataPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardAggregate and group dataPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardJoin tables safelyPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardClassify data changes safelyPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardDistinguish standard SQL, Oracle, MySQL and MariaDBPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
CTPM+Translate business questions into SQLPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
CTPM+Validate results technically and functionallyPractical module with explanation, exercise, reflection and a reusable transfer result.FocusNot includedNot included
Market standardOracle SQL & PL/SQLWork with Oracle-specific SQL and PL/SQL from data access and transactions to procedures, functions and packages. Exception handling, performance, testing, interfaces and maintainability are connected through realistic database tasks.Not includedNot includedFocus
Market standardClarify role, assignment and mandatePractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardUnderstand stakeholders and interestsPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardCommunicate clearly at eye levelPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardPrepare and represent decisionsPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardAddress resistance and conflict earlyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardCreate commitment without hierarchyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
CTPM+Use briefing and debriefing effectivelyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
CTPM+Lead under uncertainty and secure transferPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included

Tailored priorities and additional modules are available for in-person and in-house formats after professional scoping.