本課程教導學生認識資料庫管理系統,開發資料庫系統的步驟,以Microsoft SQL 2012為課堂實作環境,教導學生如何進行關聯式資料庫的規劃分析與建置、資料表正規化原理及SQL語法之DDL指令。
1.認識資料庫管理系統架構
2.資料庫系統設計
3.資料庫查詢語法This course teaches students to understand the database management system, develop the steps of developing the database system, and use Microsoft SQL 2012 as the classroom practical environment to teach students how to carry out the planning and analysis and construction of related databases, the principle of formalization of the data sheet, and the SQL syntax of SQL syntax. DDL instructions.
1. Recognize the database management system architecture
2. Database system design
3. Database query grammar
桂思強 (2012),SQL Server 2012資料庫設計實務,碁峯資訊 (*)
黃三益 (2012),資料庫的核心理論與實務,前程文化
Gui Siqiang (2012), SQL Server 2012 database design practice, Ji Peak Information (*)
Huang Sanyi (2012), the core theory and practice of the database, the future culture
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
平時成績(出、參與、小考及作業)平時成績(出、參與、小考及作業) Usually grades (out, participation, small test and homework) |
50 | 5次以上無故缺席0% |
期中考期中考 Secondary entrance examination |
25 | |
期末報告期末報告 Final report |
25 |