Course Oracle Programming in PL/SQL
Participants in the Oracle course will learn to use PL/SQL - the procedural extension of the SQL language for Oracle. The training takes place in the Oracle Database 10g Express Edition environment.
Minimum input knowledge
Knowledge of the Oracle environment, principles of relational databases and the SQL language in the scope of the course Oracle: Introduction to SQL is expected.
Course dates Oracle Programming in PL/SQL
Daily courses (3 days): 09:00 - 15:00
Course price: 490.00 / 602.70 EUR
without VAT / incl. VAT
Training syllabus Oracle Programming in PL/SQL
Introduction to PL/SQL
- PL/SQL blocks: basic block structure, anonymous and named blocks, nested blocks, data types, using variables, expressions
Controlling Program Execution in PL/SQL
- Conditions (IF-THEN-ELSE, CASE), loops (FOR, WHILE), sequential navigation (GOTO)
Using SQL in PL/SQL
- Retrieving data, transaction control, working with cursors, DML and DDL in PL/SQL, built-in SQL functions
Records
- Implicit and explicit definition of record type, use of records
Collections
- Working with collections, Oracle Collection API
Exception Handling
- Exception declaration, raising an exception, processing exceptions
Creating Program Units
- Stored procedures, functions, packages, triggers
Output knowledge
Course participants will be able to work with an Oracle database.
Recommended courses after completing Oracle Programming in PL/SQL
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Oracle Programming in PL/SQL
Average rating