Course Outline
Introduction to PL/SQL language
- Execution environment
- Comparison of SQL and PL/SQL
- Language characteristics, lexical units
- Structure of PL/SQL blocks
- Anonymous blocks vs. stored subroutines
- Program execution
Scalar variables
- Declarations
- Data types
- Lifetime, scope, initialization
Controlling the order of instruction execution
- Decision making
- Loops
- Labels and jumps
SQL commands in PL/SQL
- DML commands
- DDL commands and dynamic SQL
- TCL commands and Transactivity
- Simplified SELECT command
Cursor handling
- Record types
- Static cursors
- Cursor loops
- Parameterization of cursors
Error and exception handling
- Names, codes, messages
- Exception handling section and propagation
- Defining custom exceptions and their use
- Simulating the occurrence of errors
- Application errors
Suggested pre-training
ORA_S1
Suggested follow-up training
ORA_P2
Requirements
Knowledge of basic database concepts and SQL language basics in terms of queries, and DML, DDL and TCL commands. Basic programming skills in any structured language desirable.
Testimonials (8)
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Trainer expertise on SQL tuning