F6 SQL Database Programming · 2026/27

English main · 中文輔助

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
• ClassWork 4 · Grocery Store Practice
• Unit 5 · JOIN ... ON
• ClassWork 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. 中文：截圖成功執行的結果作為繳交紀錄。