ORACLE PL/SQL

ORACLE PL/SQL
Harga Kursus: Rp. 400.000,00 (Paket u Mhs)
Kategori : Oracle Developer
Durasi : Lama Belajar 15 jam


SILABUS
1. Declaring Variabies
2. Writing Execute Statement
3. Writing Control Structure
4. Interacting with Oracle server
5. Working with composite data types
6. Writing Explicit Cursor
7. Advanced Explisit Cursor Concept

-----------------------------------------------------------
ORACLE PL/SQL ADVANCE
Harga Kursus: Rp. 1.000.000,00 (Paket u Mhs)
Kategori : Oracle Developer
Durasi : Lama Belajar 15 jam


SILABUS
1. Writing Explicit Cursor
2. Advanced Explisit Cursor Concept
3. Handling Exceptions
4. Creating procedures
5. Creating functions
6. Managing subprogram
7. Creating packages
8. Creating database triggers

-----------------------------------------------------------
ORACLE DEVELOPER FORM
Harga Kursus: Rp. 1.000.000,00 (Paket u Mhs)
Kategori : Oracle Developer
Durasi : Lama Belajar 15 jam

SILABUS
1. Introduction to developer form
2. Running a form builder application
3. Working in the form builder environment
4. Creating a Basic Form Module
5. Working with Data Blocks and Frames
6. Working with Text Item
7. Creating LOVs and Editors
8. Creating Additionl Input Items
9. Creating Noninput Items
10. Creating Windows and Contentc Canvas
11. Working With Other Canvas
12. Introduction to Triggers
13. Producing Trigers
14. Debugging Triggers
15. Adding Functionality to Items
16. Runform Message and Alerts
17. Query Triggers
18. Validation
19. Navigation
20. Transaction Processing
21. Writing Flexible Code
22. Sharing Object and Code
23. Introducing Multiple FormApplicatons

-----------------------------------------------------------
ORACLE DEVELOPER REPORT
Harga Kursus: Rp. 1.000.000,00 (Paket u Mhs)
Kategori : Oracle Developer
Durasi : Lama Belajar 15 jam

SILABUS
1. Introduction to Oracle Reports
2. Designing and Running Reports
3. Report Builder Concepts
4. Creating Reports Using the Report Wizard
5. Enhancing Reports in the live Previewer
6. Managing report Template
7. Report Storage Methods
8. Cretaing Queries and Groups
9. Creating Colums
10. Enhancing Reports Using the Layout Model
11. Modifying Common Layout Properties
12. Modifying Spesific Layout Properties
13. Creating and Using Report Parameters
14. Enhacing Matrix Reports
15. Coding PL/SQL Triggers in Reports
16. Using the Report Builder Built-In Package