Applied Database II

Learning Outcomes

On successful completion of this course, student will be able to: Use Oracle Report Developer; Create Web Reporting; Create PL/SQL Triggers Code; Use Oracle Form; Create Debugging and Query Triggers; Create Multiple Form Applications

Topics

1. Oracle Reports Developer
2. Creating a Paper Report
3. Enhancing a Basic Paper Report
4. Managing Report Templates and Creating a Web Report
5. Enhancing Reports Using the Data Model: Queries and Groups
6. Enhancing Reports Using the Data Model
7. Enhancing Reports Using the Paper Layout
8. Controlling the Paper Layout
9. Web Reporting and Extending Functionality Using XML
10. Creating and Using Report Parameters
11. Embedding a Graph in a Report and Enhancing Matrix Reports
12. Coding PL/SQL Triggers
13. Use Extending Functionality, Maximizing Performance and Efficiency Guidelines
14. Forms Developer
15. Creating a Basic Form Module
16. Creating a Master-Detail Form and Working with Data Blocks
17. Working with Text Items and Creating LOVs
18. Creating Additional Input Items and No input Items
19. Creating Windows and Content Canvases
20. Introduction to Triggers and Producing Triggers
21. Debugging Triggers and Adding Functionality to Items
22. Run Time Messages and Query Triggers
23. Validation
24. Navigation, Transaction Processing and Writing Flexible Code
25. Sharing Objects Code and Using WebUtil to Interact with the Client
26. Introducing Multiple Form Applications