Course Description: This course helps you learn about
the relational database management systems, which is a core technology for
the information age. We discuss database concepts underlying the important
application domains of informed decision making and work-flow automation.
Course Objectives: The objective of this course is to
give students a basic understanding of the concepts, techniques, and
applications of the database management technology. Students will have the
hands-on experience to use an existing database management system to
develop a database application system.
Course Outline by Topical Areas:
- Introduction to DBMS
- Relational data models
- Query formulation with SQL
- Database development
- Entity relational diagrams
- Developing data models
- Normalization
- Physical database design
- Advanced query formulation
- Transaction management
- Data warehouses
- Distributed databases
- Object databases
