The Oracle PL/SQL Developer Series participants will learn a top-down, systematic approach to database development using entity-relationship models, normalization, and relational database design. Using this approach, participants identify and define business information requirements and create initial database designs.
ITNX 9026: Oracle PL/SQL Developer Series (180 hours) consists of the courses below.
ITSW 1007
Introduction to Oracle 11g: SQL (60 hours)
This course prepares Oracle database administrators (DBA) to create
an operational database and properly manage the various structures
in an effective and efficient. The instructor-led lesson topics are
reinforced with structured hands-on practices. Prepares students for
the Oracle Certified Associate exam #1Z0-007. Prerequisites: General
computer knowledge including relational database concepts.
ITSE
1073 Oracle 11g Developer: Program with PL/SQL
(60 hours)
In this course students learn how to write PL/SQL procedures, functions
and packages. Working in both the Procedure Builder and the SQL*Plus
environments, participants will learn how to create and manage PL/SQL
program units and database triggers. Participants will also learn
how to use some of the Oracle-supplied packages. Prepares students
for the Oracle Certified Associate exam #1Z0-147. Prerequisites: ITSE
1007 Introduction to Oracle 11g: SQL.
ITSE
2070 Program with Advanced PL/SQL (60 hours)
This course covers the 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.. Prepares students for the Oracle Certified Professional exam #1Z0-146.
Prerequisites: ITSE 1073 Oracle 11G: Program with PL/SQL.