本課程專門為 Microsoft SQL Server 及MYSQL而設計，前半部課程內容為 SQL Server 2017整體觀念與使用相關的Data Base管理與開發的圖形介面工具，也會撰寫相關管理的指令程式，最後對SQL Server 2017 基礎的應用能具備整體觀念。後半部課程為 MYSQL+PHP，使用PHP+HTML+JAVASCRIPT撰寫出網頁架構並結合後端MYSQL資料庫，進行資料的管理，本課程也會加入實作如交易網站、問卷調查、留言板等等，最後同學們可以學到兩種資料庫的管理方法，也能學會基礎的網站架構。
This course is designed for Microsoft SQL Server and MYSQL. The first half of the course is SQL Server 2017 overall concept and graphics interface tools developed with the use of related Data Base management and management. It also writes related management instructions, and finally has overall concepts for SQL Server 2017 basic applications. The second half of the course is MYSQL+PHP. PHP+HTML+JAVASCRIPT is used to write a web structure and combine the backend MYSQL database to manage data. This course will also include practices such as trading websites, question paper surveys, message boards, etc. Finally, students can learn two database management methods, and they can also learn a basic website structure.
本課程教導學生認識資料庫管理系統，開發資料庫系統的步驟，利用各種模式建立與設計資料庫，進而學習SQL語法，並實際操作與建立資料庫及其應用。
This course teaches students how to understand the database management system, develop the database system, use various modes to establish and design databases, and then learn SQL syntax, and actually operate and establish 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, Qifeng
Microsoft SQL Server 2016 Design Initiative, Flagmark
Microsoft SQL Server 2005 Practice and Maintenance Ⅰ, Knowledge Culture
Microsoft SQL Server 2005 Practice and Maintenance ⅠⅠ, Knowledge Culture
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 期中考期中考 Midterm exam |
20 | |
| 期末考期末考 Final exam |
30 | |
| 作業作業 Action |
20 | |
| 課程參與課程參與 Course Participation |
10 | |
| 小考小考 Small exam |
20 |
