Oracle PL-SQL Programming

SpiralTrain BV

In the course PL-SQL Programming participants learn to program in PL-SQL, Oracle's procedural programming language.

Price

from €1,999

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

PL-SQL Intro The course Oracle PL/SQL Programming starts with a discussion of the presence of PL-SQL in the various Oracle tools. The advantages of using PL-SQL are explained. PL-SQL Syntax Attention is then paid to the syntax of PL-SQL, the structure of PL-SQL programs and to statements, declarations and expressions. Control Flow Control flow in PL-SQL with if else and case statements and the various loop constructions are also covered. Cursors Then the course proceeds with explaining what cursors are and how they are used when accessing the database. Implicit cursors and cursor attributes are then treated. Transactions Attention is also paid to PL-SQL transactions. This involves executing or reversing an atomic set of SQL data manipulation statements in their entirety using commit or rollback. Error Handling Furthermore error and exception handling in PL-SQL are covered. Allowing exceptions and error parameters to occur are part of the course. Procedures and Functions Some more advanced topics such as the creation and calling of local and stored procedures are discussed as well.