{"course":{"id":"114262702B01","name":"資料庫實務","enroll_type":"選修","general_type":"","dept":"人工智慧學程","grade":2,"class_group":"甲","teacher":"郭振洋","credit":3,"hour":3,"time":[{"day":3,"section":[2,3,4]}],"classroom":"","max":56,"min":10,"remark":"","alt_for":"","courses":""},"detail":[["指定教材",""],["參考教材","唐成, PostgreSQL 修煉之道：從小工到專家, 機械工業出版社, 2020-09-01"],["成績評量標準","出席(10%)\n課堂表現(20%)\nHomework(20%)\nMidterm Exam(25%)\nFinal Exam(25%)"],["教學方法","理論講授,實務講授"],["教學目標","本課程旨在培養學生對關聯式資料庫的基礎理解與實作能力，從零開始介紹資料庫的基本概念、結構與操作方式。透過 PostgreSQL 作為主要教學系統，學生將學習資料表設計、SQL 查詢、資料完整性與基本效能觀念，建立正確的資料庫思維。課程強調動手實作與觀念理解並重，使學生能夠設計簡單且結構良好的資料庫，並具備未來銜接程式設計、資料分析或相關應用之基礎能力。"]],"office_time":[["郭振洋",""]],"schedule":[["2026/01/14","2","4","3","郭振洋","Introduction","","講解課程規定，學習基本環境操作",""],["2026/01/21","2","4","3","郭振洋","Databases and Database Systems","","介紹資料庫在資訊系統中的角色，說明常見資料庫種類：  Relational Databases  NoSQL Databases (Document, Key-Value, Graph)  說明為何本課程選擇 PostgreSQL  實作：安裝 PostgreSQL Server、建立資料庫並連線",""],["2026/01/28","2","4","3","郭振洋","Tables, Rows, and Columns","","說明關聯式資料庫的基本結構  Table、Row、Column 與現實資料的對應  基本命名與結構觀念  實作：建立資料表、插入資料、基本查詢",""],["2026/02/04","2","4","3","郭振洋","Data Types and NULL Values","","介紹常見資料型別  說明 NULL 的意義與常見誤解  為何正確的型別選擇很重要  實作：嘗試錯誤型別與觀察錯誤訊息",""],["2026/02/25","2","4","3","郭振洋","Primary Keys and Uniqueness","","說明 Primary Key 的角色  比較自然鍵與代理鍵  為何唯一性對資料庫很重要  實作：設定 PK、測試重複資料插入",""],["2026/03/04","2","4","3","郭振洋","Basic Data Retrieval: SELECT and WHERE","","學習 SQL 查詢基本語法  條件篩選與邏輯運算  實作：多條件查詢與文字比對",""],["2026/03/11","2","4","3","郭振洋","Sorting and Limiting Query Results","","使用 ORDER BY 進行排序  使用 LIMIT 進行資料分頁  實作：Top-N 查詢與排序練習",""],["2026/03/18","2","4","3","郭振洋","Aggregate Functions and GROUP BY","","使用 COUNT、SUM、AVG 等聚合函式  正確理解 GROUP BY 的使用規則  實作：分組統計與錯誤案例分析",""],["2026/03/25","2","4","3","郭振洋","Midterm Exam","","","期中考"],["2026/04/01","2","4","3","郭振洋","Foreign Keys and Table Relationships","","Foreign Key 的意義與限制  資料完整性概念  實作：建立表關聯並測試違反限制的情況",""],["2026/04/08","2","4","3","郭振洋","JOIN Operations","","INNER JOIN 與 LEFT JOIN 的差異  JOIN 的運作原理  常見 JOIN 錯誤說明  實作：多表查詢練習",""],["2026/04/15","2","4","3","郭振洋","Database Normalization","","說明資料重複與異常問題  介紹第一至第三正規化  實作：將不良表結構重新設計",""],["2026/04/22","2","4","3","郭振洋","Schema Design Practice","","從需求描述設計資料庫結構  欄位、主鍵與外鍵的整合思考  實作：完整 Schema 設計與建表",""],["2026/04/29","2","4","3","郭振洋","Indexes and Query Performance","","Index 的基本原理  使用 EXPLAIN 觀察查詢行為  實作：有無索引的效能比較",""],["2026/05/06","2","4","3","郭振洋","Transactions and Data Consistency","","交易（Transaction）的概念  ACID 基本認知  資料一致性的重要性  實作：COMMIT 與 ROLLBACK 操作",""],["2026/05/13","2","4","3","郭振洋","Constraints and Data Validation","","NOT NULL、UNIQUE、CHECK 約束  為何資料庫需要主動防錯  實作：加入限制並測試錯誤資料",""],["2026/05/20","2","4","3","郭振洋","Comprehensive Database Practice","","整合本學期所有資料庫概念  從零開始建立完整小型系統  建表、關聯、查詢一次完成",""],["2026/05/27","2","4","3","郭振洋","Final Exam","","","期末考"]]}