Oracle 11g PLSQL training course with APEX

Synopsis for Essential Oracle 11g PLSQL training course with APEX 4.2

This is one of our previous training courses which uses Application Express (Apex) to teach delegates the procedural language PLSQL, we love PLSQL it is such a versatile language for use against an Oracle Database, whichever version you currently have installed.

PLSQL is effectively an extension of SQL, it picks up where SQL runs out of steam, although we are very experienced practitioners of Oracle SQL (and other flavours) we do accept that it has weaknesses, for example the Database table constraints in SQL are pretty primitive and not straight forward to maintain, of course, you can add indexing and limited ranges via SQL but what if you need to compare a column value with another? For example when a date of birth, although valid is not within the acceptable value range for the business rules, what if someone adds a date in the future for date of birth, it’s a valid date in its structure but you can't allow births in the future!! The secret here is to place an before insert trigger on the table, this is written in PLSQL and using raise_application_error the PLSQL Developer can prevent the record spoiling the integrity of the data (or as an alternative the date could be changed to today's date – this is a matter of business policy).

In addition to maintaining data integrity, PLSQL can be used to create processes to perform bulk actions on the Database overnight or indeed during transactional events, Developers can also create additional Functions to standardise business rules within the Database, an example might be to check whether the date entered is a bank holiday in the UK or not, Oracle does not come with a built in function to determine this but any Company dealing with the UK either within the country or outside would need to know if on the date specified the business is open 'for business'.

The course webpage you are currently looking at is not the most current we can supply for you and your Delegates, the Database has moved on a few versions in the last years and we have also moved with it, therefore you might wish to use our menu system to view what our current offering of training courses in PLSQL is. We are however, perfectly happy to come to you to perform this course on site, within this page you will find the essential details of the course, its duration, its minimum requirements for attendance (SQL knowledge for example) and we also publish the breakdown of the course content with PDFs for download for review.

When we perform the course onsite, we don’t use your equipment, all we need is a room with tables and chairs and an electricity supply! We provide the rest, Oracle Database, an individual machine for each Delegate and our comprehensive and high quality manuals, our Consultants are people who walk the walk not just stand and repeat what's in the manual, they are seasoned practitioners of PLSQL and know what they are talking about.

There are plenty of ways to contact us, these details are at the top and bottom of the page, plus there is an enquiry form if you wish to fill that out, any quotations we give are valid for 6 months and not subject to minimum numbers for booking, get in touch and find out how we can help you.