Introduction:
We are pleased to present our technical offer for the Database 19c (PL/SQL) Basic training. This training is designed to equip participants with essential skills and knowledge in using Oracle Database 19c and its PL/SQL programming language.
Objectives:
- Gain a comprehensive understanding of Oracle Database 19c architecture and features.
- Learn the fundamentals of PL/SQL programming language and its syntax.
- Develop skills in writing PL/SQL blocks, conditional statements, and loops.
- Master the concepts of exception handling and error trapping in PL/SQL.
- Acquire knowledge in working with cursors for data retrieval and manipulation.
- Create and execute stored procedures using PL/SQL.
- Understand parameter passing and returning values from stored procedures.
Course Outline:
Introduction to Oracle Database 19c
- Overview of Oracle Database architecture and features
- Installation and configuration of Oracle Database 19c
- Introduction to PL/SQL programming language
PL/SQL Basics
- Understanding PL/SQL syntax, data types, and variables
- Writing and executing PL/SQL blocks and anonymous procedures
- Using conditional statements (IF-THEN-ELSE) and loops (FOR, WHILE) in PL/SQL
- Exception handling and error trapping in PL/SQL
Working with Cursors and Stored Procedures
- Working with explicit and implicit cursors in PL/SQL
- Retrieving and manipulating data using cursors
- Creating and executing stored procedures in PL/SQL
- Parameter passing and returning values from stored procedures.