What we’re about
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.
Upcoming events (4+)
See all- Don’t Get Hooked! Free Phishing Protection Training 🛡️Link visible for attendees
Are you confident you can spot a phishing scam?
Phishing, smishing, vishing, pharming, typo squatting - cyber threats are everywhere, trying to trick you into giving away your personal info.
Join our free, 21-minute online training.You will be able to:
- Understand the latest phishing and scam tactics
- Learn how to identify suspicious messages and calls
- Discover easy steps to protect your data and money
- Build confidence to stay safe online every day
Why attend?
✔️ Practical knowledge you can apply immediately
✔️ No prior tech skills needed
✔️ Flexible online access - learn anytime, anywhere
✔️ Completely free for Meetup membersEvent details:
📅 Start Date: Available immediately
⏳ Duration: 21-minutes of pure knowledge; no fluff
💻 Format: Self-paced e-learning course, 100% online
🔗 Link to join: Provided upon RSVP
Don’t wait until it’s too late — get ahead of scammers and protect yourself now!## How to join:
Click “Attend” to sign up and receive your free access link.
- Start with T-SQL - Learn MS SQL BasicsLink visible for attendees€440.00
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
- Don’t Get Hooked! Free Phishing Protection Training 🛡️Link visible for attendees
Are you confident you can spot a phishing scam?
Phishing, smishing, vishing, pharming, typo squatting - cyber threats are everywhere, trying to trick you into giving away your personal info.
Join our free, 21-minute online training.You will be able to:
- Understand the latest phishing and scam tactics
- Learn how to identify suspicious messages and calls
- Discover easy steps to protect your data and money
- Build confidence to stay safe online every day
Why attend?
✔️ Practical knowledge you can apply immediately
✔️ No prior tech skills needed
✔️ Flexible online access - learn anytime, anywhere
✔️ Completely free for Meetup membersEvent details:
📅 Start Date: Available immediately
⏳ Duration: 21-minutes of pure knowledge; no fluff
💻 Format: Self-paced e-learning course, 100% online
🔗 Link to join: Provided upon RSVP
Don’t wait until it’s too late — get ahead of scammers and protect yourself now!## How to join:
Click “Attend” to sign up and receive your free access link.
- Kick Off PostgreSQL – SQL from ScratchLink visible for attendees€400.00
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.
