F6 SQL Database Programming · 2026/27

English main · 中文輔助

Updated 2026-09-04: This course now includes visual models, active-recall questions, next-lesson / 1-week review prompts, Unit 1–6 navigation, and screenshot reference answers for all six ClassWorks.

本次更新： 每個單元加入概念圖或概念模型、主動回想，以及下一課與一星期後的複習提示。

Tool / 工具：sqliteviz.com — upload the provided .csv / .db file and run queries directly in the browser. 使用瀏覽器版 sqliteviz.com，上傳課堂提供的資料檔後直接執行查詢。

Course contents

• Unit 1 · SELECT, LIMIT, OFFSET, WHERE, ORDER BY
• Unit 2 · ROUND, CONCAT, UPPER / LOWER
• Unit 3 · GROUP BY, COUNT, SUM, AVG, MIN/MAX, HAVING
• Unit 4 · Grocery Store Practice
• Unit 5 · JOIN ... ON
• Unit 6 · Multi-table Join Practice

How to Practice / 練習方式

1. Download the data file from the link given in each unit. 從各單元連結下載資料檔。
2. Open sqliteviz.com and load the file as a table. 於 sqliteviz.com 匯入成資料表。
3. Write your query, run it, then compare the result with the expected columns described in each task. 撰寫查詢、執行，並核對輸出欄位是否正確。
4. Take a screenshot of a successful run for submission. 截圖成功執行的結果作為繳交紀錄。

Learning Routine / 學習流程

Understand one query idea → run it → explain the result without looking → revisit it next lesson and one week later.

Course Retrieval Map / 課程回想地圖

1. Rows: SELECT, WHERE, ORDER BY, LIMIT
2. Values: ROUND, CONCAT, UPPER, LOWER, AS
3. Groups: GROUP BY, aggregate functions, HAVING
4. Relationships: JOIN, LEFT JOIN, shared keys

30-Second Review / 30 秒複習

Say the four stages above in order, then name one SQL clause for each stage.