Consulting 4 London - PL/SQL Course

» »

Oracle PL/SQL

COURSE DETAILS

Description

Summary

This course is designed to teach Oracle PL/SQL Application Development

Start Date

Duration

1 year or 6 Month Fast-track (FT) including 120 hours of lectures and extensive practical exercises.

Qualification

Oracle PL/SQL Developer

You'll need

The participants of this course should have completed Oracle Financials as well as the Oracle Build Internet Applications course Levels I&II

Follow with

Oracle Financials, Oracle PL/SQL

Course Details

Course Code	View	Price (ex Vat)	Purchase
OPS001	Details..	1799.00
OPS001FT	Details..	899.00

More Info.?

Call us on 020 7737 3251 or mail us here

Who will benefit
The Oracle PL/SQL course is suitable for anyone seeking a career as an Oracle Developer. Databases are of value to any modern business and are used to monitor inventories, finances, staff, customers etc. In the Oracle Database system, the PL/SQL developer is responsible for creating packages of SQL Elements that make up SQL applications driving the database.

How you will benefit
In this course you gain extensive hands-on experience desiging database schema, transforming them into prototypes using Oracles implementation of the SQL language - PL/SQL, and implementing these prototype Applications.

What is PL/SQL

Structured Query Language - SQL is a standard interactive and programming language for getting information from and updating a database. Oracle supports SQL but has added its own extensions to create PL/SQL

Course Duration
This course is a one year theoretical and practical workshop program. 40% of the time will be spent on theory classes and the rest will be on practical session. Other options are available including fast track. Call or mail us for futher details.

Course Content

Click to toggle details on/off

Creating Procedures

Describe the uses of procedures
Create client-side and server-side procedures
Create procedures with parameters
Declare subprograms
Invoke a procedure
Remove a procedure

Creating Functions

Describe the uses of functions
Create client-side and server-side functions
Invoke a function
Remove a function
Differentiate between a procedure and a function

Creating Packages

Describe packages and list their possible components
Create a data block
Create a package to group together related variables, cursors, constants, exceptions, procedures, and functions
Make a package construct either public or private
Invoke a package construct

More Package Concepts

Write packages that use the overloading feature
Avoid errors with mutually referential subprograms
Initialize variables with a one-time-only procedure
Describe the purity of a function
Describe persistent states

Oracle Supplied Packages

Describe the use and application of some Oracle Server supplied packages: DBMS_PIPE, DBMS_DDL, DBMS_JOB, DBMS_OUTPUT
Write dynamic SQL using DBMS_SQL

Creating Database Triggers

Describe database triggers and their use
Create database triggers
Describe database trigger firing rules
Remove database triggers

More Trigger Concepts

Explain the rules governing triggers
Implement triggers

Managing Subprograms and Triggers

Describe system privilege requirements
Describe object privilege requirements
Managing stored objects using the data dictionary
Debug subprograms

Managing Dependencies

Track procedural dependencies
Predict the effect of changing a database object upon stored procedures and functions
Manage procedural dependencies

Creating Procedures
Creating Functions
Creating Packages
More Package Concepts
Oracle Supplied Packages
Creating Database Triggers
More Trigger Concepts
Managing Subprograms and Triggers
Managing Dependencies

Related Courses

» Java SQL and Web Design
» Java 2 Enterprise Edition (J2EE)
» Java Pro Developer Course
» Oracle Financials
» Oracle Build Internet Applications I
» Oracle Build Internet Applications II
» Oracle PL/SQL

Return to visited pages