Corporate Database Application and Management (7856.3)
|Level:||Level 2 - Undergraduate Intermediate Unit|
|Faculty:||Faculty of Education, Science, Technology & Maths|
|Discipline:||Academic Program Area - Maths & Technology|
In this unit you will study key concepts about relational and hierarchical databases and their functionality in a mainframe environment, specifically DB2. You will gain knowledge and practical skills in designing, creating and using efficient and secure enterprise-level databases, including the use of SQL to manipulate databases and their content, and accessing databases in an application. You will learn about access control and how to monitor and manage databases for optimum performance. You will consider ethical issues about data quality, data management and privacy.
- Upon successful completion of this unit you will be able to analyse, describe, create, restructure, manage and tune DB2 databases in a mainframe environment and demonstrate some of your capabilities. You will be able to discuss and evaluate database design and systems and create and use SQL expressions. You will be able to discuss data quality, database administration, privacy, security and access control and overall factors affecting the performance of corporate databases.
52 hours per semester.
Mainframe Systems 1.
Equivalent of the first year of study in a UG IT degree.