About Course
The Database Program with PL/SQL training provides you with the learning of developing stored procedures, functions, packages and database triggers. You will be able to discover the managing PL/SQL program units and dependencies and also using of some of the Oracle-supplied packages.
Course Content
Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Introduction to PL/SQL
Declare PL/SQL Variables
Write Anonymous PL/SQL Blocks
SQL Statements in a PL/SQL block
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions
Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage Dependencies
Student Ratings & Reviews
No Review Yet