CIS3010 Oracle Development (FOBUS)

Semester 2 (ONC)Toowoomba (EXT)Toowoomba

Units 1.0 (Database Management) Band 2

Students are required to have access to a personal computer, e-mail capabilities and Internet access to USQConnect. Internet access is also required to use the USQ Oracle server. Students who have not previously completed CIS2002 at USQ will need to study module 1 of the Study Book in some detail in order to gain an understanding of the fundamentals of data modelling and normalisation. Current details of computer requirements can be found at <http://www.usq.edu.au/business/aboutfob.htm>.

Synopsis

In this course, students build practical skills in the implementation of commercially oriented databases as well as the development of database queries and client and server-side database applications of limited scope. The course focuses on using data to solve business problems and the extraction of data that will facilitate corporate decision making. Students will gain a working knowledge of Oracle SQL and the procedural extension to SQL known as PL/SQL. The course will cover client-side as well as server-side PL/SQL, including stored procedures, functions and triggers. Finally, students extend their theoretical knowledge by studying a small number of selected topics in database theory. The course covers a significant proportion of the syllabus of the examinations conducted by Oracle Corporation for the Oracle Certified Professional Associate (OCA) and Oracle Certified Professional (OCP) exams (in the Application Developer stream as at 1 July, 2007).