APPLIED DATABASE II (4 Credits)

Learning Outcomes :

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

Topics:

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