### 資料庫系統與SQL語法課程目標及內涵
#### 課程目標
1. **理解資料庫基本概念**：
- 學生應理解資料庫的基本概念，包括資料、資料庫、資料庫管理系統（DBMS）等。
- 學生應該能夠描述資料庫在現代資訊系統中的作用和重要性。
2. **熟悉關聯式資料庫模型**：
- 學生應熟悉關聯式資料庫模型，了解表、行、列、主鍵、外鍵等基本概念。
- 學生應該能夠設計簡單的關聯式資料庫，並了解正規化的基本原則。
3. **掌握SQL語法**：
- 學生應能熟練運用SQL語法進行資料庫操作，包括資料查詢、插入、更新和刪除等。
- 學生應該能夠撰寫複雜的SQL查詢，包括多表連接、子查詢和集合運算等。
4. **資料庫設計與實作**：
- 學生應具備資料庫設計的能力，能夠從需求分析到資料庫設計，最後實作一個完整的資料庫系統。
- 學生應該能夠進行資料庫的創建、修改和維護。
5. **瞭解資料庫管理與優化技術**：
- 學生應瞭解資料庫管理與維護的基本技術，包括備份、還原、安全性、性能調優等。
- 學生應該能夠實施基本的資料庫管理任務，並掌握一些資料庫性能優化的方法。
6. **熟悉現代資料庫技術**：
- 學生應熟悉現代資料庫技術，包括分散式資料庫、NoSQL資料庫、大數據處理等。
- 學生應該瞭解不同資料庫技術的特點及其應用場景。
#### 課程內涵
1. **資料庫基礎**：
- 資料與資料庫的基本概念
- 資料庫管理系統（DBMS）的功能與種類
- 資料模型與模式
2. **關聯式資料庫模型**：
- 表、行、列、主鍵、外鍵
- 關聯式代數與關聯運算
- 正規化理論及其應用
3. **SQL語法**：
- 基本SQL語法：SELECT、INSERT、UPDATE、DELETE
- 高級SQL語法：JOIN、子查詢、視圖、索引
- 聚合函數與群組操作：GROUP BY、HAVING
- 交易管理：COMMIT、ROLLBACK
4. **資料庫設計**：
- 資料庫設計流程：需求分析、概念設計、邏輯設計、實體設計
- ER模型（實體-關係模型）的設計與轉換
- 資料庫模式設計與優化
5. **資料庫管理與優化**：
- 資料庫安裝與配置
- 使用者權限管理
- 資料庫備份與還原
- 資料庫性能調優技術：查詢優化、索引優化
6. **現代資料庫技術**：
- 分散式資料庫與雲資料庫
- NoSQL資料庫技術（如MongoDB、Cassandra）
- 大數據處理與分析技術（如Hadoop、Spark）
7. **實踐與應用**：
- 實作一個小型資料庫應用系統
- 使用現代DBMS進行資料庫操作與管理
- 綜合案例分析與專案實作
這門課程旨在為學生提供全面的資料庫知識，從基礎概念到實踐操作，並結合現代技術進行應用，以培養學生在資料庫領域的實踐能力和專業技能。### Database system and SQL syntax course objectives and connotations
#### Course Target
1. ** Understand the basic concepts of databases**:
- Students should understand the basic concepts of databases, including data, databases, database management systems (DBMS), etc.
- Students should be able to describe the role and importance of databases in modern information systems.
2. **Familiar with the associated database model**:
- Students should be familiar with the related database model and understand basic concepts such as tables, rows, columns, main keys, and external keys.
- Students should be able to design simple related databases and understand the basic principles of regularization.
3. **Master SQL syntax**:
- Students should be able to use SQL syntax to perform database operations, including data query, insertion, update and delete.
- Students should be able to write complex SQL query, including multi-table connections, sub-queries, and set calculations.
4. **Database design and implementation**:
- Students should have the ability to prepare database design, be able to analyze requirements to database design, and finally implement a complete database system.
- Students should be able to create, modify and maintain databases.
5. ** Understand database management and optimization technology**:
- Students should understand the basic technologies of database management and maintenance, including backup, restoration, security, performance optimization, etc.
- Students should be able to implement basic database management tasks and master some methods to optimize database performance.
6. **Familiar with modern database technology**:
- Students should be familiar with modern database technology, including decentralized databases, NoSQL databases, large data processing, etc.
- Students should understand the characteristics of different database technologies and their application scenarios.
#### Course Inclusion
1. **Database Base**:
- Basic concepts of data and databases
- Functions and types of Database Management System (DBMS)
- Data Models and Patterns
2. **Related Database Model**:
- Table, row, column, main key, outer key
- Related Algebra and Related Computation
- Regular theory and its application
3. **SQL syntax**:
- Basic SQL syntax: SELECT, INSERT, UPDATE, DELETE
- Advanced SQL syntax: JOIN, subquery, video, index
- Aggregation function and group operations: GROUP BY, HAVING
- Transaction management: COMMIT, ROLLBACK
4. **Database Design**:
- Database design process: requirements analysis, concept design, logical design, physical design
- Design and transformation of ER model (physical-relational model)
- Database Mode Design and Optimization
5. **Database Management and Optimization**:
- Database installation and configuration
- User Rights Management
- Database backup and restoration
- Database performance optimization technology: query optimization, index optimization
6. **Modern Database Technology**:
- Decentralized Database and Cloud Database
- NoSQL database technology (such as MongoDB, Cassandra)
- Large data processing and analysis technologies (such as Hadoop, Spark)
7. **Practical and Application**:
- Implement a small database application system
- Database operation and management using modern DBMS
- Comprehensive case analysis and project implementation
This course aims to provide students with a comprehensive database knowledge, from basic concepts to practical operations, and is applied in combination with modern technology to cultivate students' practical abilities and professional skills in the database field.
講義
Talk about
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 期中考期中考 Midterm exam |
30 | |
| 期末報告期末報告 Final report |
30 | |
| 作業與討論點名作業與討論點名 Business and discussion point names |
40 |
