資料庫是資訊系統的重要核心元件,也是整合企業資訊的重要工具;而如何設計符合企業作業需求的資料庫及開發支援相關業務的資料庫應用程式,以協助組織業務的進行,降低作業成本,支援管理決策,並進而創造企業競爭優勢,實為落實資料庫應用的二大課題。本課程的目標即在介紹資料庫設計與管理的方法與觀念,以及資料庫應用程式的開發技術,期望能培養並訓練一般學生能具備分析及建置資料庫系統之能力。Databases are an important core component of the information system and an important tool for integrating enterprise information; and how to design databases that meet the business needs of enterprises and develop database applications that support related businesses to assist in the progress of organizations, reduce operational costs, support management decisions, and thus create corporate competition advantages, and implement the two major topics of database application. The purpose of this course is to introduce methods and concepts of database design and management, as well as the development technology of database applications, and it is expected to cultivate and train general 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” Shiweishan Research Office
2. "SQL instruction syntax quick search index manual (supports Oracle, SQL Server, Mysql, PostgreSQL, Access)" Zheng Shichang
評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
---|---|---|
期中考期中考 Midterm exam |
30 | |
期末考期末考 Final exam |
40 | |
平時作業與學習態度平時作業與學習態度 Normal work and learning attitude |
30 |