Online or onsite, instructor-led live PL/SQL (Procedural Language/Structured Query Language) training courses demonstrate through interactive discussion and hands-on practice the huge potential of PL/SQL in working with a database, automating processes and building applications, and the advanced mechanisms and solutions developed in this language.
PL/SQL training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live PL/SQL training can be carried out locally on customer premises in Trojmiasto or in NobleProg corporate training centers in Trojmiasto.
NobleProg -- Your Local Training Provider
Gdynia
Hotel Nadmorski, Ejsmonda 2, Gdynia, Poland, 81-409
The training room is located just 3 kilometers from the PKP/PKS Station in Gdynia, making it easily accessible for participants traveling by train or bus. Additionally, it is only 400 meters away from the bus stop, facilitating access even for those using public transportation. It is equipped with necessary training tools such as a projector, screen, and flipchart, providing comfortable conditions for both participants and the trainer.
Gdańsk
Hotel Fahrenheit, Grodzka 19, Gdańsk, Poland, 80-841
The training room is located in the very heart of the picturesque Gdansk Old Town, making the surroundings not only inspiring but also exceptionally attractive for participants. Within close proximity, you can find the railway and bus stations, facilitating arrival for those traveling by both train and bus. Additionally, the airport and port are also within reach, making this location convenient for individuals coming from distant places, both domestically and internationally.
This instructor-led, live training in Trojmiasto (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.
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.
Online PL/SQL training in Trojmiasto, PL/SQL training courses in Trojmiasto, Weekend PL/SQL courses in Trojmiasto, Evening PL/SQL training in Trojmiasto, PL/SQL instructor-led in Trojmiasto, Online PL/SQL training in Trojmiasto, PL/SQL classes in Trojmiasto, Weekend PL/SQL training in Trojmiasto, PL/SQL instructor-led in Trojmiasto, PL/SQL boot camp in Trojmiasto, PL/SQL on-site in Trojmiasto, PL/SQL private courses in Trojmiasto, Evening PL/SQL courses in Trojmiasto, PL/SQL coaching in Trojmiasto, PL/SQL instructor in Trojmiasto, PL/SQL trainer in Trojmiasto, PL/SQL one on one training in Trojmiasto