查詢教學大綱與進度

教學大綱與進度

課程基本資料：

學年期課號課程名稱階段學分時數修教師班級人撤備註

113-2 341090 資料庫應用實務 1 3.0 3 ★ 張漢利工管二甲
工管二乙 33 2 工管甲乙合開,計中電腦教室

學年期	課號	課程名稱	階段	學分	時數	修	教師	班級	人	撤	備註
113-2	341090	資料庫應用實務	1	3.0	3	★	張漢利	工管二甲工管二乙	33	2	工管甲乙合開,計中電腦教室

教學大綱與進度：

教師姓名張漢利　教師諮商時間(Office Hours)

Email hendri@mail.ntut.edu.tw

最後更新時間 2025-02-17 17:21:54

課程大綱 In this introductory course, students will gain hands-on experience in building and managing database-driven applications using Python and Django. They will learn how to design efficient relational databases, perform CRUD operations, implement user authentication, and handle file storage. As the course progresses, students will explore more advanced topics such as PostgreSQL, query optimization, and deploying applications with Docker. Through practical assignments, a mid-term project, and a final presentation, students will develop real-world problem-solving skills and gain insights into best practices for database application development. Basic Python knowledge is required, and additional programming experience will be advantageous. However, since this is an introductory-level course, students from any background are welcome to join and build a strong foundation in modern, data-driven application development. 在這門入門課程中，學生將獲得建立和管理資料庫驅動應用程式的實作經驗，使用 Python 和 Django。他們將學習如何設計高效的關聯式資料庫，執行 CRUD 操作，實現使用者認證和處理檔案儲存。隨著課程的進行，學生將深入探索 PostgreSQL、查詢優化，以及使用 Docker 部署應用程式等進階主題。透過實作作業、期中專案和期末報告，學生將發展解決實際問題的技能，並獲得資料庫應用程式開發的最佳實踐見解。本課程要求具有基本的 Python 知識，其他程式設計經驗將有所幫助。然而，這是一門入門課程，任何背景的學生都歡迎參加，並建立現代資料驅動應用程式開發的堅實基礎。

課程進度 Week 1: Course Orientation Week 2: Initial Set-Up, Website and Webpages Week 3: Function- and class-based views, testing Week 4: Relational databases with Django Week 5: CRUD (Create-Read-Update-Delete) Week 6: Forms Week 7: User authentication system Week 8: Advanced user authentication and styling, permission Week 9: Midterm Presentation Week 10: Cross-Origin Resource Sharing Week 11: Restriction access Week 12: Project deployment Week 13: Docker, PostgreSQL Week 14: Static and dynamic website Week 15: Authorization Week 16: Project optimization Week 17: Final Project Implementation Week 18: Final Project Presentation and Course Wrap-Up

評量方式與標準 1. Quizzes: 35% 2. Reports: 25% 3. Mid-term presentation: 15% 4. Final-term presentation: 25%

使用教材、參考書目或其他 【遵守智慧財產權觀念，請使用正版教科書，不得使用非法影印教科書】

使用外文原文書：是
Vincent, W. S. (2024). Django for Beginners, 5th Edition: Build Modern Web Applications with Python. Vincent, W. S. (2020). Django for APIs: Build web APIs with Python and Django Vincent, W. S. (2020). Django for Professionals: Production websites with Python & Django

課程諮詢管道 Email, Office hour

延伸教學與資源

課程對應SDGs指標 SDG9：產業創新與基礎設施（Industry, Innovation and Infrastructure）
SDG11：永續城市與社區（Sustainable Cities and Communities）

課程是否導入AI

備註

教師姓名	張漢利　教師諮商時間(Office Hours)
Email	hendri@mail.ntut.edu.tw
最後更新時間	2025-02-17 17:21:54
課程大綱	In this introductory course, students will gain hands-on experience in building and managing database-driven applications using Python and Django. They will learn how to design efficient relational databases, perform CRUD operations, implement user authentication, and handle file storage. As the course progresses, students will explore more advanced topics such as PostgreSQL, query optimization, and deploying applications with Docker. Through practical assignments, a mid-term project, and a final presentation, students will develop real-world problem-solving skills and gain insights into best practices for database application development. Basic Python knowledge is required, and additional programming experience will be advantageous. However, since this is an introductory-level course, students from any background are welcome to join and build a strong foundation in modern, data-driven application development. 在這門入門課程中，學生將獲得建立和管理資料庫驅動應用程式的實作經驗，使用 Python 和 Django。他們將學習如何設計高效的關聯式資料庫，執行 CRUD 操作，實現使用者認證和處理檔案儲存。隨著課程的進行，學生將深入探索 PostgreSQL、查詢優化，以及使用 Docker 部署應用程式等進階主題。透過實作作業、期中專案和期末報告，學生將發展解決實際問題的技能，並獲得資料庫應用程式開發的最佳實踐見解。本課程要求具有基本的 Python 知識，其他程式設計經驗將有所幫助。然而，這是一門入門課程，任何背景的學生都歡迎參加，並建立現代資料驅動應用程式開發的堅實基礎。
課程進度	Week 1: Course Orientation Week 2: Initial Set-Up, Website and Webpages Week 3: Function- and class-based views, testing Week 4: Relational databases with Django Week 5: CRUD (Create-Read-Update-Delete) Week 6: Forms Week 7: User authentication system Week 8: Advanced user authentication and styling, permission Week 9: Midterm Presentation Week 10: Cross-Origin Resource Sharing Week 11: Restriction access Week 12: Project deployment Week 13: Docker, PostgreSQL Week 14: Static and dynamic website Week 15: Authorization Week 16: Project optimization Week 17: Final Project Implementation Week 18: Final Project Presentation and Course Wrap-Up
評量方式與標準	1. Quizzes: 35% 2. Reports: 25% 3. Mid-term presentation: 15% 4. Final-term presentation: 25%
使用教材、參考書目或其他	【遵守智慧財產權觀念，請使用正版教科書，不得使用非法影印教科書】使用外文原文書：是 Vincent, W. S. (2024). Django for Beginners, 5th Edition: Build Modern Web Applications with Python. Vincent, W. S. (2020). Django for APIs: Build web APIs with Python and Django Vincent, W. S. (2020). Django for Professionals: Production websites with Python & Django
課程諮詢管道	Email, Office hour
延伸教學與資源
課程對應SDGs指標	SDG9：產業創新與基礎設施（Industry, Innovation and Infrastructure） SDG11：永續城市與社區（Sustainable Cities and Communities）
課程是否導入AI
備註