The Oracle 12C PL/SQL Fundamentals is an intensive three day course that is designed to give the student maximum exposure to Oracle SQL and PL/SQL. The student learns by doing, and this class has dozens of in-class exercises and the student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques.
The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, sub queries and creating Oracle views. The PL/SQL section begins with simple concepts and the student gradually masters PL/SQL through increasingly challenging classroom exercises.Course Objectives
By the end of this course the student will be able to formulate advanced SQL queries including correlated sub queries and outer joins. The student will also become familiar with the internals of Oracle9i SQL and will be able to use the EXPLAIN PLAN utility to tune SQL statements.Who Should Attend This Program
This course is designed for practicing Oracle professionals who have basic experience with SQL and the use of a relational database. Prior experience with Oracle is not required, but experience using SQL with a relational database is highly desirable.
This training course can be tailored to any level. In general, attendees ranging from new to experienced developers seeking to learn Oracle PL/SQL can take this course. Familiarity with Oracle database is needed.
Mode of Delivery
Every participant will be provided with course notes and are required to bring in their own laptops for hands-on exercise and practice sessions.
If you need further info on this program, all you need to do is to fill up the form in this page and/or call/email us. We will brief you on the details of this program and guide you all the way!
You can also download the Program Brochure for more detailed explanation on the program.
For more information, please contact:
or Fill up this form to make an quick enquiry. Our personnel will be in touch with you shortly.