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. Cardiff onsite live PL/SQL trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Cardiff
Radisson Blu Hotel, Meridian Gate - Bute Terrace, Cardiff, united kingdom, CF10 2FL
The Radisson Blu Hotel in Cardiff city centre is the perfect hub for your Welsh adventure
Close to several public transportation options, our hotel in Cardiff puts the city centre at your fingertips. Catch a train or a bus at one of the nearby stations, or take the M4 motorway and drive wherever you want to go in Wales and beyond. For those flying into the city, the Cardiff International Airport is just a 30-minute drive from the hotel. You’ll find parking around the hotel at the John Lewis, St David’s II and NCP Pellet Street car parks, plus some parking at the hotel. Enjoy shopping and dining within walking distance of the hotel, and explore the colourful history of this thriving capital city.
The hotel is located on Bute Terrace providing easy access to the M4 at junction 32 only 6 km away.
The central train and bus station is located within a five-minute walk from the hotel.
Cardiff International Airport is located 24 km from the hotel and can be reached by bus, train or taxi.
This instructor-led, live training in Cardiff (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.
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
Read more...
Last Updated:
Testimonials (2)
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
Provisional Upcoming Courses (Contact Us For More Information)
Online PL/SQL training in Cardiff, PL/SQL training courses in Cardiff, Weekend PL/SQL courses in Cardiff, Evening PL/SQL training in Cardiff, PL/SQL instructor-led in Cardiff, PL/SQL instructor-led in Cardiff, PL/SQL on-site in Cardiff, Evening PL/SQL courses in Cardiff, Weekend PL/SQL training in Cardiff, PL/SQL coaching in Cardiff, PL/SQL private courses in Cardiff, PL/SQL trainer in Cardiff, PL/SQL classes in Cardiff, PL/SQL one on one training in Cardiff, PL/SQL instructor in Cardiff, PL/SQL boot camp in Cardiff, Online PL/SQL training in Cardiff