Date |
Subject |
In-class Activities & Hours |
After Class Activities & Hours |
9/18 |
Introduction to this course
The overview of this course and the fundamental background of database systems
|
Lecture: 3 hours
|
Post-lecture review: 3 hours |
9/25 |
Relational database management systems (RDBMS)
The concepts of the widely-used RDBMSs and their applications.
|
Lecture: 3 hours |
Post-lecture review: 3 hours |
10/2 |
Off (Moon Festival)
|
|
|
10/9 |
Off (National Day Vacation)
|
|
|
10/16
|
SQL Basics
Introduction to the query language for many RDBMSs, including the basic syntax and practices of SQL.
|
Lecture: 3 hours
|
Post-lecture review: 3 hours
Assignment: 3 hours
|
10/23 |
More SQL
Introduction to more complex query constructions including table joining and nested queries
|
Lecture: 3 hours
|
Post-lecture review: 3 hours
Assignment: 6 hours
|
10/30 |
Standardization and normalization
Describing one of the most important concepts in database systems
|
Lecture: 3 hours |
Post-lecture review: 3 hours |
11/6 |
Management and administration of RDBMS
The practices of database management with case studies
|
Lecture: 3 hours |
Pre-exam review: 12 hours
|
11/13 |
Mid-term exam
|
In-class exam: 3 hours |
|
11/20 |
Integration and applications of RDBMS
Introduction to the applications of RDBMS in real world systems, showing how to choose a good RDBMS according to the requirements
Final project announcement
|
Lecture: 3 hours
|
Post-lecture review: 3 hours
Final project: 6 to N hours
|
11/27 |
Database systems and big data
Summarizing the challenging issues of database systems in the era of big data and giving an overview of the emerging non-relational database systems
|
Lecture: 3 hours
|
Final project: 6 to N hours |
12/4 |
NoSQL basics
Introduction to the most popular type of non-relational database systems
|
Lecture and codelabe: 3 hours
|
Post-lecture review: 3 hours
Assignment: 6 hours
Final project: 6 to N hours
|
12/11 |
NoSQL programming
More practices in manipluating the data in the key-value fashion provided in NoSQL systems
Activity: Lecture and codelab
|
Lecture and codelabe: 3 hours
|
Post-lecture review: 3 hours
Assignment: 12 hours
Final project: 6 to N hours
|
12/18 |
Advanced topics in database systems
Introduction to more recent database systems such as BigQuery, which is a non-relational database system that supports a limited dialect of SQL
Activity: Lecture and codelab
|
Lecture and codelabe: 3 hours
|
Post-lecture review: 3 hours
Final project: 6 to N hours
|
12/25 |
Final project presentation
Hours: 3
|
Presentation: 3 hours |
|
1/1 |
Off (New Year's Day)
|
|
Pre-exam review: 12 hours |
1/8 |
Term exam
Hours: 3
|
In-class exam: 3 hours |
|