Advanced Database Management
Advanced Database Management
Prerequisites: METCS579 or METCS669 or consent of the instructor - Investigate advanced aspects of database management including normalization and denormalization, query optimization, distributed databases, data warehousing, and big data. There is extensive coverage and hands on work with SQL, and database instance tuning. Modern database architectures, including relational, key value, object relational, and document store models, as well as various approaches to scale out, integrate, and implement database systems through replication and cloud-based instances, are covered. You will learn about unstructured "big data" architectures and databases, gain hands-on experience with Spark and MongoDB, and complete a term project exploring an advanced database technology of your choice.
2026FALLMETCS779A1, Sep 2nd to Dec 10th 2026
| Days | Start | End | Type | Bldg | Room |
|---|---|---|---|---|---|
| R | 06:00 PM | 08:45 PM | CAS | 324 |
2027SPRGMETCS779A1, Jan 19th to Apr 29th 2027
| Days | Start | End | Type | Bldg | Room |
|---|---|---|---|---|---|
| R | 06:00 PM | 08:45 PM | HAR | 212 |
2027SPRGMETCS779O1, Jan 12th to Mar 1st 2027
| Days | Start | End | Type | Bldg | Room |
|---|---|---|---|---|---|
| ARR | 12:00 AM | 12:00 AM |
Format & Syllabus: