Piotrków Trybunalski

Hotel AGAT, Wojska Polskiego 118, Piotrków Trybunalski, Poland, 97 - 300

Explore Our Courses

PL/SQL in Oracle 19c

 21 Hours
This instructor-led, live training in Piotrków Trybunalski (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c. By the end of this training, participants will be able to:
  • Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
  • Learn how to declare and use variables and different data types within PL/SQL blocks.
  • Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
  • Understand and implement explicit and implicit cursors for data retrieval.
  • Handle exceptions effectively using predefined and user-defined exceptions.
  • Develop and manage triggers to automate and enforce business rules.
  • Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.
Read more...

Tuning SQL i PL/SQL dla programistów

 28 Hours
The "Tuning SQL and PL/SQL for Programmers" training is aimed at experienced programmers and database administrators working with Oracle, focusing on optimizing the performance of commands SQL and programs PL/SQL. Participants acquire the skills to diagnose performance problems and effectively manage the optimization process. The course integrates lectures, presentations and practical tasks, enabling you to delve deeper into the topic of tuning SQL and PL/SQL in the Oracle environment.
Read more...

Last Updated:

Testimonials (2)

The exercises were explained very good.

Monica - DB Global Technology

Course - PL/SQL in Oracle 19c

Full professionalism of the instructor + perfectly prepared examples

Marcin Czarnecki - Biuro Projektowania Systemow Cyfrowych sp. z o.o.

Course - Tuning SQL i PL/SQL dla programistów

Machine Translated

Provisional Courses

PL/SQL in Oracle 19c

2025-06-10 09:00
21 hours
Piotrków Trybunalski
3870 PLN (Online)
3870 PLN (Classroom)

PL/SQL in Oracle 19c

2025-06-24 09:00
21 hours
Piotrków Trybunalski
3870 PLN (Online)
3870 PLN (Classroom)

Tuning SQL i PL/SQL dla programistów

2025-07-08 09:00
28 hours
Piotrków Trybunalski
4130 PLN (Online)
4130 PLN (Classroom)

PL/SQL in Oracle 19c

2025-07-22 09:00
21 hours
Piotrków Trybunalski
3870 PLN (Online)
3870 PLN (Classroom)

PL/SQL in Oracle 19c

2025-08-05 09:00
21 hours
Piotrków Trybunalski
3870 PLN (Online)
3870 PLN (Classroom)

Other regions in Poland

Other Countries

These courses are also available in other countries
Online PL/SQL training in Piotrków Trybunalski, PL/SQL training courses in Piotrków Trybunalski, Weekend PL/SQL courses in Piotrków Trybunalski, Evening PL/SQL training in Piotrków Trybunalski, PL/SQL instructor-led in Piotrków Trybunalski, PL/SQL boot camp in Piotrków Trybunalski, PL/SQL coaching in Piotrków Trybunalski, PL/SQL instructor in Piotrków Trybunalski, PL/SQL trainer in Piotrków Trybunalski, PL/SQL on-site in Piotrków Trybunalski, PL/SQL classes in Piotrków Trybunalski, Online PL/SQL training in Piotrków Trybunalski, PL/SQL instructor-led in Piotrków Trybunalski, PL/SQL private courses in Piotrków Trybunalski, Weekend PL/SQL training in Piotrków Trybunalski, Evening PL/SQL courses in Piotrków Trybunalski, PL/SQL one on one training in Piotrków Trybunalski