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.
Active learning topic: Oracle SQL & PL/SQLReset filters
2 matching seminars
19 deliberately designed seminars – connected learning paths from AI and enterprise IT to practical transfer.
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 module | Develop and review Oracle SQL and PL/SQL with AI | Oracle 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 included | Not 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 included | Not 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 included | Not 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 included | Not 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. | Focus | Included |
| 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 included | Not 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 included | Not 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. | Focus | Focus |
| 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 included | Not 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 included | Not 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 included | Not 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. | Included | Included |
| 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. | Focus | Focus |
| 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 included | Focus |
| 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 included | 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. | Focus | Focus |
| 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 included | Optional 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 included | Not 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 included | Not 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 included | Not 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 included | Not 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 included | Not 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 included | Not included |
| Market standardUnderstand relational databasesPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardSelect, filter and sort dataPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardAggregate and group dataPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardJoin tables safelyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardClassify data changes safelyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardDistinguish standard SQL, Oracle, MySQL and MariaDBPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| CTPM+Translate business questions into SQLPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| CTPM+Validate results technically and functionallyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not 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. | Focus | Focus |
| Market standardClarify role, assignment and mandatePractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardUnderstand stakeholders and interestsPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardCommunicate clearly at eye levelPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardPrepare and represent decisionsPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardAddress resistance and conflict earlyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| Market standardCreate commitment without hierarchyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| CTPM+Use briefing and debriefing effectivelyPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not included |
| CTPM+Lead under uncertainty and secure transferPractical module with explanation, exercise, reflection and a reusable transfer result. | Not included | Not 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 included | Not 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. | Included | Not 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. | Focus | Not included |
| Market standardDeployment, operations and maintenanceRelease preparation, configuration, scripts, handover, monitoring, fallback and maintenance effects are treated as one operational process. | Not included | Not 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. | Focus | Not included |
| Market standardTechnical documentation and handoverDecisions, assumptions, interfaces, operating notes, open risks and validation evidence are documented clearly and maintainably. | Included | Not 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. | Focus | Not 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. | Focus | Not 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 included | Not 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. | Focus | Not included |
Tailored priorities and additional modules are available for in-person and in-house formats after professional scoping.