- This course is offered in 90 hours
On completing this course successfully you will be able to:
Critically evaluate the concepts and tools of the relational database management system.
Investigate and analyse the data requirements for a database system design.
Manipulate data and database objects through the use of SQL.
Design and build a database management system that satisfies relational theory and provides users with business queries, business forms, and business reports.
Basic relational database concepts; Use normalisation to design database tables; Reporting and querying data; Restricting, sorting, and grouping data; Understanding Oracle database functions; Transactional processing; Creating database objects; Server side coding: stored procedures and functions, database triggers; Error processing and troubleshooting; Main concepts of building user interface using APEX.
Practical – 50% – Practical development of a database application and supporting documentation.
Examination – 50%