The main objective of this undergraduate course is to provide an in-depth understanding of Database Management Systems. In particular, students will be exposed to cover advanced topics in modern database systems, including specialization, generalization, aggregation. Also a various other subject will be discussed like normalization, distributed databases, data warehousing and data mining, and also look at database system implementation, Client/server database, Parallel database.
Beside to the theoretical part, the students in the practical part will learn how to design, create, and manipulate databases using Microsoft SQL Server 2014. Topics will include table design, forms, queries, and reports. Students will also learn the fundamentals of defining table relationships and explore the features of a relational database management system.