Course Code: OSA
Duration: 2 days
The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 11gR2, 12cR2, 18c, 19c.
To provide the skills needed to use the more advanced features of Oracle SQL.
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.
The delegate will learn and acquire skills as follows:
This Oracle SQL Advanced course, together with the Oracle SQL course, covers the major topics required for the delegate to work towards achieving the following exam:
Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying these courses and their associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.
Before taking this exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates should have attended the Oracle SQL course or have a similar level of experience.
Fantastic trainer. The class was a mix of technical and non-technical analysts and everyone fully understood each and every part of the training - even though some sections were slightly harder than others. We were given ample time to complete the practical exercises and the trainer was really good and showing us where we went wrong (without making us feeling stupid). I highly recommend this course to anyone wanting to expand their Oracle SQL knowledge.
Graham - Lead Information Analyst - NHS
The trainer was very knowledgeable and very patient, I enjoyed the course very much and will recommend other colleagues within my organisation to use StayAhead for their IT training.
Gavin - Systems Manager - Postal/Distribution
Very good teacher. Knows the subject well and is enthusiastic. Facilities are great too.
Scott - 2nd Line It Support Analyst - Government
lots of information covered will be beneficial for us back in the office improving the efficiency of our current sql scripts and alter the way we create new queries going forward
Steven - Analyst - Government
I thoroughly enjoy the Advanced SQL course and learnt a lot in the duration. The most interesting parts was learning about Oracle + REGEX and how we can use that to identify patterns. I will now incorporate that with my day to day usage. The trainer provided clear examples and explained sections very well, where we did not understand he would clarify further.
James - Insurance
Great course material and the tutor was not only very knowledgeable, but also very willing to share his own experience and go the extra mile to ask about our own daily duties to try and tailor scenarios to help us more. Can't wait to progress through to more advanced courses.
Mitch - System Analyst - Postal/Distribution
Duration: 2 days
Price: £895.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum