本課程專門為 Microsoft SQL Server 及MYSQL而設計，前半部課程內容為 SQL Server 2017整體觀念與使用相關的Data Base管理與開發的圖形介面工具，也會撰寫相關管理的指令程式，最後對SQL Server 2017 基礎的應用能具備整體觀念。後半部課程為 MYSQL+PHP，使用PHP+HTML+JAVASCRIPT撰寫出網頁架構並結合後端MYSQL資料庫，進行資料的管理，本課程也會加入實作如交易網站、問卷調查、留言板等等，最後同學們可以學到兩種資料庫的管理方法，也能學會基礎的網站架構。
This course is specially designed for Microsoft SQL Server and MYSQL. The first half of the course content is the overall concept of SQL Server 2017 and the use of graphical interface tools related to Data Base management and development. It will also write related management command programs. The final part is about SQL Server 2017. Basic applications can have an overall concept. The second half of the course is MYSQL+PHP. PHP+HTML+JAVASCRIPT is used to write the web page structure and combined with the back-end MYSQL database for data management. This course will also include implementations such as trading websites, questionnaires, message boards, etc. Finally, students can learn two database management methods, as well as basic website architecture.
本課程教導學生認識資料庫管理系統，開發資料庫系統的步驟，利用各種模式建立與設計資料庫，進而學習SQL語法，並實際操作與建立資料庫及其應用。
This course teaches students to understand database management systems, the steps to develop database systems, use various models to establish and design databases, and then learn SQL syntax, and actually operate and build databases and their applications.
SQL Server 2017/2016資料庫設計與開發實務，碁峰
Microsoft SQL Server 2016 設計實務，旗標
Microsoft SQL Server 2005 實作與維護 Ⅰ, 悅知文化
Microsoft SQL Server 2005 實作與維護 ⅠⅠ, 悅知文化
SQL Server 2017/2016 database design and development practice, Qi Feng
Microsoft SQL Server 2016 Design Practices, Flags
Microsoft SQL Server 2005 Implementation and Maintenance Ⅰ, Yuezhi Culture
Microsoft SQL Server 2005 Implementation and Maintenance ⅠⅠ, Yuezhi Culture
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 期中考期中考 midterm exam |
20 | |
| 期末考期末考 final exam |
30 | |
| 作業作業 Homework |
20 | |
| 課程參與課程參與 course participation |
10 | |
| 小考小考 Quiz |
20 |
