DESCRIPTION
This training provides comprehensive methods for application developer who wants to build application based on Oracle database and PL/SQL programming tools. This training also include workshop that provide participants with various cases on developing application using PL/SQL and SQL*PLUS.
COURSE OUTLINE
Oracle and Client/Server Concept
• N-Tier Computation
• Oracle Database Server
• Entity Relationship Diagram (ERD)
SQL*PLUS
• Introduction to SQL*Plus
• Start SQL*Plus
• Instruction Editing
• Table Description (Data Structure)
• SQL*Plus Report
• Break On & 2 Level Break
Access Right and User’s Role (Security)
• User, Rights and Role
• Access Right (Privileges)
• Role
Database Normalization Process in Database Design
• Normalization Theory
• Structure of a Relation
• Rules of Axiom Functional Dependencies
• 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form)
NAVIGATOR Personal Oracle8
• Navigator Components
• Local Database Property
• Project
• Creating Database Connection
Oracle DATABASE TABLE
• Data Definition Language (DDL)
• Create and Delete Table
• Data Integrity
• Primary KEY (PK)
• Constraint (NOT NULL, UNIQUE, CHECK, FOREIGN KEY)
• Drop Constraint
SQL Workshop
• SELECT …WHERE
• Operator and Comparison
• LIKE, IN, IS NULL, BETWEEN
• Preparing Data
• Sub-query
• Arithmetic Function
• Group function AVG, SUM, MAX, MIN, COUNT
• Group By, Having, Join
VIEW
• Create VIEW
• Insert, Update, Delete using VIEW
SQL Programming (PL/SQL)
• PL/SQL (Procedural Language SQL)
• PL/SQL Framework
• Variable declaration
• PL/SQL with SQL instruction
• Exception Handling, Function, Parameter and Loop
Fasilitas Yang Diperoleh
- Lokasi Training di Hotel Bintang 3-5
- Ruang Pelatihan Full AC, Toilet dan Musholla
- Perlengkapan Visual LCD Proyektor, & Whiteboard
- Modul / Handout(Hard Copy & Soft Copy)
- Training Kit (Co-Card, Bolpoin, & Buku Catatan)
- 1x Makan Siang dan 2x Coffee Break (Snack)
- Penjemputan Bandara Hotel (Pulang-Pergi selama pelatihan)
- Basement Tempat Parkir Motor dan Mobil yang Aman
- Akses Internet Wireless
- Smoking Area.
- Sertifikat Keikutsertaan Training
- Merchandise menarik dari Duta Pro Training & Consulting
- Konsultasi dengan Instruktur/Narasumber setelah Pelatihan
Biaya Training
- Rp 6.800.000,- / Peserta (termasuk penginapan, minimal 2 peserta)
Lokasi Training di Yogyakarta
- Hotel Neo Malioboro
- Cavinton Hotel Yogyakarta
- Hotel Dafam Fortuna Malioboro
- Swiss-Belboutique Yogyakarta
- Hotel Dafam Fortuna Seturan
- Pesonna Hotel Tugu
- Crystal Lotu Hotel Yogyakarta
- Grand Zuri Malioboro
- Forriz Hotel Yogyakarta
- Hotel Amaris Malioboro Jogja
- Pesonna Hotel Malioboro
- Hotel Satoria Yogyakarta Adisucipto
- Prima In Hotel Malioboro
Keterangan
- Jumlah Peserta dapat memperngaruhi biaya training.
- Biaya dan Lokasi diatas hanya untuk Private Training dan Public Training, untuk In House Training penawarannya dapat menghubungi kami dilink berikut (kontak kami).
- Jumlah peserta, jadwal training dan lokasi training dapat menyesuaikan permintaan.
- Pemintaan lokasi yang diluar daftar diatas dapat menghubungi kontak Marketing Kami.
Dapatkan Penawaran Harga Training Terbaik dari Kami!.
Untuk melihat jadwal pelatihan ini kunjungi Jadwal Training Update dan jika ingin mendaftar pelatihan public atau online training ini, silakan isi form di Formulir Pendaftaran.