Category: Databases and SQL
PL/SQL is a language which complements SQL with constructs related to procedural and modular programming. Its knowledge facilitates the creation of complex reports, allows to complement data in the database with business logic, and is essential for creating applications in Oracle Forms, APEX and related technologies.
Knowledge of PL/SQL is essential for programmers who wish to take advantage of all the capabilities of the Oracle database.
And if you don't know SQL well yet and want to learn the complete set: SQL, PL/SQL and the basics of administration in Oracle?
- Introduction to PL/SQL programming:
- lexical units and conventions,
- anonymous blocks and programs,
- executable block and declaration block,
- running anonymous blocks and programs.
- Defining and handling variables:
- declaring and changing the values of variables,
- use of standard data types in variables,
- %TYPE and %ROWTYPE attributes,
- working with compound types, custom compound types,
- records, tables and record tables,
- Structured programming:
- control instructions: conditions, loops.
- the INTO clause
- use of SQL functions,
- exception handling, typical built-in exceptions,
- creating your own exceptions,
- labels, name visibility ranges, nested blocks.
- implicit and explicit cursors,
- parameterized cursors,
- row locking (FOR UPDATE clause),
- WHERE CURRENT OF clause
- stored procedures,
- creating functions with their use in SQL,
- parameters in programs,
- ways of calling programs.
- structure of a package and dependencies
- running packages,
- polymorphism in packages (overloading),
- embedded packages.
- DML triggers at command and line level,
- DML triggers on views,
- DDL command triggers,
- triggers on system events.
- Dynamic SQL:
- the need to use dynamic SQL, contraindications,
- native dynamic SQL,
- DBMS_SQL package.
Audience and prerequisites
There are no prerequisites for this course.
Course participants receive completion certificates signed by ALX.
- Oracle Database SQL
- Oracle database administration
- Data Analysis
- Oracle Database Programmer
- Access: Databases and SQL for Analysts
- Databases for programmers
- MS SQL Server for programmers
- Oracle RDBMS for programmers
- MySQL for programmers
- MySQL administration
- MS Access (advanced)
- Access Programming using VBA