8103 - 資料庫程式設計
Database Programming
教育目標 Course Target
本課程專門為 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 covers 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. Finally, you can have an overall concept of the basic applications of SQL Server 2017. The second half of the course is MYSQL+PHP. PHP+HTML+JAVASCRIPT is used to write the web page structure and combine it with the back-end MYSQL database to manage data. This course will also add implementations such as trading websites, questionnaires, message boards, etc. Finally, students can learn the management methods of the two databases, and also learn the basic website architecture.
課程概述 Course Description
本課程教導學生認識資料庫管理系統,開發資料庫系統的步驟,利用各種模式建立與設計資料庫,進而學習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.
參考書目 Reference Books
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
評分項目 Grading Method |
配分比例 Percentage |
說明 Description |
---|---|---|
期中考 midterm exam |
20 | |
期末考 final exam |
30 | |
作業 Homework |
20 | |
課程參與 course participation |
10 | |
小考 Quiz |
20 |
授課大綱 Course Plan
點擊下方連結查看詳細授課大綱
Click the link below to view the detailed course plan
相似課程 Related Courses
無相似課程 No related courses found
課程資訊 Course Information
基本資料 Basic Information
- 課程代碼 Course Code: 8103
- 學分 Credit: 0-3
-
上課時間 Course Time:Thursday/11,12,13[ST023]
-
授課教師 Teacher:蔡清欉
-
修課班級 Class:資工系3
交換生/外籍生選課登記
請點選上方按鈕加入登記清單,再等候任課教師審核。
Add this class to your wishlist by clicking the button above.