PL/SQL Workshop

Overview

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.

Target audience

• Data Analysts
• Business Analysts
• Data Engineers
• SW Engineers

Prerequisites

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

Content

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.