Corporate Database Application and Management PG (7862.3)
|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.
1. Understanding of relational databases and their functionality, architecture and anatomy of DB2 for z/OS, activities of database administration and define, manipulate and control DB2 for z/OS objects.
2. Understanding of how to interface DB2 to programs to access DB2 for z/OS.
3. Understanding XML, the importance of XML and XML Tables in DB2 for z/OS.
4. Develop SQL to define, manipulate, and control objects on DB2 for z/OS.
5. Develop DB2 Stored Procedures / Triggers to access and manipulate data on DB2 for z/OS.
6. Develop SQL/XML to define, manipulate and convert between relational and XML.
7. Use Commands, Utilities and Tools to administer databases on DB2 for z/OS.
52 hours per semester.
Mainframe Systems 1 G.