Oracle PL/SQL Training

PL/SQL stands for Procedural Language/SQL. PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All PL/SQL programs are made up of blocks, which can be nested within each other.

Oracle PL/SQL - 5 days

Learn to:

Describe relational and object relational database concepts
Retrieve, insert, update, and delete data
Use the Single row and Group functions
Retrieve data using additional advanced techniques like using ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
Use the iSQL*Plus environment
Write scripts to generate script files
Generate reports using iSQL*Plus
Create and maintain database objects
Control transactions
Control data/user access
Use the Oracle9i Single row functions
Use GROUPING SETS and the WITH clause
Use the Oracle9i extensions to DML and DDL statements
Apply techniques in real life simulation

Please click here for an outline.

Please contact us for more information. One-to-one or group bookings can also be arranged on dates to suit you and customised to your specific requirements. Please give us a call on 01483 688488.

Back to Courses