คอร์สบรรยาย รวมทั้ง ปฏิบัติเวิร์คช๊อป ตามหัวข้อด้านล่าง  (Workshop)

หัวข้อย่อย 60 หัวข้อย่อย

Oracle Development Overview

PL/SQL 

Prototypes

Anonymous Block

Named Block

Nested Blocks

Variable:Type,Assignment,Operators

Control Structures

Transaction Scope

ACID

Concurrency Control

Savepoints, Commits, Rollbacks

DML Locking and Isolation Control

Error Management

Functions

Pass-by-Value & Pass-by-Reference Function

Deterministic Clause

PARALLEL_ENABLE Clause

Pipelined Table Clause

RESULT_CACHE Clause

System Reference Cursors

Procedures

Pass-by-Value & Pass-by-Reference Procedures

Collections

Varrays

Nested Tables

Associative Arrays

Object Tyoe Collections

SQL & PL/SQL Nested Tables

Record Type Collections

Packages

Package Specifications

Package Bodies

%TYPE & %ROWTYPE

Modular Programming

Overloading

Security

Triggers

DML Triggers

DDL Triggers

System Event Triggers

Objects

Object Types

Getters & Setters

Static Methods

Inheritance

Polymorphism

Dynamic SQL

NDS

Dynamic Statements without Bind Variables

Dynamic Statements with Bind Variables

DBMS_SQL Package

External Files

CSV

XML to CSV

CLOB

BLOB

Wrapping PL/SQL

Built-in Packages and Types

Summary

อัตรา 12800 บาทต่อท่าน

098 5450424

เมล    admin@thaiframeworktraining.com

note

  มีคอร์ส อื่นๆ เช่น  T-SQL , SQL , HQL , JPQL , etc