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?

Choose your goal or narrow the selection by search term, subject, experience, duration and learning format. Every field is optional and can be combined.

Reset filters
Active learning topic: Data modelling, SQL & databasesReset filters

3 matching seminars

19 deliberately designed seminars – connected learning paths from AI and enterprise IT to practical transfer.

Data modelling and SQL for relational databases
Data modelling, SQL & databasesFocus

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,290.00 € 1,535.10 € incl. 19% VAT
Enterprise AI: organisational knowledge, RAG and data integration
Data modelling, SQL & databasesIncluded

Live online seminar

AI & Knowledge EngineeringDatabases & Data Integration

Enterprise AI: organisational knowledge, RAG and data integration

In plain language Create reliable AI answers from your own documents and data

Show content and terminology

RAG means that AI first searches approved enterprise sources and then formulates an answer grounded in the available knowledge.

Technical terms you will learn Retrieval-Augmented Generation (RAG), Embeddings, Vektorsuche, Quellenbezug, Knowledge Engineering

What you will work on
  • Confidential information & organisational data
  • Use documents & knowledge systematically
  • Databases, interfaces, ETL & enterprise software
Live online seminar2 daysProfessional
Next dateFeb 10, 2027, 10:00 – Feb 11, 2027, 17:00Online
1,450.00 € 1,725.50 € incl. 19% VAT
ETL processes and data integration
Data modelling, SQL & databasesIncluded

Live online seminar

Databases & Data Integration

ETL processes and data integration

In plain language Combine data from several systems and process it transparently

Show content and terminology

ETL means extracting data from sources, transforming it and loading it into a target under defined quality and error rules.

Technical terms you will learn Extract Transform Load (ETL), Datenmapping, Schnittstelle, Datenqualität, Fehlerbehandlung

What you will work on
  • Practical examples & exercises
  • Databases, interfaces, ETL & enterprise software
  • Quality & control points
Live online seminar2 daysProfessional
Next dateDec 15, 2026, 10:00 – Dec 16, 2026, 17:00Online
1,290.00 € 1,535.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 moduleData modelling and SQL for relational databasesEnterprise AI: organisational knowledge, RAG and data integrationETL processes and data integration
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 includedIncludedNot 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 includedIncludedNot 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.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 includedFocusNot 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.FocusNot includedFocus
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 includedFocusNot 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.IncludedFocusFocus
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.FocusFocusFocus
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.IncludedNot includedIncluded
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.IncludedNot includedNot included
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.FocusNot includedFocus
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.Optional extensionOptional 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.FocusIncludedIncluded
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 includedFocus
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.Not includedNot includedNot included
Market standardSelect, filter and sort dataPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardAggregate and group dataPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardJoin tables safelyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardClassify data changes safelyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
Market standardDistinguish standard SQL, Oracle, MySQL and MariaDBPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
CTPM+Translate business questions into SQLPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot includedNot included
CTPM+Validate results technically and functionallyPractical module with explanation, exercise, reflection and a reusable transfer result.Not includedNot 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 includedNot included
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
Market standardEnd-to-end traceability from requirements to releaseSource, requirement, design, change, test, approval and release are linked so decisions and effects remain explainable.Not includedNot includedNot included
Market standardAI-assisted implementation across technology stacksThe method is practised with SQL, PL/SQL, MySQL/MariaDB, PHP, JSON, HTML, CSS, JavaScript, SQL*Plus and Bash without turning the seminar into ten isolated language courses.Not includedNot includedNot included
Market standardTesting, regression and release gatesNormal cases, edge cases, side effects and unacceptable outcomes are translated into verifiable tests, regression checks and approval criteria.Not includedNot includedNot included
Market standardDeployment, operations and maintenanceRelease preparation, configuration, scripts, handover, monitoring, fallback and maintenance effects are treated as one operational process.Not includedNot includedNot included
Market standardTechnical error analysis and debuggingObservations, logs, reproduction steps, hypotheses and counterchecks are separated so plausible AI explanations are not mistaken for verified findings.Not includedNot includedNot included
Market standardTechnical documentation and handoverDecisions, assumptions, interfaces, operating notes, open risks and validation evidence are documented clearly and maintainably.Not includedNot includedNot included
CTPM+CTPM+: system context, dependencies and side effectsAffected components, data, interfaces, existing logic and possible side effects are identified and included in validation before change.Not includedNot includedNot included
CTPM+CTPM+: controlled human-in-the-loop workflowAI provides working drafts. People define goals and boundaries, review evidence and tests, decide on correction and approve further use.Not includedNot includedNot included
CTPM+CTPM+: Academy case – from requirement to verified patchAn anonymised case shows how requirements, database, PHP, web technology, testing, installation and documentation are iteratively supported by AI and professionally approved.Not includedNot includedNot included
CTPM+CTPM+: Oracle code, error analysis, reporting and documentationOracle SQL and PL/SQL context, data models, transactions, packages, failure modes, test data, reporting and documentation are treated together rather than in isolation.Not includedNot includedNot included

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