

Development
PL/SQL Workshop
DURATION 5 Days
This course gives an introduction in PL/SQL, an overview of database objects and types and details about programming tools.
Introduction
- A short introduction into SQL and PL/SQL
Database objects:
- A short overview of database objects (table, view, type, sequence, trigger, package, function, procedure, synonym)
- An in-depth overview of objects (type)
- Naming convention
Data types:
- Varchar2, number, date…
- Records, Collections…
- BLOB, XML, CLOB, LONG, RAW…
- Naming conventions
Flow control (if, case)
Interactive control (loop, for-loop, while)
Cursors and cursor for-loops
Transactions:
- DML into PL/SQL
- Commit, rollback
- Autonomous transactions
Exceptions & exception management
- Custom exceptions
- Sqlcode, sqlerrm, dbms_utility.format_error…
- Naming conventions
Conditional compilation
Triggers
Procedures & functions
Packages:
- Using variables
- Declaration
- Naming conventions
Dynamic SQL:
- DDL in PL/SQL
- DML in dynamic SQL
- SQL injection
Programming tools:
- SQLDeveloper
- PLSQL Developer
- TOAD
For all inquiries regarding education, please contact us at learn@croz.net.