• Email info@koenig-solutions.com
  • WhatsApp +91 81307 98752
  • Phone +1 877 226 2244

Oracle 11g: Advance PL/SQL Developer OCP

  • Overview

    In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.

    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.

    Course Objectives

    • Create collections (nested table, array and associative arrays, PL SQL tables)
    • Use collections methods
    • Manipulate collections
    • Describe SecureFile LOB features
    • Enable SecureFile LOB deduplication, compression, and encryption
    • Describe SQL injections
    • Reduce attack surfaces

    Course Content / Exam(s)

    Boot Camp Schedule for Oracle Database 11g: Advanced PL/SQL Developer OCP
    Course Exam # Regular Track (days)
    Oracle Database: Introduction to SQL 1Z0-061 5
    Oracle Database: Program with PL/SQL NEW 1Z0-144 5
    Oracle Database 11g: Advanced PL/SQL 1Z0-146 3
    Total 13
    Recommended Courses and Certification:
  • Students Reviews
    Sebastian Drozdz Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle OCP 11g. I enjoyed the time I had in India a lot. I met people from around the world and found new friends. I appreciate the hospitality and...

    Read MoreSebastian DrozdzSwitzerland
    Mario Goncalo Batalha De Sousa Koenig IT Training Student

    During the two weeks of classes, the trainer showed deep understanding of Java. She has always explained clearly. It was a great experience for the whole team.Teacher was quite well in time...

    Read MoreMario Goncalo Batalha De SousaAngola
    Osvaldo Moises Daniel Vidro  Koenig IT Training Student

    I came to Koenig Goa for training on Oracle Database 10g : Workshop Administration I. I work as a programmer. I and five other colleagues decided to take the course "Oracle Database 10g...

    Read MoreOsvaldo Moises Daniel Vidro Angola
    Sumitra Rai Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle 10g Workshop I and II. I had good experience after coming to Koenig and gained so much ideas and knowledge about Oracle Database 10g. The training was...

    Read MoreSumitra RaiBhutan
    Nyandeng Abdalla Kuor Lou Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle Reports Developer 10g: Build Reports. I am trying to develop my career in Linux & Oracle. I attended training at Koenig Solutions in India. I found...

    Read MoreNyandeng Abdalla Kuor LouSudan
    View All Testimonials
  • Schedule & Prices
    1
    2
    3
    4
     

    5
    Price includes Official Curriculum and Exam(s).
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields