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.
APPLY TO COURSE
Apply to course For all inquiries regarding education, please contact us at learn@croz.net or apply online.