• Oracle PL/SQL Developer Associate Curriculum


  • Career Pathway Certificate of Completion

    Catalog Year 2017-2018

    Oracle PL/SQL Developer Professionals demonstrate expertise in with database-centric Internet applications for Oracle Database 10g, 11g and 12c. The primary task of database developers is to create new applications or expand the capabilities of existing ones including creating code to: process data, design interfaces that allow users to enter or update information, query the database and find ways to automate processes.

    Since there are many installations using Microsoft’s version of database/developer instead of Oracle, Microsoft’s SQL Server equivalent topics are implemented.

    The best developers are imaginative and have the ability to break down the process between starting point and ending point.

    Students wishing to participate in this certificate must show proficiency equivalent to the skills described as course pre-requisites for listed courses in this certificate.

    Program Outcomes

    At the completion of this program, the student should be able to:

    • Successfully pass the required Oracle certification exams (currently 1Z0-051 & 1Z0-144) to become an Oracle Certified PL/SQL Developer Associate
    • Create database objects, specifically: Procedures, Functions, Triggers, and Packages, that satisfy customer requirements using Oracle Databases or Microsoft’s SQL Server
    • Modify existing database objects, as needed to satisfy customer requirements using either Oracle or SQL Server
    • Demonstrate competence in using the latest version of Oracle SQL Developer
    • Demonstrate competence in using the latest version of Microsoft’s SQL Server First Quarter (Fall) Credits
    First Quarter (Fall)
    Course Number Course Title Credits
    CIS276 SQL 4
    4
    Second Quarter (Winter)
    Course Number Course Title Credits
    CIS277 PL/SQL Developer OCA 4
    CIS277S SQL Server 4
    8
    Total Credits: 12

    The Oracle Certified PL/SQL Developer Associate is not financial aid eligible. However, the related degree program, CyberSecurity and Networking: Database Developer is aid eligible.