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

Oracle 11g: PL/SQL Developer OCA

  • 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.

    Course Objectives

    • 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

    Course Content / Exam(s)

    Boot Camp Schedule for Oracle 11g: PL/SQL Developer OCA
    Course Contents Exam # Regular Track
    Oracle Database: Introduction to SQL 1Z0-061 5
    Oracle Database: Program with PL/SQL NEW 1Z0-144 5
    Total 10
    Recommended Courses and Certification:
  • Students Reviews
    Nagarajan  Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle 11g database Release 2 workshop 1 . It was my very first visit to New Delhi. Before landing here I was little bit worried about the place and...

    Read MoreNagarajan India
    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
    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
    Comfort  Koenig IT Training Student

    My name is Comfort. I came at Koenig Solutions Delhi for the course of Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data. About the Training: It was a great experience with well...

    Read MoreComfort Tanzania
    Dieter Henig Koenig IT Training Student

    It took me a lot of effort to convince my superiors for the courses in India. But it was all worth it. Here everything works as a charm, without any hassle - the airport shuttle, the schedule of...

    Read MoreDieter HenigSwaziland
    View All Testimonials
  • Schedule & Prices

    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