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; Define Ability to explain Oracle APEX Environment; Use Ability to use Oracle APEX Report; Use Ability to use Oracle APEX Forms.

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 Queries and Groups
9. Enhancing Reports Using the Data Model: Creating Columns
10. Enhancing Reports Using the Layout Model
11. Modifying Common Layout Properties
12. Creating and Using Report Parameters
13. Embedding a Chart in a Report
14. Enhancing Matrix Reports
15. Coding PL/SQL Triggers in Reports
16. Building a Web Report
17. Using the Report Builder Built-In Package
18. Customizing Reports at Run Time
19. Maximizing Performance Using the Reports Server
20. Building Reports: Efficiency Guidelines
21. Modifying Specific Layout Properties
22. Getting Started with Oracle Application Express
23. Using SQL Workshop
24. Creating a Database Application
25. Managing Pages in Page Designer
26. Developing Reports
27. Managing and Customizing Interactive Reports
28. Managing and Customizing Interactive Grids
29. Creating and Using Forms
30. Creating Application Page Controls
31. Adding Computations, Processes, and Validations
32. Implementing navigation in your Application
33. Using Themes and Theme Styles
34. Implementing Security in your Application
35. Adding Additional Pages to your Application
36. Creating and using Dynamic Actions and Plug-ins
37. Final Project