Czym się zajmujemy
Comarch Training Center is part of the Comarch SA company structure dealing with organizing trainings. We offer a wide range of specialized distance learning trainings project. We focus on two types of training: IT and business training.
Nadchodzące wydarzenia (4)
Zobacz wszystkie- Free MS Excel Course – Start Learning TodayLink widoczny dla uczestników wydarzenia
Free MS Excel Mini E-learning Course – Available Now!
Looking to boost your productivity in Excel?
Whether you're a beginner or just want to refresh your spreadsheet skills, this free 75-minute e-learning demo is the perfect way to start!🔹 What you’ll learn:
- How to enter, copy, and move data effectively
- Easy operations on rows and columns
- How to use Flash Fill – and save tons of time
🌍 This demo is in English, accessible online from anywhere.
For whom?
Designed for beginners, professionals, and anyone managing business data.🎁 It’s completely free – no strings attached.
All you need to do is fill out a short form to get access.👉 Get your free access now: https://www.comarch.com/training/ms-excel-online-trainings/ms-excel-demo-training/
⏱️ Duration: 75 minutes
Follow us on LinkedIn Facebook and Instagram to get more expert tips, free resources, and upcoming courses.
Let’s get learning!
- Start with T-SQL - Learn MS SQL BasicsLink widoczny dla uczestników wydarzenia440,00 EUR
Kickstart your journey into the world of relational databases with hands-on Microsoft SQL Server training!
This course is designed for beginners – developers, analysts, and DBAs – who want to learn how to query and manage data using Transact-SQL (T-SQL).
The training combines short expert-led lectures with real-world exercises to give you practical skills from day one. You’ll learn how databases are built, how to write effective SQL queries, and how to transform data into valuable insights.
📊 Gain job-ready skills you can use in reporting, analysis, and database management.
👉 Sign up now and start speaking the language of data!Course Content:
- Relational databases – key concepts (tables, keys, normalization)
- SQL Server Management Studio basics
- SELECT queries and filtering (WHERE, TOP, sorting, aliases)
- Data types, conversions, text/date functions
- GROUP BY, aggregate functions
- Table joins (INNER, LEFT, etc.) and common issues
- PIVOT, UNPIVOT, APPLY
- UNION, INTERSECT, EXCEPT
- Subqueries and Common Table Expressions (CTEs)
- Data modification: INSERT, UPDATE, DELETE, MERGE
- Transactions and data locking
- Indexes and query performance basics
- Creating tables and constraints
- Views – creation and usage
- Kick Off PostgreSQL – SQL from ScratchLink widoczny dla uczestników wydarzenia400,00 EUR
Learn PostgreSQL – Master SQL from Scratch
Ready to start your journey with databases and data analysis?
This beginner-level PostgreSQL course will teach you how to write precise SQL queries and extract exactly the data you need for reports, dashboards, or applications. Perfect for future analysts, developers, and anyone working with business data.Whether you're building applications, analyzing trends, or writing reports - mastering SQL is essential.
Want to learn data analysis from scratch? Join our training!***
### Training Format
The course is delivered through instructor-led sessions divided into modules. Each module includes:
- A short theoretical introduction
- Live demonstrations
- Practical exercises (guided and independent)
- Q&A sessions to clarify real-world applications
***
### Syllabus – PostgreSQL Basic Course
Introduction to PostgreSQL
- Training goals and scope
- Open-source licensing model
- How PostgreSQL differs from other databases
- Using pgAdmin: basic tools and interface
Relational Databases – Core Concepts
- What is a database server?
- Server objects: databases, tablespaces, schemas, roles
- Relational model fundamentals
SQL Basics – Data Selection
- Creating simple queries
- SQL syntax and keywords
- Using column and table aliases
- Sorting results
- SQL functions:
- Single-row functions
- Group (aggregate) functions
- Filtering aggregation results
Joining Tables
- Types of joins:
- Equi-joins
- Non-equi joins
- Outer joins (LEFT, RIGHT, FULL)
- Self-joins
- Practical examples and exercises
Set Operations
- UNION, INTERSECT, EXCEPT
- Bulk operations on query results
Subqueries
- Subquery logic and structure
- Simple, nested, and correlated subqueries
- Decomposing complex queries
Data Manipulation (DML)
- INSERT, UPDATE, DELETE
- DML based on SELECT results
Transactions
- ACID principles
- COMMIT, ROLLBACK, SAVEPOINT
- Ensuring data integrity
Final Review & Certification
- Summary of key SQL concepts
- Participant Q&A
- Knowledge check / test
- Feedback survey
Payment details will be provided after you enroll. Our consultant will contact you with all the necessary information.
- Build Your First Container - Docker & PodmanLink widoczny dla uczestników wydarzenia600,00 EUR
### Build Your First Container – Docker & Podman
###
Want to simplify deployments and boost DevOps skills?
Learn how to build, run, and manage containers using Docker and Podman - two of today’s top containerization tools.-
Hands-on practice
-
Real-world examples
-
From basics to multi-container apps
Join now and start containerizing like a pro!
***
### Syllabus Highlights:
- What is containerization? VM vs. containers
- Running your first container (Docker & Podman)
- Building and managing container images
- Volumes and persistent data
- Container networking basics
- Docker Compose – multi-container setups
- Podman: secure, rootless alternative to Docker
- Tools overview: Buildah, Skopeo
Payment details will be provided after you enroll. Our consultant will contact you with all the necessary information.
-
