Database Systems

This course introduces the fundamental concepts of database management systems, with emphasis on relational model. Students are exposed to database design topics such as data models, ER modeling, normalization of database tables, SDLC, performance and query optimization, distributed systems, web technology and database connectivity, and data warehousing. Students learn how to create and maintain databases as well as perform queries using Structured Query Language (SQL). Advanced SQL topics such as joins, subqueries, set operators, and procedural SQL are also covered. Students use Oracle or a similar database package to complete several hands-on database projects.

Credits

3