training Oracle Database 11g: Advanced PL/SQL,pelatihan Oracle Database 11g: Advanced PL/SQL,training Oracle Database 11g: Advanced PL/SQL Batam,training Oracle Database 11g: Advanced PL/SQL Bandung,training Oracle Database 11g: Advanced PL/SQL Jakarta,training Oracle Database 11g: Advanced PL/SQL Jogja,training Oracle Database 11g: Advanced PL/SQL Malang,training Oracle Database 11g: Advanced PL/SQL Surabaya,training Oracle Database 11g: Advanced PL/SQL Bali,training Oracle Database 11g: Advanced PL/SQL Lombok,training Oracle Database 11g: Advanced PL/SQL Pasti Jalan,pelatihan Oracle Database 11g: Advanced PL/SQL Pasti Running,pelatihan Oracle Database 11g: Advanced PL/SQL Batam,pelatihan Oracle Database 11g: Advanced PL/SQL Bandung,pelatihan Oracle Database 11g: Advanced PL/SQL Jakarta,pelatihan Oracle Database 11g: Advanced PL/SQL Jogja,pelatihan Oracle Database 11g: Advanced PL/SQL Malang,pelatihan Oracle Database 11g: Advanced PL/SQL Surabaya,pelatihan Oracle Database 11g: Advanced PL/SQL Bali,pelatihan Oracle Database 11g: Advanced PL/SQL Lombok

Pelatihan pengenalan Advanced PL/SQL, administrasi basis data, penerapan Advanced PL/SQL

Training Oracle Database 11g: Advanced PL/SQL

 

 

Deskripsi Training Oracle Database 11g: Advanced PL/SQL

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

  1. Menulis kode untuk interface dengan objek besar dan menggunakan LOB

SecureFile

  1. Menulis  dan  menyesuaikan  kode  PL/SQL  secara  evfektif  untuk

memaksimalkan kinerja

 

 

AUDIENCE

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

 

 

PREREQUISITES Training Oracle Database 11g: Advanced PL/SQL

  1. Menguasai Materi Oracle Database: Introduction to SQL
  2. Menguasai Materi 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. 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

 

  1. Profiling and Tracing PL/SQL Code

9.1. Tracing PL/SQL Execution

9.2. Tracing PL/SQL: Steps

 

  1. 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

 

  1. 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

 

 

Metode

Presentasi, Diskusi , Brainstorming, Case Study,Evaluasi

 

Lokasi, Biaya, dan Waktu Training Oracle Database 11g: Advanced PL/SQL :

Yogyakarta, Hotel Dafam Seturan

Jakarta, Hotel Amaris La Codefin Kemang

Bandung, Hotel Grand Serela Setiabudhi / Merdeka

Bali, Hotel Ibis Kuta

Lombok, Hotel Jayakarta

Catatan : Waktu pelatihan Dua hari + 1* (lokasi tertentu) dengan Biaya tersedia untuk Perorangan, Group, dan Inhouse Training, belum termasuk akomodasi / penginapan.

 

Investasi training :

Investasi pelatihan selama dua hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.

Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.

 

 

Fasilitas training :

Free Penjemputan dari bandara ke hotel*.

Modul / Handout.

Flashdisk*.

Certificate of attendance.

FREE Bag or bagpacker.

Training Kit (Photo Documentation, Blocknote, ATK, etc).

2x Coffe Break & 1 Lunch.

Souvenir .

Leave a Comment