

Development
PL/SQL Workshop
DURATION 5 Days
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.