課程目標 |
介紹資料管理觀念。教授核心技術如資料模型、結構化資料查詢語言。資料庫架構及實作概念。介紹資訊技術於資料管理上之應用,如資料倉儲、資料分析、資料探勘及近代網路資料及訊息發展。 |
Objectives |
This course introduces following topics: data management, from data modeling and structural query language technology through database architectures and implementation concepts and information technology application in the data management such as data warehouse, on-line analytic processing and data mining, to web and data exchange technology. |
教學內容 |
1.課程簡介,資料管理,資料庫簡介 (Ch01) 2.關聯資料表及Access操作簡介 (Ch02, Ch04, Ch05) 3.結構化語言 (Ch11) 4.資料庫應用系統介紹及系統分析 (Ch03, Ch06) 5.關聯資料模型之正規化 (Ch06) 6.關聯與索引 (Ch06, Ch07) 7.查詢分析設計 (Ch08, Ch09, Ch10) 8.查詢分析設計 (Ch08, Ch09, Ch10) 9.期中考 10.操作介面設計–表單及控制 (Ch12,Ch13,Ch14,Ch15) 11.操作介面設計–表單及控制 (Ch12,Ch13,Ch14,Ch15) 12.資料分析與報表設計 (Ch16, Ch17) 13.系統整合,巨集應用介紹 (Ch20) 14.應用程式設計 (Ch21, Ch22) 15.應用程式設計 (Ch21, Ch22) 16.實務演練 (Ch23, Ch24) 17.實務演練 (Ch23, Ch24) 18.期末考 |
Syllabus |
1.Introduction of data management (Ch01) 2.Relational model and Access (Ch02,Ch04,Ch05) 3.Structured Query Language (Ch11) 4.Data base application analysis(Ch03, Ch06) 5.Relational table and normalization (Ch06) 6.Relation and index (Ch06, Ch07) 7.Query design (Ch08, Ch09, Ch10) 8.Query design (Ch08, Ch09, Ch10) 9.Mid term exam. 10.Interface and control design(Ch12,Ch13,Ch14,Ch15) 11.Interface and control design (Ch12,Ch13,Ch14,Ch15) 12.Data analysis and report (Ch16, Ch17) 13.System integration and Macro (Ch20) 14.Application programming (VBA) (Ch21, Ch22) 15.Application programming (VBA) (Ch21, Ch22) 16.Implementation practice (Ch23, Ch24) 17.Implementation practice (Ch23, Ch24) 18.Final exam. |