This course is aimed at Oracle database developers, administrators and analysts who need to take the basics of Oracle SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive Oracle library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs. The course is appropriate to users of Oracle 9i, Oracle 10g and Oracle 11g.
Delegates should have Oracle SQL language experience to the level of our Querying Oracle Databases Fundamentals course.
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.
|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.)
"An enjoyable and productive day. A flexible content and pace of work which suited our needs."
Guardian News & Media
"One of the most enjoyable and informative courses I have ever attended."
"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 :-)"