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
          The goal of this course is for participants to become familiar with widely used PL/SQL concepts, such as anonymous blocks, conditional execution and loops, usage of procedures and functions, cursors, collections, defining exceptions, understanding of transactions, creation of triggers, usage of packages, writing dynamic SQL, performance tuning and code debugging through SQL developer.

          Prerequisites:

          • Basic programming concepts
          • Basic database concepts
          • Basic SQL queries

           

          Agenda:

           

          Day 1

          • SQL recapitulation
          • Introduction to PL/SQL
          • Anonymous blocks
          • PL/SQL data types

           

          Day 2

          • SQL in PL/SQL
          • Loops
          • Conditional execution
          • Sequences
          • Triggers

           

          Day 3

          • Cursors
          • Exceptions
          • Procedures and functions

           

          Day 4

          • Local subprograms
          • Packages
          • Transactions

           

          Day 5

          • Dynamic SQL
          • Debugging SQL Developer
          • Performance Tuning
          • Hints

           

          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 to course