Brainmatics

Oracle Database 11g: Advanced PL/SQL

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

Training ini merupakan lanjutan dari PL/SQL Fundamentals. Dalam training ini akan menjelajahi fitur canggih PL/SQL untuk merancang dan menyesuaikan PL/SQL, tentu dengan konsep dan praktiknya setiap sesi materi. Peserta akan mempelajari bagaimana membuat interface dengan database dan aplikasi lain dengan cara yang paling efisien. Sebelum mengikuti training ini, peserta diharapkan sudah memahami terlebih dahulu dasar PL/SQL.

 

 

OBJECTIVES

  1. Praktik terbaik merancang PL/SQL
  2. Membuat aplikasi PL/SQL yang menggunakan koleksi
  3. Menerapkan private database dengan kontrol akses fine-grained
  4. Menulis kode untuk berinteraksi dengan eksternal C dan aplikasi java
  5. Menulis kode untuk interface dengan objek besar dan menggunakan LOB SecureFile
  6. Menulis dan menyesuaikan kode PL/SQL secara evfektif untuk memaksimalkan kinerja

 

TARGET AUDIENCE

  1. Application Developers
  2. Database Administrators
  3. PL/SQL Developer

 

SKILL REQUIREMENTS

  1. Oracle Database: Introduction to SQL
  2. Oracle Database 11g: PL/SQL Fundamentals

 

CONTENT

1. PL/SQL Programming Concepts Review

    1.1. Identify PL/SQL block structure
    1.2.Create procedures
    1.3. Create functions
    1.4.  List restrictions and guidelines on calling functions from SQL expressions
    1.5. Create packages
    1.6. Review of implicit and explicit cursors
    1.7. List exception syntax
    1.8. Identify the Oracle supplied packages

2. Designing PL/SQL Code

    2.1. Describe the predefined data types
    2.2. Create subtypes based on existing types for an application
    2.3. List the different guidelines for cursor design
    2.4. Cursor variables

3. Using Collections

    3.1.  Overview of collections
    3.2. Use Associative arrays
    3.3. Use Nested tables
    3.4. Use VARRAYs
    3.5. Compare nested tables and VARRAYs
    3.6. Write PL/SQL programs that use collections
    3.7. Use Collections effectively

4. Manipulating Large Objects

    4.1. Describe a LOB object
    4.2. Use BFILEs
    4.3. Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
    4.4. Create a temporary LOB programmatically with the DBMS_LOB package
    4.5. Introduction to SecureFile LOBs
    4.6. Use SecureFile LOBs to store documents
    4.7. Convert BasicFile LOBs to SecureFile LOB format
    4.8. Enable reduplication and compression

5. Using Advanced Interface Methods

    5.1. Calling External Procedures from PL/SQL
    5.2. Benefits of External Procedures
    5.3. C advanced interface methods
    5.4. Java advanced interface methods

6 . Performance and Tuning

    6.1. Understand and influence the compiler
    6.2. Tune PL/SQL code
    6.3. Enable intra unit inlining
    6.4. Identify and tune memory issues
    6.5. Recognize network issues

7. Improving Performance with Caching

    7.1. Describe result caching
    7.2. Use SQL query result cache
    7.3. PL/SQL function cache
    7.4. Review PL/SQL function cache considerations

8. Analyzing PL/SQL Code

    8.1. Finding Coding Information
    8.2. Using DBMS_DESCRIBE
    8.3. Using ALL_ARGUMENTS
    8.4. Using DBMS_UTILITY.FORMAT_CALL_STACK
    8.5. Collecting PL/Scope Data
    8.6. The USER/ALL/DBA_IDENTIFIERS Catalog View
    8.7. DBMS_METADATA Package

9. Profiling and Tracing PL/SQL Code

    9.1. Tracing PL/SQL Execution
    9.2. Tracing PL/SQL: Steps

10. Implementing VPD with Fine-Grained Access Control

    10.1. Understand how fine-grained access control works overall
    10.2. Describe the features of fine-grained access control
    10.3. Describe an application context
    10.4. Create an application context
    10.5. Set an application context
    10.6. List the DBMS_RLS procedures
    10.7. Implement a policy
    10.8. Query the dictionary views holding information on fine-grained access

11. Safeguarding Code Against SQL Injection Attacks

    11.1. SQL Injection Overview
    11.2. Reducing the Attack Surface
    11.3. Avoiding Dynamic SQL
    11.4. Using Bind Arguments
    11.5. Filtering Input with DBMS_ASSERT
    11.6. Designing Code Immune to SQL Injections
    11.7. Testing Code for SQL Injection Flaws

 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.