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.
Great teacher! Hope to train with him again!
Tibor - Housing Association / Managed - September 2021
John's clearly extremely knowledgeable about databases and provided a detailed journey through Oracle SQL
Chantel - Statistical Support Analyst - Government - August 2021
Brilliant course. everything well explained and easy to follow. Good amount of interactivity with the workshops.
Georgia - Apps Developer / analyst - August 2021
Amazing course. Thanks John to make this course easy to understand. You have been really helpful and I have learnt a lot
Marta - Senior IT Systems Officer - August 2021
Good level of detail and was perfectly aimed at my ability level, very useful.
Iain - Technical Support Engineer - IT - July 2021
Kevin is a great tutor with a wealth if knowledge. Pace of the course was great for my level with not having really used SQL before. Was given the opportunity throughout to ask questions and at no point made to feel these were not relevant. I got everything from the course which I set out to.
Simon - Planning Manager - April 2021
Duration: 3 days
Price: £1,350.00 exc. VAT
|07 Feb 2022||Limited||Book Now|
|07 Mar 2022||Spaces||Book Now|
|28 Mar 2022||Spaces||Book Now|
|25 Apr 2022||Spaces||Book Now|
|23 May 2022||Spaces||Book Now|
|20 Jun 2022||Spaces||Book Now|
|18 Jul 2022||Spaces||Book Now|
|15 Aug 2022||Spaces||Book Now|
|12 Sep 2022||Spaces||Book Now|
|10 Oct 2022||Spaces||Book Now|
|07 Nov 2022||Spaces||Book Now|
|05 Dec 2022||Spaces||Book Now|
Live Virtual Classroom
Our Customers Include
Our Course Curriculum