Oracle Database 11g : PL/SQL Fundamentals
November 22, 2018
Jadwal Pelatihan Oracle Database 11g : PL/SQL Fundamentals
| Tanggal | Tempat | Kota | | Belum ada jadwal terbaru |
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
