Type of Credit: Partially Required
Credit(s)
Number of Students
With the progress of inforamtion technologies, database systems play a very important role in many applications. This English-taugh course introduces the concepts and principles of database systems from the perspective of their applications. The topics including relational database, NoSQL, BigQuery, and knowledge base will be covered, focused on dealing with big data. The practice of database system construction, query, manipulation, and management will help the participants integrate database systems in novel applications.
在資訊科技普及的時代，資料庫是各式應用背後不可或缺的一環。本英語授課課程將從應用的角度出發，介紹各種資料庫的概念與特性，包含關聯式資料庫、NoSQL、BigQuery、knowledge base等不同的架構，並且特別探討如何有效率地操作鉅量資料。透過實際的操作與 codelab，實機演練資料庫的建立、查詢、操作、管理，並與創新應用整合。
能力項目說明
| 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 |
Mid-term exam: 25%
Term exam：25%
Assignments: 20%
Final project：30%
Martin Kleppmann. 2017. Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. O'Reilly Media.