精东传媒app

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 it 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 精东传媒appDesk. Students are expected to work with UniSQ-supplied virtual machines either over a fast internet connection, or on a powerful personal computer.

On completion of this course students should be able to:

1. Apply conceptual modelling techniques and data integrity-ensuring normalisation to implement a demonstrably high-quality relational schema into an RDBMS using SQL;
2. Design solutions to complex queries using relational operations and implement those as views using SQL statements;
3. Implement data-driven applications by applying advanced database techniques such as stored functions and triggers;
4. Manage database on the team basis, applying deep understanding of ethical issues such as sensitivity to risks around privileged access to user data.