Course Code: OSF
Duration: 5 days
The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. A wide range of SQL functions and data manipulation statements are introduced.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 11gR2, 12c, 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:
The Oracle SQL Fundamentals course covers the major topics required for the following exam:
The Oracle SQL Fundamentals course also covers the SQL topics that are required for the following exam:
Attending the Oracle SQL Fundamentals course together with the Oracle Database 19c Administration course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its 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.
These exams are not included as part of the course.
There are no formal pre-requisites for the Oracle SQL Fundamentals 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.
Delivered at a pace which was great for learning, very inclusive throughout and instructor was clearly experienced. participation was encouraged and always referenced topics would be used in 'real life' .
Robert - Defence - February 2022
The mix of theory and practical is very well balanced, also having a very knowledgeable and friendly trainer for any questions was very useful.
Luke - Database Administrator - Utilities - December 2021
The course was very well organised by StayAhead and all relevant information and instructions was sent through. The actual course was well planned, and paced by the instructor and I learnt a lot and am looking forward to the Advanced course on the next 2 days. The instructor knows the subject really well and made it really interesting and informative.
- November 2021
Excellent, well run course with good information and resources. Trainer was knowledgeable and engaging, I would thoroughly recommend this.
Phil - System Administrator - Recruitment - July 2021
The course was very well paced and the instructor has brilliantly explained the different functions available in Oracle SQL. Even though it was remotely, it was well worth the time.
Valentin - Earth Obsevation Specialist - Government
Very informative course taught by an excellent and experienced instructor.
Harry - Trainee Software Developer
Duration: 5 days
Price: £2,120.00 exc. VAT
|20 Jun 2022||Spaces||Book Now|
|25 Jul 2022||Spaces||Book Now|
|22 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|
|09 Jan 2023||Spaces||Book Now|
|06 Feb 2023||Spaces||Book Now|
|13 Mar 2023||Spaces||Book Now|
|17 Apr 2023||Spaces||Book Now|
|22 May 2023||Spaces||Book Now|
Live Virtual Classroom
Our Customers Include
Our Course Curriculum