DBA 12c R2: Program with PL/SQL Ed 2

Uncategorized
Wishlist Share
Share Course
Page Link
Share On Social Media

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
No Review Yet

Want to receive push notifications for all major on-site activities?