APPLIED DATABASE: APPLICATION DEVELOPMENT (4 SCU)

Learning Outcomes:

On successful completion of this course, students will be able to: cite PL/SQL Code To Interface With Database; demonstrate PL/SQL commands in procedures and functions; manipulate Advance Script; cite Ability to explain Oracle APEX Environment; use Ability to use Oracle APEX Report; use Ability to use Oracle APEX Forms.

Topics:

1. Fundamentals;
2. Using SQL in PL/SQL;
3. Defining Variables and Datatypes;
4. Program Structures to Control Execution Flow;
5. Using Composite Datatypes;
6. Using Cursors and Parameters;
7. Exception Handling;
8. Using and Managing Procedures;
9. Using and Managing Functions;
10. Using and Managing Packages;
11. Getting the Best out of Packages;
12. Improving PL/SQL Performance;
13. Using and Managing Triggers;
14. Recognizing and Managing Dependencies;
15. Using the PL/SQL Compiler;
16. Fundamentals PL/SQL;
17. Getting Started with Oracle Application Express;
18. Using SQL Workshop;
19. Creating a Database Application;
20. Managing Pages in Page Designer;
21. Developing Reports;
22. Managing and Customizing Interactive Reports;
23. Managing and Customizing Interactive Grids;
24. Creating and Using Forms;
25. Creating Application Page Controls;
26. Adding Computations, Processes, and Validations;
27. Implementing navigation in your Application;
28. Using Themes and Theme Styles;
29. Implementing Security in your Application;
30. Adding Additional Pages to your Application;
31. Creating and using Dynamic Actions and Plug-ins;
32. Final Project.