This course is aimed at application developers and database administrators. Delegates to the course will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will also learn programming, management and some of the security issues associated with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. The course is applicable to Oracle 9i, Oracle 10g and Oracle 11g users.
A solid understanding of SQL and 3GL programming is required. It is recommended that students have reasonable understanding of Oracle 10g SQL features.
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
|All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260|
|All prices are per person and are subject to VAT|
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)
"After the resounding success of our training last month, I need to organise another session as soon as possible!"
"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"
"Trainer's knowledge was immense, clearly an experienced practitioner."
Joseph Chamberlain College