Information Technology - IT Courses

You are here:

Home Information Technology - IT CoursesOracle PL/SQL Developer Certified Associate

Oracle PL/SQL Developer Certified Associate

Certification Training

This globally recognised credential validates your expertise in using the powerful PL/SQL programming language in Oracle databases.

SEEK Learning will provide you with all the training you need to pass the Oracle exams (1Z0-144 and 1Z0-047 or 1Z0-051) and get certified - guaranteed.

Who is this course for?

Database developers
Business analysts
Reporting analysts

View all Oracle courses

Quick Course Guide

Qualification: Oracle PL/SQL Developer Certified Associate
Student support: Weekday email support by expert mentors

Study time: 12 weeks
Pre-requisites: None

Enrolment dates: Enrol anytime - start now!
Assessment: Oracle exams 1Z0-144 and 1Z0-047 or 1Z0-051 (by external provider)

Delivered by: SkillSoft
Resources required: Internet, email

Demonstrate Your Skills in PL/SQL

Oracle certifications are industry-recognised, sought-after credentials that can help you succeed in your IT career.

PL/SQL (Procedural Language/Structured Query Language) is a programming language embedded in the Oracle database, along with SQL and Java. PL/SQL is required to create procedures, database triggers, packages and functions.

The Oracle PL/SQL Developer Certified Associate certification validates your expertise in building database-centric Internet applications for both Oracle 9i and Oracle Database 10g.

This globally recognised credential can help you gain greater credibility and improve your efficiency and job performance.

Find out if Oracle PL/SQL Developer Certified Associate is right for you - contact a SEEK Learning consultant for free expert advice.

Skills You'll Gain

Among other things, you'll learn how to:

identify the different types of PL/SQL blocks
write executable statements
create PL/SQL executable blocks using DML and transaction control statements
create user-defined PL/SQL records
handle and define exceptions
use Dynamic SQL
write and call local subprograms
perform autonomous transactions
manage dependencies

What's Included

Weekday email support by expert mentors
Access to online library Books 24x7
Hands-on interactive exercises
Self-paced study format
Certification guarantee - get certified or your money back

Oracle PL/SQL Developer Certified Associate Course Details

Course Outline

1Z0-044

Oracle Database 11g: Getting Started With PL/SQL
Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors

Oracle Database 11g: Subprograms, Packages, and Exception Handling
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
Oracle Database 11g: PL/SQL Code and Dependency Management

And either:

1Z0-047

Oracle Database 11g: Using SQL to Query Your Database
Oracle Database 11g: Conversion Functions, Group Functions and Joins
Oracle Database 11g: Subqueries, Set Operators and Data Manipulation
Oracle Database 11g: Using DDL, Views, Sequences, Indexes and Synonyms

Oracle Database 11g: Controlling User Access and Managing Schema Objects
Oracle Database 11g: Data Dictionary Views and Large Data Sets
Oracle Database 11g: Managing Data in Different Time Zones
Oracle Database 11g: Using Subqueries and Regular Expressions

Or:

1Z0-051

Oracle Database 11g: Using SQL to query your database
Oracle Database 11g: Conversion functions, group functions, and joins

Oracle Database 11g: Subqueries, set operators and data manipulation
Oracle Database 11g: Using DDL, views, sequences, indexes and synonyms

SEEK Learning's Oracle certification training will fully prepare you for the Oracle PL/SQL Developer Certified Associate exams.

Please note that the Oracle exams are held by an external provider. For your convenience, SEEK Learning will help you find your nearest exam centre. Contact a SEEK Learning consultant for further information or assistance.

Training Exclusively Through SEEK Learning

SEEK Learning provides training from SkillSoft, the premier global provider of IT e-learning courseware.

SkillSoft does not generally offer courses directly to individuals, but our partnership enables us to exclusively offer Oracle training directly to you.

SkillSoft courses are developed according to the certification specifications of leading vendors.