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 (7)
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
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
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
Method of translating the material and examples shown.
Marek Jakimowicz
Course - Tuning SQL i PL/SQL dla programistów
Machine Translated
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Trainer expertise on SQL tuning
Bogdan - DB Global Technology
Course - Oracle 11g - Application Tuning - Workshop
it was very well organized