05696110 Database Programming In Practice 🦆🐻‍❄️
Academic Year 2025 | Semester 2
Home | Project | BigGrade | 4rum | BigQ
Course Description
The recent hype of artificial intelligence has led many AI companies to struggle or fail, frequently due to their poor data management. This course will serve as an introductory step towards modern practices for data management, starting from data persistence, data encoding and organization, database management tasks, relational data model, query language design and evaluation, anomalies from data redundancy, logical database design, data caching, query acceleration, transaction management, concurrency control protocols, logging, and recovery mechanism. Most of these topics will be associated with practical labs leveraging modern data management tools (e.g., DuckDB, Polars).
Course Information
  • Lecture: Tuesday/Wednesday 9:00 - 11:00
  • Location: TBA

Course Evaluation
  • Lecture Quiz 5%
  • Lab Assignment 10%
  • Solo Project (SP) 20%
  • Team Project 25%
  • SQL Exam 10%
  • Final Exam 30%
Course Staff
  • Yuttapichai Kerdcharoen (Guide) Instructor
    (Office Hours: Monday 13:00 - 17:00)
  • Phuvis Kerdpramote (Poom) Head TA
    (Office Hours: TBA)
  • Saksakun Jiarapong (Indy) Head TA
    (Office Hours: TBA)
  • Kyawt Hmue Kay Khaing (Ash) TA
    (Office Hours: TBA)
  • Yanapat Sorasak (Audy) TA
    (Office Hours: TBA)
Schedule
⚠️ The first four lectures will NOT be in-person, as the instructor will still be in 🇺🇸
G - Guide | P - Poom | A - Ash
Week Date Topic
Nov 22 Lecture #1 - Course Overview G
Video Only
1 Nov 25 Lab #1 - Google Sheets 101 P
Nov 26 Lecture #2 - Data Persistence G
Online
2 Dec 2 Lab #2 - Python File I/O P
SP-1 Out
Dec 3 Lecture #3 - Data Encoding and Organization G
Online
3 Dec 9 Lab #3 - Polars 101 🐻‍❄️ P
Dec 10
Constitution Day 		Lecture #4 - Database Management G
Video Only
4 Dec 16 Lecture #5 - Relational Data Model and Algebra G
Dec 17 Lab #4 - SQL (Part 1) - DDL, DML, Constraints 🦆 A
SP-2 Out
5 Dec 23 Lecture #6 - Query Language Design and Evaluation G
SP-1 Due
Dec 24 Lab #5 - SQL (Part 2) - Single-Table Queries 🦆 A
6 Dec 30 - 31 New Year Week (No Class)
7 Jan 6 Lab #6 - SQL (Part 3) - Joins and Subqueries 🦆 G
Jan 7 Lecture #7 - Data Redundancy G
8 Jan 13 SQL Exam
Jan 14 Lab #7 - SQL (Part 4) - Window Functions, Common Table Expressions 🦆 G
9 Jan 20 - 21 Midterm Week (No Class)
10 Jan 27 Lecture #8 - Entity-Relationship Model G
SP-2 Due
Jan 28 Lecture #9 - Reducing from E/R to Relational G
SP-3 Out
11 Feb 3 Lab #8 - E/R Modeling (Case Study) P
Feb 4 Lecture #10 - Data Caching G
12 Feb 10 Project Proposal Presentation
Feb 11 Lecture #11 - Query Acceleration G
SP-4 Out
13 Feb 17 Lab #9 - Query Profiling and Using Indexes G
SP-3 Due
Feb 18 Lecture #12 - Concurrency Control Theory G
14 Feb 24 Project Halfway Check-In
Feb 25 Lecture #13 - Concurrency Control Protocols G
15 Mar 3
Makha Bucha 		Lecture #14 - Logging and Recovery Mechanism G
Video Only
Mar 4 Guest Lecture (TBA)
SP-4 Due
16 Mar 10 Lab #10 - Transactions P
Mar 11 Project Presentation
17 Mar 26 Final Exam