Course Code: OSP
Duration: 3 days
The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.
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 query and update data held in an Oracle Relational Database.
Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database.
The delegate will learn and acquire skills as follows:
This Oracle SQL course, together with the Oracle SQL Advanced 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.
This exam is not included as part of the course.
There are no formal pre-requisites for the Oracle SQL course, although an understanding of databases and exposure to information technology in general would be useful. This knowledge can be gained by attendance on the Relational Databases & Data Modelling Overview course.
This was a very useful and interesting course. The course was done at a good pace allowing plenty of workshop practice along the way.
Paul - Analyst - Insurance - October 2022
Very useful course, I think I've probably encountered a lot of what was covered in the past but a lack of formal training meant gaps both in detail and in the theory. This course seems to have covered the gaps nicely thanks. Very interesting as well.
David - Programmer/Analyst - Academic - August 2022
Many thanks. I found the training very useful and it was delivered very well. John explained the content thoroughly and clearly.
Devika - Executive Officer - Government - March 2022
An excellent course presented by a very knowledgeable instructor. The course covered a range of content that would be useful to me in a range of work place tasks. Instructor answered all questions in detail and worked with the group to provide a flexible useful course that met everyone's needs. The pacing of the course was just right for the scope of content.
Mollie - Graduate Trainee Engineer - Government - February 2022
Very good course. Made easy be remote access and labs. Very slick and smooth and John had superb, expert knowledge.
Peter - Applications and Data Reporting Engineer - Government - February 2022
This was a very positive learning experience for me. Kevin reacted to the ability / requirements of the learners and made the content interesting. He encouraged everyone to participate in the discussions and this really helped bring the subject to life. As a result, I have exceeded my own expectations and I'm now looking forward to putting the learning into action in the office.
Shaeron - Fines Policy and Governance Manager - Government - February 2022
Duration: 3 days
Price: £1,350.00 exc. VAT
|13 Feb 2023||Limited||Book Now|
|13 Mar 2023||Limited||Book Now|
|17 Apr 2023||Spaces||Book Now|
|22 May 2023||Spaces||Book Now|
|19 Jun 2023||Spaces||Book Now|
|17 Jul 2023||Spaces||Book Now|
|14 Aug 2023||Spaces||Book Now|
|11 Sep 2023||Spaces||Book Now|
|09 Oct 2023||Spaces||Book Now|
|06 Nov 2023||Spaces||Book Now|
|04 Dec 2023||Spaces||Book Now|
Live Virtual Classroom
Our Customers Include
Our Course Curriculum