Course Code: OSA
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.
The delegate will learn and acquire skills as follows:
Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database.
To provide the skills needed to use the more advanced features of Oracle SQL.
Together with the Oracle SQL course, the Oracle SQL Advanced course covers the major topics required for the following Oracle examination:
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.
Course Code: OSA
|Leeds||27 Sep 2018||Limited||Book|
|London||04 Oct 2018||Limited||Book|
|London||01 Nov 2018||Spaces||Book|
|Edinburgh||01 Nov 2018||Spaces||Book|
|Leeds||22 Nov 2018||Spaces||Book|
|Birmingham||22 Nov 2018||Spaces||Book|
|London||29 Nov 2018||Limited||Book|
|Bristol||29 Nov 2018||Spaces||Book|
|Manchester||06 Dec 2018||Spaces||Book|
|Edinburgh||20 Dec 2018||Spaces||Book|
|London||10 Jan 2019||Spaces||Book|
|Birmingham||17 Jan 2019||Spaces||Book|
|London||24 Jan 2019||Spaces||Book|
|Manchester||24 Jan 2019||Spaces||Book|
|Leeds||24 Jan 2019||Spaces||Book|
|Bristol||31 Jan 2019||Spaces||Book|
|London||07 Feb 2019||Spaces||Book|
|Edinburgh||21 Feb 2019||Spaces||Book|
|London||07 Mar 2019||Spaces||Book|
|Birmingham||07 Mar 2019||Spaces||Book|
- Guaranteed to Run (StayAhead's Terms & Conditions apply)
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 - September 2018
Really enjoyed it and learned a lot out of it! The instructor is a very understanding and explains everything very well using a mix of practical examples, self-tests and theory.
George - CRM graduate - Utilities - December 2017
The course content was excellent and met the requirements very well for what we need for our support team roles and activities in oracle SQL. The trainer was very enthusiastic and knowledgeable regards Advanced SQL and shared this well with good explanations, live examples and through our own opportunity to do the exercise online. The trainer also took time for us to discuss how we could apply certain topics to our real system support and also listened to our suggestions on which topics might be more useful, which was well received. Good course all in all and will be very useful and applied in work.
Andrew - Application Support Manager - Postal/Distribution
Good content and good documentation for reference. Trainer was very knowledgeable.
Adam - Analyst Developer - Finance
Course material and instruction both good.
Ben - Analyst Developer - Finance
Very good. Thanks to the Trainer, great knowledge.
Gareth - Associate Developer - Finance
Public Scheduled and Closed
UK and Overseas
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!