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.
This is a complex subject area, and I felt that the information was conveyed very well by Kevin. A lot of effort went into on-screen demos, that reinforced the learning. Presentation of course content and verbal explanations were delivered in a way that was light and fun to be a part of.
Peter - Applications and Reporting Engineer - Government - February 2022
The course was very informative and expertly delivered, in a virtual environment. John was very knowledgeable and managed to keep a good pace, explaining things well, whilst providing lots of good examples. This course will prove invaluable back in my work environment. Thank you.
Andrew - Government - January 2022
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
Duration: 2 days
Price: £895.00 exc. VAT
|23 Jun 2022||Spaces||Book Now|
|28 Jul 2022||Spaces||Book Now|
|25 Aug 2022||Spaces||Book Now|
|15 Sep 2022||Spaces||Book Now|
|13 Oct 2022||Spaces||Book Now|
|10 Nov 2022||Spaces||Book Now|
|08 Dec 2022||Spaces||Book Now|
|12 Jan 2023||Spaces||Book Now|
|09 Feb 2023||Spaces||Book Now|
|16 Mar 2023||Spaces||Book Now|
|20 Apr 2023||Spaces||Book Now|
|25 May 2023||Spaces||Book Now|
Live Virtual Classroom
Our Customers Include
Our Course Curriculum