Subscribe to our 0800-DEVOPS Newsletter

    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






        Use the form below to apply for course





          Get in touch

          Contact us for all inquiries regarding services and general information






          agile coaching
          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.

          Check course dates.

          course-apply@3x
          APPLY TO COURSE

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

          Apply for course