Brainmatics

Oracle Database 11g: PL/SQL Fundamentals

Popularity : author-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-ratingauthor-post-rating

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 trainin akan memperkuat konsep fundamental peserta.

OBJECTIVES

  1. Mempelajari alur kode Conditionally control (loops, control structures)
  2. Menggunakan Kursor Eksplisit
  3. Menangani runtime errors
  4. Mendiskripsikan prosedur dan fungsi yang di simpan
  5. Bekerja dengan Composite Data Types
  6. Mendeklarasikan PL/SQL Variables

 

TARGET AUDIENCE

  1. PL/SQL Developer
  2. Application Developers
  3. Database Administrators
  4. Technical Consultant
  5. Portal Developer
  6. System Analysts

 

SKILL REQUIREMENTS

  1. Oracle Databse SQL Fundamental I
  2. Oracle Database SQL Fundamental II

 

CONTENT

1. Introduction to PL/SQL

    1.1 PL/SQL Overview
    1.2 Benefits of PL/SQL Subprograms
    1.3 Overview of the Types of PL/SQL blocks
    1.4 Create a Simple Anonymous Block
    1.5 Generate Output from a PL/SQL Block

2. PL/SQL Identifiers

    2.1 List the different Types of Identifiers in a PL/SQL subprogram
    2.2 Usage of the Declarative Section to define Identifiers
    2.3 Use variables to store data
    2.4 Identify Scalar Data Types
    2.5 The %TYPE Attribute
    2.6 Bind Variables Description
    2.7 Sequences in PL/SQL Expressions

3. Write Executable Statements

    3.1 Describe Basic PL/SQL Block Syntax Guidelines
    3.2 Comment Code
    3.3 Deployment of SQL Functions in PL/SQL
    3.4 How to convert Data Types
    3.5 Nested Blocks
    3.6 Identify the Operators in PL/SQL

4. Interaction with the Oracle Server

    4.1 Invoke SELECT Statements in PL/SQL to Retrieve data
    4.2 Data Manipulation in the Server Using PL/SQL
    4.3 SQL Cursor concept
    4.4 Usage of SQL Cursor Attributes to Obtain Feedback on DML
    4.5 Save and Discard Transactions

5. Control Structures

    5.1 Conditional processing Using IF Statements
    5.2 Conditional processing Using CASE Statements
    5.3 Use simple Loop Statement
    5.4 Use While Loop Statement
    5.5 Use For Loop Statement
    5.6 Describe the Continue Statement

6. Composite Data Types

    6.1 Use PL/SQL Records
    6.2 The %ROWTYPE Attribute
    6.3 Insert and Update with PL/SQL Records
    6.4 Associative Arrays (INDEX BY Tables)
    6.5 Examine INDEX BY Table Methods
    6.6 Use INDEX BY Table of Records

7. Explicit Cursors

    7.1 Explicit Cursors Definition
    7.2 Declare the Cursor
    7.3 Open the Cursor
    7.4 Fetch data from the Cursor
    7.5 Close the Cursor
    7.6 Cursor FOR loop
    7.7 Explicit Cursor Attributes
    7.8 FOR UPDATE Clause and WHERE CURRENT Clause

8. Exception Handling

    8.1 Understand Exceptions
    8.2 Handle Exceptions with PL/SQL
    8.3 Trap Predefined Oracle Server Errors
    8.4 Trap Non-Predefined Oracle Server Errors
    8.5 Trap User-Defined Exceptions
    8.6 Propagate Exceptions
    8.7 RAISE_APPLICATION_ERROR Procedure

9. Stored Procedures and Functions

    9.1 Understand Stored Procedures and Functions
    9.2 Differentiate between anonymous blocks and subprograms
    9.3 Create a Simple Procedure
    9.4 Create a Simple Procedure with IN parameter
    9.5 Create a Simple Function
    9.6 Execute a Simple Procedure

 

 OPERATING SYSTEM

  1. Windows

 

INSTRUCTOR

 

Ananias Ardiles Sembiring. Lahir di Pematang Siantar, 3 September 1983. Menyelesaikan pendidikan S1 di ITB pada tahun 1996, telah tersertifikasi OCP, dan OCA. Berpengalaman menjadi Database Administrator selama 7 tahun, dan berpengalaman mengajar Oracle selama 5 tahun di beberapa lembaga training di Jakarta.