Course Code: OSA
|Birmingham||15 Mar 2018||Limited||Book|
|London||15 Mar 2018||Filling||Book|
|Edinburgh||15 Mar 2018||Spaces||Book|
|Sunderland||22 Mar 2018||Spaces||Book|
|London||12 Apr 2018||Spaces||Book|
|Manchester||12 Apr 2018||Spaces||Book|
|Leeds||12 Apr 2018||Spaces||Book|
|Bristol||19 Apr 2018||Spaces||Book|
|Birmingham||03 May 2018||Spaces||Book|
|Edinburgh||17 May 2018||Spaces||Book|
|London||17 May 2018||Spaces||Book|
|Sunderland||17 May 2018||Spaces||Book|
|Bristol||07 Jun 2018||Spaces||Book|
|Leeds||07 Jun 2018||Spaces||Book|
|London||14 Jun 2018||Spaces||Book|
|Manchester||21 Jun 2018||Spaces||Book|
|Birmingham||28 Jun 2018||Spaces||Book|
|London||12 Jul 2018||Spaces||Book|
|Edinburgh||12 Jul 2018||Spaces||Book|
|Sunderland||19 Jul 2018||Spaces||Book|
|Bristol||02 Aug 2018||Spaces||Book|
|Leeds||02 Aug 2018||Spaces||Book|
|London||09 Aug 2018||Spaces||Book|
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 examinations: Oracle Database SQL Expert (IZ0-047) and Oracle Database SQL Fundamentals (1Z0-071).
Before taking any 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.
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 - March 2017
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
Good Course. Good to learn new Oracle skills with good Training notes.
Richard - Technical Lead - Finance
If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or firstname.lastname@example.org to enquire if we can accommodate your venue requirements.
Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.
Technical course content was excellent and just what I required regards procedures, functions and packages, so the exercises were very useful and learning the syntax and formats and commands. Plenty of time was allocated for practical exercises and writing code which I would encourage on future courses. The theory was much needed also and improved my understanding of PL/SQL I have already seen in daily tasks. The trainer was very knowledgeable and took time to explain sections as required and answers to any questions. The folder will be very beneficial in practicing back at work to consolidate these Oracle skills.Andrew - Application Support Manager - Postal/Distribution - February 2018