In our seminar rooms or comfortably from home!
We support you as a consultant, organizer, and implementation partner for IT-qualifications, IT-projects, and Data Centre training
News: EPI joins the TÜV NORD GROUP
This marks a significant milestone in EPI’s 38-year journey, strengthening its position to serve customers while continuing to operate independently under the EPI brand
Our bestseller workshops
PDF
Seminartermine nach Kategorien
You can rent our seminar rooms!
Your booking with us is transparent and flexible, without hidden costs. Our seminar rooms in Cologne not only offer pleasant air conditioning, but are also equipped with high-quality technology such as PCs, flat screens and projectors.
Understand the fundamentals of relational databases & apply SQL in practice
Databases are a central component of modern IT solutions. They enable the structured storage, management, and analysis of large volumes of data. This seminar provides you with a solid understanding of database concepts and working with SQL — independent of any specific database system. You will learn the essential elements of relational databases, understand key principles such as keys, normalization, and referential integrity, and work extensively with SQL commands based on the ANSI standard.
Our experienced trainers will show you:
- how relational databases are structured and how database design works
- how SQL is structured and how different SQL dialects vary
- how to query, filter, sort, group & combine data
- how to join tables (JOINs), use subqueries & perform set operations
- how to insert, update, delete data and create or modify tables
- how to manage transactions & user permissions
Your benefits at a glance
- Solid foundation for working with relational databases
- Understand and apply ANSI SQL independently of specific systems
- Practical preparation for use with IBM, Oracle, MS SQL, MySQL and more
- Clearly structured introduction to database design & normalization
- Confident use of SELECT, JOIN, subqueries & DML commands
- Immediately applicable for business departments, IT projects, reporting & development
Seminar Content
Overview of Database Design
- Database models & structure of relational systems
- Designing & organizing databases
- Relational data model
- Primary & foreign keys
- Normalization
- Referential integrity
SQL Overview & System Dialects
- ANSI SQL fundamentals
- Differences between SQL variants (Oracle, IBM, Microsoft, Sybase, etc.)
SELECT – Creating Queries
- Basics of the SELECT statement
- Column selection, aliases, WHERE filters
- ORDER BY for sorting
- DISTINCT / UNIQUE to remove duplicates
- LIKE, IN & BETWEEN as search operators
Grouping, Functions & Conditions
- GROUP BY and HAVING
- String, date & mathematical functions
- Logical operators & complex condition chains
JOIN – Linking Tables
- INNER JOIN
- OUTER JOIN (LEFT / RIGHT)
- FULL JOIN
- Set operations: UNION, INTERSECT
Subqueries & Advanced Queries
- Subqueries in the FROM clause
- Subqueries in the WHERE clause
- Nested query concepts
Modifying Data (DML)
- INSERT – adding records
- UPDATE – making changes
- DELETE – removing records
Creating & Managing Tables (DDL)
- CREATE – creating new tables
- ALTER – modifying tables
- DROP – deleting tables
- Overview of additional commands (transactions, user permissions)
Target Audience
- Employees from business departments
- Application developers
- Organizers & IT project managers
- Entry-level database administrators
Prerequisites
- Basic user skills in Windows
- Initial experience with a database system is helpful but not required
Organize files, present content & enable efficient collaboration across your organization
This training is designed for users who are new to SharePoint Online or want to deepen their initial experience. You will learn about SharePoint’s role within Microsoft 365 and how it interacts with other apps. You will discover how to co‑author files, use metadata effectively, design web pages, and provide structured content for teams, departments, or the entire organization.
Our experienced trainers will show you:
- how to launch SharePoint Online, open sites, and navigate confidently
- how SharePoint functions as a collaboration tool
- how to use libraries, manage files & apply metadata
- how to create lists, filter views & structure information
- how to design SharePoint pages and use web parts effectively
- how to integrate content from Teams or Microsoft 365 Groups
- how permissions work for team sites and communication sites
Your benefits at a glance
- Clear overview of SharePoint Online & its role in Microsoft 365
- Consistent file storage & version‑safe collaboration
- Structured sites for teams, projects & corporate communication
- Effective use of lists, views & metadata
- Professional creation & design of SharePoint pages
- Better orientation & more confidence when managing permissions
Seminar Content
Fundamentals
- SharePoint & Microsoft 365: How the services work together
- Starting SharePoint Online
- Viewing & following sites
SharePoint Structure & Organization
- Hub sites
- Team sites and communication sites
- Site pages & subpages
- Structure & elements of a site
SharePoint as a Collaboration Tool
- Using or creating document libraries
- Co‑authoring files
- Checking out files
- Using version history
- Organizing files with metadata
- Creating custom views
Creating & Managing Lists
- Creating custom lists
- Calculated columns
- Creating new list views
- Importing lists from Excel
- Using calendar view
- Using board view
Enhancing SharePoint Pages
- Creating & editing site pages
- Subpages
- Adding & configuring web parts
- Apps & additional components
- Using & formatting text
- Adding & customizing news posts
- Hero web part & linking
- Displaying calendar events
- Using group calendars
- Adding images & galleries
Permissions
- Access to team sites
- Access to communication sites
- Users & audience targeting
Target Audience
- Users who want to work with SharePoint for file storage & document management
- People who want to build intranet pages or team sites
- Teams looking to structure & improve collaboration
- Employees who provide or organize information using SharePoint
Prerequisites
- Prior knowledge of Microsoft Teams is helpful but not required
Learn the essential features of PowerPoint and create your first professional presentations.
In this PowerPoint fundamentals course, you will receive a comprehensive and practical introduction to Microsoft PowerPoint (Microsoft 365 / Office 2016 / Office 2019).
Step by step, you will learn how to create, design and structure presentations effectively. This includes working with text, shapes, tables, charts, and using slide masters to achieve consistent design templates.
You will also learn how to collaborate on presentations online or within a team, how to work with visual elements in a professional way, and how to use animations and transitions purposefully.
The goal of this training is to help you gain confidence using PowerPoint so that you can present content clearly, logically and visually appealing.
Our experienced trainers will show you:
- how to use PowerPoint 365 efficiently and customize your workspace
- how to work professionally with slide layouts, placeholders and slide masters
- how to effectively use shapes, graphics, photos, tables and charts
- how to create engaging presentations with animations and transitions without overloading slides
- how to share, edit and present presentations locally, online or collaboratively in a team
Your Benefits at a Glance
- Clear and accessible introduction to PowerPoint in Microsoft 365
- Practical exercises with real‑world examples
- Consistent and professional presentation design
- Increased confidence when presenting to an audience
- Ideal for Office users and beginners in presentation creation
Course Content
Basic Program Operation
- Start a presentation locally or online
- Use and customize ribbons & menu tabs
- Adjust the workspace & Quick Access Toolbar
Text & Placeholders
- Use text placeholders
- Enter, edit & structure text
- Character & paragraph formatting
- Customize bullet points & numbering
Collaboration in PowerPoint
- Share presentations
- Co-authoring in PowerPoint Online
Graphic Elements & Drawing Tools
- Insert, format & align shapes
- Use shapes as hyperlinks
- Apply shape effects (shadow, 3D, reflection)
Slide Masters & Templates
- Work with the slide master
- Insert title masters, headers & footers
- Use notes & handout masters
Tables & Charts
- Create & edit tables
- Insert or link Excel tables
- Create, import & update charts
Photos & Image Editing
- Insert & position photos
- Apply effects, frames & remove backgrounds
Animations & Presentation Control
- Animate text & objects
- Use slide transitions
- Test & run your presentation effectively
Prerequisites
Basic knowledge of Microsoft Office or Microsoft 365 is helpful.
Target Audience
This seminar is designed for users who want to create business or personal presentations with PowerPoint.
Especially suitable for individuals working in office administration, marketing, sales, training or project management.
Work more efficiently with the latest features and cloud capabilities
Microsoft 365 introduces new features, cloud‑based tools and modern collaboration options that employees need to understand and use productively.
This hands‑on seminar shows you how to optimize your workflows, store files securely in the cloud, collaborate in real time and take advantage of the latest Microsoft 365 functionalities.
You will work with both the desktop and online versions of Word, Excel, PowerPoint and Outlook. New features such as XLOOKUP(), SORT(), FILTER(), dynamic table views, dictation, translation tools and the integration with Microsoft Teams are demonstrated through practical examples.
Perfect for anyone who wants to make a smooth transition to Microsoft 365 and use its new tools immediately and effectively.
Our experienced trainers will show you:
- how to use Word, Excel, PowerPoint and Outlook efficiently in a cloud‑based environment
- how to store, share and co‑edit files using OneDrive and SharePoint
- how to work with new Excel features such as XLOOKUP(), SORT(), FILTER() and table views
- how dictation, translation tools, icons and accessibility checks can boost productivity
- how to integrate Microsoft 365 seamlessly with Teams for improved collaboration
Your Benefits at a Glance
- Clear overview of new Microsoft 365 features
- Effective collaboration with Teams, SharePoint and OneDrive
- Save, share and co‑edit files efficiently
- Hands‑on introduction to new features in Word, Excel, PowerPoint & Outlook
- Practical exercises for immediate workplace application
Workshop Content
Microsoft 365 Overview
- Differences between desktop and online apps
- Editing documents in Teams, the browser or the desktop app
- Cloud storage and modern collaboration workflows
Cloud Storage: SharePoint & OneDrive
- Accessing cloud files across devices
- Co‑authoring documents in real time
- Sharing files, managing permissions & viewing version history
New Features in Word, PowerPoint & Outlook
-
Updated start screen & feature overview
- Dictation, translation tools, icons
- Accessibility checker
- PowerPoint: optimizing presentations, presenting in Teams
- Outlook: task management with Microsoft To Do
New Features in Excel
- Table views & navigation view
- View & track changes
- Dynamic functions: XLOOKUP(), UNIQUE(), SORT(), FILTER()
- Insert images directly into cells
Prerequisites
- Basic knowledge of Word, Excel, PowerPoint & Outlook is helpful
Target Audience
- Users who want to learn the new features of Microsoft 365
- Anyone looking to use cloud storage efficiently and collaborate seamlessly
- Employees who want to streamline their workflows with Microsoft 365
Half‑day overview course for efficient workshops, meetings & teamwork
Miro is an infinite digital whiteboard that helps teams collect ideas, design interactive workshops, and visually plan projects. In this compact overview course, you will learn the most important features, navigate the board with confidence, work with key elements, and discover practical use cases for meetings, workshops, and hybrid collaboration.
Our experienced trainers will show you:
- how the infinite whiteboard works and what it is best suited for
- which accounts organizers and participants need
- how smooth real‑time collaboration works
- how to structure, prepare, and present content
- how to professionally use templates, frames, and navigation
- how to integrate external content, secure results, and run workshops effectively
Your Benefits at a Glance
- Navigate the Miro board quickly and confidently
- Design meetings and workshops in an active, visual, and interactive way
- Structured content thanks to frames, templates & presentation mode
- Smooth collaboration in hybrid or remote teams
- Immediately applicable practical tips for facilitation & teamwork
Seminar Content
Introduction
- What is the infinite whiteboard?
- What can Miro be used for?
- Accounts & permissions: What does the organization need? What do participants need?
- Basics of real‑time collaboration
Core Elements & Navigation
- Orientation on the Miro board: keeping an overview
- Using sticky notes, text boxes, symbols, cards & graphic elements
- Key tools for workshops and collaboration
Frames, Templates & Presentations
- Structuring content effectively
- Creating your own templates
- Navigating and facilitating through content
- Preparing boards and locking elements
Multimedia, Documents & Notes
- Integrating external content (documents, images, multimedia)
- Securing and saving results
- Combining Miro with web conferencing & other tools
Practical Tips & Inspiration
- Tricks for efficient board preparation
- Sources for high‑quality templates and content
- Best practices for digital facilitation
Target Audience
- Trainers, facilitators, managers
- Project teams & workshop leads
- Employees who want to use Miro for meetings, creative processes, or collaboration
Prerequisites
- None
Data Centre training for many companies:
These customers already trust us
Maximize the security and efficiency of your data center with our certified Data Centre Training. Our practical training courses provide essential know-how on the design, operation and compliance of data centers. Through continuous training, you reduce downtime, minimize sources of error and meet international standards. Benefit from recognised certifications with the globally accredited training courses from PROKODA GmbH & EPI.
