|Faculty or Section :||Faculty of Health, Engineering and Sciences|
|School or Department :||School of Mathematics, Physics & Computing|
|Student contribution band :||Band 2|
|Grading basis :||Graded|
|Version produced :||17 May 2022|
The database is an integral and essential component of most IT systems and services, whether they be used in scientific, business, government, or other organisations. The efficient daily operation of an enterprise, its business logic and intelligence, and its long-term sustainability are all significantly dependent upon well designed and efficient databases. It is important for an IT professional to be able to design high quality databases, to be proficient in database query languages, and to know how to integrate databases in other components of technical systems.
This course focuses on the design and implementation of relational databases. Practical methodologies for data modelling and database design are examined in concert with the study of the relational database model. Subsequently the course addresses the effective retrieval of information from the database using query languages and leverages those skills to implement data-driven processes using stored functions and triggers. The course concludes with examining modern options to scale databases for massive data tasks. All the course materials, except the recommended textbooks, are available on StudyDesk. Students are expected to work with USQ-supplied virtual machines either over a fast internet connection, or on a powerful personal computer.