Essential Oracle 12c PL/SQL training course

Synopsis for Essential Oracle 12c PL/SQL training course

So you are a wizard with Oracle SQL? There's nothing you can't do with SQL, outer joins, embedded SQL, merging tables, seen it, done it, got the badge, well you've either been on one of our Essential Oracle SQL courses or you have been working with SQL for some time. But once you get proficient with SQL you'll realise it does have its limitations, sure it's fast, sure its efficient and easy to read, but the constraints you can place on the tables is rudimentary at best and maintaining them is pretty clunky, and what about those business rules you need to enforce regarding data? Oracle don’t cater for anything other than generalised functions, if you want to make something lowercase, there's a function for that but if you want to check that the Visa or MasterCard number that has been entered is valid, there is nothing in Oracle SQL that you can run to check it.

This is where Oracle PLSQL comes it, it gives Developers the ability to define scripts and Database Objects which don’t replace SQL in an Oracle Database, PL/SQL enhances it. PLSQL is a structured language, and it's not for everyone to learn, if all you want to do is extract data for Management reports then this is probably not the course for you, however if you are creating or maintaining a complex Database then PLSQL is an essential tool for your skillset.

This Oracle PLSQL 12c course assumes that you have recently attended our Oracle SQL training course, if you know SQL but from another Database manufacturer let our training analyst know and they will advise you about what needs to be done before you take this course.

This PLSQL course is three days duration, it does not use the latest Oracle Database, that version has a different PLSQL course available, that Essential 18c PLSQL course is available as both onsite and as a public course throughout the UK and Ireland at various centres at regular intervals. This course because it's no longer the current version is only available as an onsite course, well we say that but you can come to us at our offices in Swansea or if you really want this version we can arrange training close to your location, there is no minimum numbers so even if you only have two people to train let us know we know we can help you.

Each course we give, and there are over 170 to choose from, have been written in-house, we've been around for twenty years so we know what we are doing. When we perform onsite courses we come to you with individual workstations for each Delegate, all we need is a room large enough for the number of people on the course … and of course … electricity … we don’t bring that with us, we bring everything else.

Did we tell you about the manuals? They are given to each individual, they can use them for notes, scribble on, heck they can even make origami figures with them, but that would be a mistake because our manuals are full of information and example pieces of code, great for reference after the training course and essential during the course when the Delegates are working on the exercises, oh yes there are plenty of practical work during the course, supported by the training Consultant the Delegates get to write professional Functions, Triggers and Procedures and learn all of the techniques needed for PLSQL.

Get in touch, our contact details are all over this website, we give no obligation quotations and don’t nag you after you have, satisfy your curiosity about us today.