Oracle Database 11g : PL/SQL Fundamentals

DESCRIPTION

Training ini mengenalkan PL/SQL kepada para peserta dan menjelaskan manfaat dari bahasa pemrograman ini. Para peserta belajar untuk membuat blok kode aplikasi PL/SQL yang dapat dibagikan oleh multiple forms, reports, dan data management applications. Peserta juga mempelajari bagaimana cara untuk membuat anonymous PL/SQL blocks, stored procedures, dan functions. Peserta belajar mendeklarasikan identifiers dan trapping exceptions. Dengan praktik dan modul yang disertakan dalam training akan memperkuat konsep fundamental peserta.

OBJECTIVE

• Mempelajari Alur Kode Conditionally Control (Loops, Control Structures)
• Menggunakan Kursor Eksplisit
• Menangani Runtime Errors
• Mendiskripsikan Prosedur dan Fungsi yang disimpan
• Bekerja dengan Composite Data Types
• Mendeklarasikan PL/SQL Variables

COURSE OUTLINE

1. Introduction to PL/SQL

• PL/SQL Overview
• Benefits of PL/SQL Subprograms
• Overview of the Types of PL/SQL Blocks
• Create a Simple Anonymous Block
• Generate Output from a PL/SQL Block

2. PL/SQL Identifiers

• List the Different Types of Identifiers in a PL/SQL Subprogram
• Usage of the Declarative Section to Define Identifiers
• Use Variables to Store Data
• Identify Scalar Data Types
• The % Type Attribute
• Bind Variables Description
• Sequences in PL/SQL Expressions

3. Write Executable Statements

• Describe Basic PL/SQL Block Syntax Guidelines
• Comment Code
• Deployment of SQL Functions in PL/SQL
• How to Convert Data Types
• Nested Blocks
• Identify the Operators in PL/SQL

4. Interaction with the Oracle Server

• Invoke SELECT Statements in PL/SQL to Retrieve Data
• Data Manipulation in the Server Using PL/SQL
• SQL Cursor Concept
• Usage of SQL Cursor Attributes to Obtain Feedback on DML
• Save and Discard Transactions

5. Control Structures

• Conditional Processing Using IF Statements
• Conditional Processing Using CASE Statements
• Use Simple Loop Statement
• Use While Loop Statement
• Use For Loop Statement
• Describe the Continue Statement

6. Composite Data Types

• Use PL/SQL Records
• The %ROWTYPE Attribute
• Insert and Update with PL/SQL Records
• Associative Arrays (INDEX BY Tables)
• Examine INDEX BY Table Methods
• Use INDEX BY Table of Records

7. Explicit Cursors

• Explicit Cursors Definition
• Declare the Cursor
• Open the Cursor
• Fetch Data from the Cursor
• Close the Cursor
• Cursor FOR Loop
• Explicit Cursor Attributes
• FOR UPDATE Clause and WHERE CURRENT Clause

8. Exception Handling

• Understand Exceptions
• Handle Exceptions with PL/SQL
• Trap Predefined Oracle Server Errors
• Trap Non-Predefined Oracle Server Errors
• Trap User-Defined Exceptions
• Propagate Exceptions
• RAISE_APPLICATION_ERROR Procedure

9. Stored Procedures and Functions

• Understand Stored Procedures and Functions
• Differentiate Between Anonymous Blocks and Subprograms
• Create a Simple Procedure
• Create a Simple Procedure with IN Parameter
• Create a Simple Function
• Execute a Simple Procedure

METODE PELATIHAN

Pre Test

Presentasi

Diskusi

Studi Kasus

Evaluasi

Post Test

FASILITAS

Training Kit

Handout

Certificate

Lunch + 2x Coffee Break

Souvenir

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Oracle Database 11g : PL/SQL Fundamentals
Link
*Jumlah Peserta	Estimasi Jumlah Peserta yang di ajukan
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan	Jabatan/Divisi/Departement
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif	eg: gmail, yahoo, hotmail
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi
	Submit

SIMILAR ARTICLES

September 16, 2025

Basic Power BI

September 16, 2025

Pembinaan dan Sertifikasi Petugas P3K (Pertolongan Pertama Pada Kecelakaan)

September 16, 2025

Team Work & Leadership