BH3003 資料庫系統與設計 (Database System and Design)
本課程著重跨領域學習學生之資料庫建置與使用能力的培養，搭配隨堂上機實作練習、回家作業等，強化程式撰寫技巧，同時訓練學生邏輯思考能力；以有效率、邏輯的方式解決問題。課堂引入健康數據做為上機練習範例，培養學生處理與分析健康醫療資料之技巧。
上課時間 每周一 14:10~17:00 (第6,7,8節)
1. Final Project: 40%
2. 作業成績 (Homeworks + mini-projects): 50%
3. 平時成績(上課表現): 10% (全勤基本分4分)
4. 未請假缺席視情況扣分
本門課融入部分學程 Capstone 課程所需的知識、技術，課堂 Bonus 作業、活動將會是小組在參與Capstone課程時，能獲得的技術支援點數。
我們有Teams群組，課程公告都會發在那邊，請同學先行安裝、確認學校的 Teams群組可以登入。
請大家配合學校的防疫政策，在教室內戴口罩。
學校防疫政策
講義 PDF檔案密碼: cloud
| 周次 | 日期 | 預定進度 |
| 1 | 2022-09-12 | Introduction data.csv description.pptx |
| 2 | 2022-09-19 |
PowerQuery and data management week02_PowerQuery.pdf Silverlight_x64.7z Day_Confirmation_Age_County_Gender_19CoV.csv Age_County_Gender_061.csv |
| 3 | 2022-09-26 |
Excel and data management, VBA week03_ExcelVBA.pdf week03_VBA.zip |
| 4 | 2022-10-03 |
mini-project: PowerQuery week04_AWSEducate申請流程(學生).pdf week04_excel資料搜集器.pdf week04_excel資料搜集器.zip |
| 5 | 2022-10-10 | |
| 6 | 2022-10-17 | Introduction to Database Systems week05.1_introduction.pdf week05.2_xampp.pptx week05.3_SQL basic.上_stu.pdf week05_demo_databas.zip |
| 7 | 2022-10-24 | Introduction to SQL language (basic) week05.4_SQL basic.下_stu.pptx |
| 8 | 2022-10-31 | Introduction to SQL language (advance) week06_SQLadv_stu.pdf |
| 9 | 2022-11-07 | |
| 10 | 2022-11-14 |
Introduction to SQL language (management) Introduction to PHP, web server environment week07.1_SQL_management_stu.pdf week07.1_SQL_management_stu.pptx week07.2_SQL_DB_stu.pdf week07.2_SQL_DB_stu.ppt |
| 11 | 2022-11-21 |
PHP and SQL (query data) week10_SQLpractice.docx data.csv PHP and SQL (interactive form) week08.PHP_SQL.zip |
| 12 | 2022-11-28 | mini-project: SQL demoTable.php |
| 13 | 2022-12-05 |
Web parser using Python (I) week13.python5_webparser.pdf week13.python3_files.pdf
import urllib.parse
encodedString = urllib.parse.quote_plus('大雨')
decodedString = urllib.parse.unquote('%E5%A4%A7%E9%9B%A8')
print(encodedString)
print(decodedString)
|
| 14 | 2022-12-12 |
python6_firebase
安裝python-firebase: !pip install git+https://github.com/ozgur/python-firebase |
| 15 | 2022-12-19 | Project discussion and QA & Project proposal |
| 16 | 2022-12-26 | Project discussion and QA & Project proposal |
| 17 | 2023-01-2 | 元旦放假 |
| 18 | 2022-01-09 |
Project Demonstration 期末報告說明.pptx |