OCA – Oracle Certified Associate: PL/SQL Developer course detail

Description

Oracle PL/SQL Developer Certified Associates demonstrate expertise in building database-centric Internet applications for Oracle Database. Oracle Certified Professionals gain greater credibility, a higher level of efficiency and improved job performance as application developers. Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language . data modeling and using SQL to create amd manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.

What will you learn
  • Conditionally control code flow (loops

  • control structures).

  • Generate triggers to solve business challenges.

  • Use PL/SQL packages to group and contain related constructs

  • Create anonymous PL/SQL blocks

  • as well as stored procedures and functions.

  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.

  • Create anonymous PL/SQL blocks

  • functions and procedures.

  • Declare PL/SQL variables.

  • Create PL/SQL blocks of application code that can be shared by multiple forms

  • reports and data management applications.

  • Debug functions and procedures using the SQL Developer Debugger.

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 12

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once

  • Use Dynamic SQL & understand design considerations when coding using PL/SQL.

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 13

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once

  • Understand and influence the PL/SQL compiler and manage dependencies.

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 14

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once

  • Manage PL/SQL subprograms

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 15

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once

  • triggers

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 16

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once

  • declaring identifiers and trapping exceptions.

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined offset: 17

    Filename: pages/course_detail.php

    Line Number: 264

    Backtrace:

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/views/site/pages/course_detail.php
    Line: 264
    Function: _error_handler

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/application/controllers/Pages.php
    Line: 270
    Function: view

    File: /home/quantumworld1/public_html/RCS-TECHNOLOGIES.COM/index.php
    Line: 315
    Function: require_once


Key Features
  • 16 Hrs e-learning videos

Lessons

  • 0 Lessons

Reviews

0
Based on 0 reviews
5 stars
4 stars
3 stars
2 stars
1 stars