APPLIED DATABASE II (4 Credits)

Learning Outcomes :

On successful completion of this course, student will be able to: Use Oracle Report Developer; Create Web Repoting; Create PL/SQL Triggers Code; Use Oracle Form.

Topics:

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 Templates;
7. Report Storage Methods;
8. Enhancing Reports Using the Data Model: Creating;
9. Enhancing Reports Using the Data Model: Creating Columns;
10. Enhancing Reports Using the Layout Model;
11. Modifying Common Layout Properties;
12. Modifying Specific Layout Properties;
13. Creating and Using Report Parameters;
14. Embedding a Chart in a Report;
15. Enhancing Matrix Reports;
16. Coding PL/SQL Triggers in Reports;
17. Building a Web Report;
18. Using the Report Builder Built-In Package;
19. Customizing Reports at Run Time;
20. Maximizing Performance Using the Reports Server;
21. Building Reports: Efficiency Guidelines;
22. Running a Forms Application;
23. Working in the Forms Environment;
24. Creating a Basic Form Module;
25. Creating a Master-Detail Form;
26. Working with Data Blocks and Frames;
27. Working with Text Items;
28. Creating LOVs and Editors;
29. Creating Additional Input Items;
30. Creating Noninput Items;
31. Creating Windows and Content Canvases;
32. Working with Other Canvas Types;
33. Producing Triggers;
34. Debugging Triggers;
35. Adding Functionality to Items;
36. Run-Time Messages and Alerts;
37. Query Triggers;
38. Validation;
39. Navigation;
40. Transaction Processing;
41. Writing Flexible Code;
42. Sharing Objects and Code;
43. Using WebUtil to Interact with the Client;
44. Introducing Multiple Form Applications.