Oracle 11g: PL/SQL Developer OCA Training & Certification Courses
 800 Ratings

Enquire Now


 
Loading...  

Processing data, please wait...

Live Chat
Oracle #1 Training Partner
Oracle #1 Training Partner
Get Trained by Industry Expert
Get Trained by Industry Expert
Guarantee to Run the Classes
Guarantee to Run the Classes
Hello Koenig

Overview

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages. To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals. To know more, please write to us at info@koenig-solutions.com. .

Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Oracle 11g: PL/SQL Developer OCA consist of following courses

Course # Course Name Exam # Duration (days)
12C_OEM Oracle Database: Introduction to SQL (Download Content)1Z0-0615
12C Database Oracle Database: Program with PL/SQL (Download Content)1Z0-1445
Total 10
Delivery Mode Location Course Duration Fees Schedule
Instructor-Led Online Training (1-on-1) Client's Home/Office10 Days $ 6,400 E As per mutual convenience (4-Hours Evenings & Weekends Possible
Classroom Training * Dubai 10 Days $ 7,100 E
21 Jul -1 Aug 2019,
15 Sep -26 Sep 2019
Delhi, Bangalore, Dehradun (Rishikesh), Goa, Shimla, Chennai 10 Days $ 3,906 E On Request
Fly-Me-a-Trainer Client's Location10 Days On Request As per mutual convenience
* E = Exam included

Oracle 11g: PL/SQL Developer OCA Benefits

Upon Completion of this Course, you will accomplish following:-

  • Create reports of sorted and restricted data.
  • Employ SQL functions to generate and retrieve customized data.
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
  • Create reports of aggregated data.
  • Design PL/SQL program units that execute efficiently.
  • Use PL/SQL programming constructs and conditional control statements.
  • Handle run-time errors. Describe stored procedures and functions.
  • Write dynamic SQL for more coding flexibility

Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle 11g: PL/SQL Developer OCA Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Recommended Courses and Certification:


Need more info ? Email info@koenig-solutions.com  or   Enquire now!

Student Feedback

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training?

Student Name Country Month Feedback
Salim Hamood Salim Alsaidi Oman Jun-2019 A1 Mr Ravindra is very qualified, smart and excellent trainer.
Edward Kambwiri Malawi Apr-2019 A1 Knowledgeable and Experienced. On top of the material and brought the course to life with practical business application of the course material.
Manuel Ebo Angola Jan-2019 Its main objective is to leave the student satisfied, from the first contact until the end of the course.
Delhi
Bangalore (Bengaluru)
Goa
Shimla (Himalayas)
Chennai
Dehradun
Dubai
USA Singapore
All rights reserved. ©1997 - 2019, Koenig Solutions Pvt. Ltd.
PMP® is a registered trademark of the Project Management Institute.
Koenig Solutions Pvt. Ltd. is rated 4.4 stars by www.facebook.com/KoenigSolutions based on 107 reviews

Please Input Captcha Below

Submit