DB Programming - Narrative
Links to the essential reading, resources, activities, databases, advanced topic forum and assessment upload referred to in this narrative are in the theme block in myCourse.
The development of more complex web and non-web based database applications requires programming skills in accessing databases and processing record sets. This theme builds on what you have learnt in previous years to consolidate and further develop these skills. Record-set processing, dynamic SQL and JDBC, in particular, will be covered. It is the most "programming" oriented of the themes.
The unit offers a choice of programming approaches. Those on the BIT course who have limited or no practical experience of Jave can use Oracle's proprietary PL/SQL to develop applications. On the other hand, most Computing/Software Engineering students will probably choose to develop applications using JDBC. Essential reading for this theme (including those who choose a PL/SQL approach) is Sun - JDBC Guide.
Following an "Update of Employees Salaries" practice activity, the assessed activity requires the design, code and test of an account processing program.
Oracle APEX is a relatively new web-based application development tool, and so the "Record-Set Processing Model in APEX" is the advanced topic and forum for this theme.