### 資料庫系統與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 Contents
#### Course Objectives
1. **Understand the basic concepts of database**:
- 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 relational database model**:
- Students should be familiar with the relational database model and understand basic concepts such as tables, rows, columns, primary keys, and foreign keys.
- Students should be able to design simple relational databases and understand the basic principles of formalization.
3. **Master SQL syntax**:
- Students should be able to skillfully use SQL syntax to perform database operations, including data query, insertion, update, and deletion.
- Students should be able to write complex SQL queries, including multi-table joins, subqueries, and set operations.
4. **Database design and implementation**:
- Students should have the ability to design databases, and be able to proceed from requirements analysis 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 techniques of database management and maintenance, including backup, restore, security, performance tuning, etc.
- Students should be able to perform basic database management tasks and master some database performance optimization methods.
6. **Familiar with modern database technologies**:
- Students should be familiar with modern database technologies, including distributed databases, NoSQL databases, big data processing, etc.
- Students should understand the characteristics of different database technologies and their application scenarios.
#### Course content
1. **Database Basics**:
- Basic concepts of data and databases
- Functions and types of database management systems (DBMS)
- Data models and schemas
2. **Relational database model**:
- Table, row, column, primary key, foreign key
- Associative algebra and associative operations
- Formalization theory and its applications
3. **SQL syntax**:
- Basic SQL syntax: SELECT, INSERT, UPDATE, DELETE
- Advanced SQL syntax: JOIN, subquery, view, index
- Aggregation functions and group operations: GROUP BY, HAVING
- Transaction management: COMMIT, ROLLBACK
4. **Database Design**:
- Database design process: requirements analysis, conceptual design, logical design, physical design
- Design and conversion of ER model (entity-relationship model)
- Database schema design and optimization
5. **Database Management and Optimization**:
- Database installation and configuration
- User rights management
- Database backup and restore
- Database performance tuning technology: query optimization, index optimization
6. **Modern Database Technology**:
- Distributed databases and cloud databases
- NoSQL database technology (such as MongoDB, Cassandra)
- Big data processing and analysis technologies (such as Hadoop, Spark)
7. **Practice and Application**:
- Implement a small database application system
- Use modern DBMS for database operation and management
- Comprehensive case analysis and project implementation
This course aims to provide students with comprehensive database knowledge, from basic concepts to practical operations, combined with the application of modern technology, to cultivate students' practical abilities and professional skills in the database field.
講義
Handouts
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 期中考期中考 midterm exam |
30 | |
| 期末報告期末報告 Final report |
30 | |
| 作業與討論點名作業與討論點名 Assignment and discussion roll call |
40 |
