資料庫管理
Database Management
| 節 | 週二 |
|---|---|
7 15:30–16:20 | 資料庫管理 SC158 3 節連堂 |
8 16:30–17:20 | |
9 17:30–18:20 |
* 根據陽明交大上課時間表所列
The main objective of this class is to study the fundamental concepts necessary for designing, using, and implementing database systems. The course stresses the fundamentals of database modeling and design, the languages and facilities provided by database management systems, and system implementation techniques. Emerging database technologies and applications will also be introduced.
Programming skill is mandatory. Python is preferred.
(1) 本課程涵蓋使用程式語言連結資料庫操作,因此Python執行環境與MySQL資料庫在課前需安裝完畢,且學生對Python語法需有基本的認識。 (2) Project 採分組進行,全班分成數組(視修課人數而定),以網頁結合資料庫,建置一個應用系統,題目及使用工具不限。 (3) 執行 project時,學生要自學網頁開發及資料庫整合實作,課程負擔較重,請修課學生斟酌慎重考量。
Attendance(10%), Homework (20%), Project (30%) Mid-term exam (20%), Final-term exam (20%)
| 週次 | 主題 |
|---|---|
| 第 1 週 | Database Systems |
| 第 2 週 | Data Models |
| 第 3 週 | The Relational Database Model (I) |
| 第 4 週 | The Relational Database Model (II) |
| 第 5 週 | Entity Relationship (ER) Modeling |
| 第 6 週 | Advanced Data Modeling |
| 第 7 週 | Normalization of Database Tables |
| 第 8 週 | Midterm Exam |
| 第 9 週 | Introduction to Structured Query Language (SQL) |
| 第 10 週 | Database Connectivity and Web Technologies |
| 第 11 週 | Advanced SQL |
| 第 12 週 | Database Design |
| 第 13 週 | BigData and NoSQL |
| 第 14 週 | Database Administration and Security |
| 第 15 週 | Project Presentation |
| 第 16 週 | Final Exam |
1. Database Systems: Design, Implementation, & Management (14e), Coronel and Morris, Engage, 2023 2. MySQL Crash Course, Rick Silva, No Starch Press, 2023
- 地點
- SC314
- 時間
- by appointment
- 聯絡方式
- jacky.jw.lin@nycu.edu.tw