Module: SQL Part 2

This self-paced course on SQL by Stanford Professor Jennifer Widom is excellent. Please watch all of the lecture videos and complete the exercises.

https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/

Welcome

Welcome to Professor Rachel Chung's Database course website!

This website is designed as an online repository of learning materials for the Chatham University course CMP283 Database Management Systems

Students enrolled in the course will access course instructions and materials through this website, and the Moodle site for the course.

Course Description

This course explores key topics of database management systems (RDBMS) in the context of

This course is a study of database management systems and their applications to a wide range of information processing needs. Students design and implement database management systems while being introduced to a conceptual model of a database environment comprised of five basic components: databases, database management systems, data dictionary/directory systems, database administration, and user-system interfaces.

Student Learning Outcomes

1.       Define the basic terms and concepts related to the design and use of database systems.

2.       Demonstrate competencies in entity-relationship (ER) modeling.

3.       Demonstrate competencies in the logical modeling of relational databases.

4.       Demonstrate competencies in update operations, update anomalies, and normalization.

5.       Demonstrate competencies in basic features of the Structured Query Language (SQL).

6.       Demonstrate competencies in the implementation and use of a relational database system.

7.       Explain the most essential database administration tasks and key issues.