Oracle Database PL/SQL Programming Training
Level
IntermediateDuration
21h / 3 daysDate
Individually arrangedPrice
Individually arrangedOracle Database PL/SQL Programming Training
This training provides knowledge about programming in the PL/SQL language for Oracle databases using the latest versions of the engine. The participant will learn how to efficiently create programmable elements of the database, enabling them to automate and streamline their daily work with data.
What will you learn?
- Programming in PL/SQL
- Understanding loops, control statements, and cursors
- Creating functions, procedures, and packages
- Familiarity with database elements such as sequences, views, synonyms, data dictionary, temporary tables, constraints
Who is this training for?
Developers-
DevOps
-
Data Analysts
-
Data Scientists
-
Database Administrators
-
Architects
Training Program
-
Introduction to PL/SQL Programming
- Introduction to PL/SQL programming
- Executing anonymous blocks
- Declaring variables
- Standard and complex data types
- Attributes: %TYPE and %ROWTYPE
-
Flow Control
- Control statements
- Loops and labels
- INTO clause – using SQL, exceptions, scope of visibility
-
Cursors
- Explicit and implicit cursors
- Parameterized cursors
- WHERE CURRENT OF and FOR UPDATE clauses
-
Functions, Procedures, and Packages
- Stored procedures and functions
- Building packages and their dependencies
-
Regular Expressions
- Searching data using regular expressions
-
Working with the Repository
- System dictionary
- Managing constraints
- Temporary tables
- Views and indexes
- Synonyms and sequences
- Database links
- External tables
