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.

 

COURSE PREREQUISITES

  • 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
OVERVIEW

This course provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.

  Course   Schedule
  • Saturday9:30 AM - 2:30 PM
Poll