資料庫是資訊系統的重要核心元件，也是整合企業資訊的重要工具；而如何設計符合企業作業需求的資料庫及開發支援相關業務的資料庫應用程式，以協助組織業務的進行，降低作業成本，支援管理決策，並進而創造企業競爭優勢，實為落實資料庫應用的二大課題。本課程的目標即在介紹資料庫設計與管理的方法與觀念，以及資料庫應用程式的開發技術，期望能培養並訓練一般學生能具備分析及建置資料庫系統之能力。The database is an important core component of the information system and an important tool for integrating enterprise information; and how to design a database that meets the enterprise's operational needs and develop database applications that support related businesses to assist the organization's business and reduce operating costs. Supporting management decision-making and thereby creating corporate competitive advantages are actually the two major issues in implementing database applications. The goal of this course is to introduce the methods and concepts of database design and management, as well as database application development technology, with the hope of cultivating and training ordinary students to have the ability to analyze and build database systems.
1. “SQL Server 2016設計與實務” 施威銘研究室
2. “SQL指令語法速查索引手冊(支援Oracle、SQL Server、Mysql、PostgreSQL、Access)” 鄭士昌
1. "SQL Server 2016 Design and Practice" Shi Weiming Research Laboratory
2. "SQL Command Syntax Quick Reference Index Manual (Supports Oracle, SQL Server, Mysql, PostgreSQL, Access)" Zheng Shichang
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 期中考期中考 midterm exam |
30 | |
| 期末考期末考 final exam |
40 | |
| 平時作業與學習態度平時作業與學習態度 Daily homework and study attitude |
30 |
