This course provides the theory and practice of advance database management systems. It covers the principles of database systems and emphasizes how they are used in developing data-intensive applications. Topics will include the fundamental of how data is stored and manipulated in relational database and xml database, building complex database objects and user defined data types in object oriented database, parallel and distributed database, establishing and maintaining database security and authorization.
The aims of this course are:
- To introduce students the database management administration concepts and practice on the oracle environment.
- To get an understanding of the theoretical and practical aspects of different types of databases and database management systems.
- To write Structured Query Language (SQL) commands and XQuery commands for data definition and manipulation such as create tables and indexes, select/insert/update/delete data in Relational database and XML database.
