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.
John was very good at explaining and answering any questions. Very informative and knowledgeable.
Albie - Associate Infrastructure engineer - March 2021
Great course, very useful, and Kevin was excellent :)
Andrew - Apllication SUpport Analyst - February 2021
Very much enjoyed the course and how it was presented and the practical work assisted my learning style so I found the practice questions achievable
Max - Warehouse Team Leader - February 2021
Our teacher, Kevin, was extremely knowledgeable and provided the course material in very clear and comprehensive way. Extremely happy with the course content., very nicely structured.
Sofiya - QA Analyst - February 2021
Ed - Application Development Engineer - November 2020
From personal experience, this is a very useful course to go on as a beginner however can be overwhelming at times but nevertheless very informative and instructive. Thank you to Kevin for taking the time to explain sometimes more than twice :)
Joao - November 2020
Duration: 3 days
Price: £1,350.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum