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.
Similarly, the course is targeted to closely follow the official Oracle Database curriculum for certification.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12cR2, 18c and 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 course together with the Oracle SQL Advanced course is an excellent choice for delegates preparing to take the following exam:
This course together with the Oracle SQL Advanced and Oracle Database 19c Administration courses are an excellent choice for delegates preparing to take the following exam:
Attending these courses and studying the 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.
Very concise and clear explanations of all content and practical exercises discussed.
Rupinder - Postal/Distribution - December 2023
Brilliant 3 day course. Great pace, and spot on subject matter content. I finally get to be on a course that is relevant to my specific role. It has also helped me to iron out a few bad habits that I've picked up over the last few years. Thanks John. Much appreciated.
Patrick - Postal/Distribution - November 2023
Very good. Professional lecturer/tutor. Good, clear learning materials. Will recommend.
Stanislaw - Application support analyst - Outsourcing - October 2023
Very informative and the instructor John was very proficient in sharing his knowledge/experience.
Stephen - Inventory First Line Manager - Transport - September 2023
Thank you John, fantastic few days getting started with SQL, this course has helped me a lot.
Riley - IT Application Administrator - Utilities - July 2023
Enjoyable course, and very well presented. Tarn was clearly very knowledgeable, and explained the subjects well. Virtual machine was adequate for the tasks.
David - Junior DBA - Government
Duration: 3 days
Price: £1,495.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum