Oracle Database 19c PL/SQL Workshop
Review
Level
Certificate
Abbreviation 19c PL/SQL
Course Description
This course introduces you to PL/SQL and explains the benefits of this programming language. You'll learn how to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- Successful completion of Introduction to Oracle 19c SQL is recommended.
Course Objectives
Upon completion of this course, trainees should be able to:
- Get an overview of PL/SQL
- Learn how to declare variables
- Write executable statements
- Learn how to use SQL statements in PL/SQL Programming
Certificate Description
A trainee must complete the course with attendance rate over 80% to obtain a certification in Introduction to Oracle PL/SQL.
Target Attendence
- Technical Consultant
- System Analysts
- PL/SQL Developer
- Forms Developer
- Application Developers
- Database Administrators
Introduction to PL/SQL
Declaring PL/SQL Identifiers
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Handling Exceptions
Creating Stored Procedures
Creating Stored Functions
Creating Packages
Using More Package Concepts
Utilizing Oracle Supplied Packages in Application Development
Dynamic SQL and Metadata
Design Considerations for PL/SQL Code
Managing Dependencies
Manipulating Large Objects
Creating Triggers
Applications for Triggers
-
AlTANMYA Address
Damascus, Syria Near the US Embassy, Malki
-
Contact Number
+ (963) 11 334 5537 + (963) 99 6666 037
