Get in touch

Contact us for all inquiries regarding services and general information






Get in touch

Contact us for all inquiries regarding services and general information






Get in touch

Contact us for all inquiries regarding services and general information







Get in touch

Contact us for all inquiries regarding services and general information






image-course image-course
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.

course-apply@3x
APPLY TO COURSE

For all inquiries regarding education, please contact us at learn@croz.net or apply online.

Apply for course