Course Outline
Introduction to PL/SQL language
- The 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
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
Error and exception handling
- Names, codes, messages
- Exception handling section and propagation
- Application errors
Creating stored procedures and functions
- Compilation, object status, source codes
- Parameterization
- Calling methods
Collections
- Associative tables (index by), nested tables
- Attributes, handling, initialization, memory allocation
Mass operations on collections
- Mass queries (BULK COLLECT)
- Bulk DML (FORALL)
- Exception handling in bulk operations
- Array and stream functions
Elements of SQL command execution performance
- SQL command execution process, goal setting
- Acquisition and analysis of the command execution plan
- Controlling the operation of the cost optimizer
- Reading full and via index
- Tips & Tricks
Suggested pre-training
ORA_SA1 or ORA_S1
Suggested follow-up training courses
ORA_SA2
Requirements
Knowledge of relational databases, free use of SELECT statement in terms of projection, selection, joins and subqueries.
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