SQL Basic Webinar for Implementors and Developers

---

2. Time Schedule

Time	Topic	Content
09:00	Introduction and SQL environment overview	Introduction to workshop goals, basic SQL Server concepts, databases and PANTHEON database structure.
09:15	Understanding PANTHEON database structure	– Developer Site and searching SQL objects – Overview of SQL objects: • tables • views • procedures • functions • triggers • constraints – Understanding database structure and relationships between data
10:15	☕ Coffee break	Break
10:30	Basic SQL queries and data retrieval	– SQL Editor in PANTHEON environment – Basic SELECT statement structure – Retrieving data from tables – WHERE conditions – Filtering and sorting data – Basic SQL functions – Practical examples using PANTHEON tables
12:00	🍽 Lunch break	Lunch
12:30	Connecting data – JOINs and relationships	– Understanding relationships between tables – INNER JOIN – LEFT JOIN – APPLY – Connecting master data and documents: • customers/suppliers • items • documents • document lines – Practical examples of combining PANTHEON data
13:45	☕ Coffee break	Break
14:00	Working with SQL objects in PANTHEON	– Views and their purpose – Functions: • scalar functions • inline table functions • table-valued functions – Stored procedures and parameters – Understanding SQL objects used by PANTHEON processes
15:15	SQL analysis and practical troubleshooting	– Using SQL Log as a diagnostic tool – Finding procedures called by PANTHEON – Analyzing procedure parameters – Understanding SQL behind reports and system processes – Practical exercises and discussion

---

3. Workshop agenda

• Detailed Curriculum

---

4. Registration information

By clicking the ‘Register’ button, you will be redirected to Datalab PartnerSite, where you can complete the registration process. In the menu TeamDL | Knowledge | Education & Certification, select the following option:

• Enroll here – Complete the registration process for the webinar. Select: Registration for Education > Education: Practical Manufacturing Implementation Workshop 2026

You can register for the workshop until 20 January 2026. After this deadline, registration will only be possible on a case-by-case basis by sending an inquiry via e-mail to vanja.cigoj@datalab.eu

If you decide not to attend after registering, please notify us in writing no later than 20 January 2026. Cancellations received after this date or failure to attend the workshop will result in a charge of 100% of the registration fee per person.

5. Terms and Conditions

• Terms and content changes*:
  • The content, schedule, and other information related to this workshop are subject to change. Participants will be informed accordingly of any changes.
  • The workshop will be held if at least 20 participants are registered (of those, a minimum of 10 participants from partner companies).
  • This workshop is exclusively intended for Datalab employees and partner companies.

  *Partner companies:

  • Only partner companies with a valid partnership agreement may participate in this webinar.

We reserve the right to modify or adjust the programme according to the group’s dynamics, participants’ questions and discussions, their prior knowledge, and the progress of the training. The published programme is indicative and may be adapted as needed to ensure the most effective learning experience.

---

6. Presenter’s biography

Marko Tuk

• Marko is a Lead Developer for the Production module at Datalab, with many years of experience in SQL and Delphi development. He is actively involved in the development and improvement of production-related functionality within the PANTHEON ERP system.
• During his work at Datalab, he has gained extensive practical experience in SQL performance optimization, including the optimization of queries, stored procedures, and other SQL objects. He has also attended numerous lectures and training sessions focused on SQL performance tuning. During the workshop, he will share practical experience, real-life examples, and useful approaches for identifying performance issues and improving SQL execution efficiency.