Yuttapichai Kerdcharoen (Guide)
Instructor
Phuvis Kerdpramote (Poom)
Head Teaching Assistant
Saksakun Jiarapong (Indy)
Head Teaching Assistant
Malapchai Chaisihat (Nueng)
Teaching Assistant
Kyawt Hmue Kay Khaing (Ash)
Teaching Assistant
Yanapat Sorasak (Audy)
Teaching Assistant
| Week | Date | Topic | |
|---|---|---|---|
| Nov 24 |
Lecture #1 - Introduction to Database
G
Video Only |
||
| 1 | Nov 25 | Lab #1 - Google Sheets 101 π» P | |
| Nov 26 |
Lecture #2 - Data Persistence
G
Online SP-1 Out |
||
| 2 | Dec 2 | Lab #2 - Python File I/O π» I | |
| Dec 3 |
Lecture #3 - Data 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 |
Lab #4 - SQL (Part 1) - DDL, DML, Constraints, Database Connectivity π¦π»
N
SP-1 Due |
|
| Dec 17 |
Lab #5 - SQL (Part 2) - Single-Table Queries π¦π»
N
SP-2 Out |
||
| 5 | Dec 23 | Lecture #5 - Data Models G | |
| Dec 24 | Lecture #6 - Modern Query Languages G | ||
| 6 | Dec 30 - 31 | New Year Week (No Class) | |
| 7 | Jan 6 | Lab #6 - SQL (Part 3) - Subqueries and Joins π¦π» I | |
| Jan 7 | Lecture #7 - Data Redundancy G | ||
| 8 | Jan 13 | SQL Exam | |
| Jan 14 | Lab #7 - SQL (Part 4) - Window Functions, Common Table Expressions π¦π» N | ||
| 9 | Jan 20 - 21 | Midterm Week (No Class) | |
| 10 | Jan 27 |
Lecture #8 - Entity-Relationship Model
G
SP-2 Due |
|
| Jan 28 |
Lab #8 - Logical Database Design (Practice)
G
SP-3 Out |
||
| 11 | Feb 3 | Lab #9 - Logical Database Design (Case Study) P | |
| Feb 4 | Lecture #9 - Data Caching G | ||
| 12 | Feb 10 | Project Proposal Presentation | |
| Feb 11 |
Lecture #10 - Database Indexes
G
SP-4 Out |
||
| 13 | Feb 17 |
Lab #10 - Performance Tuning π¦
I
SP-3 Due |
|
| Feb 18 | Lecture #11 - Concurrency Control and Protocols G | ||
| 14 | Feb 24 | Project Halfway Check-In | |
| Feb 25 | Lecture #12 - Logging and Recovery Mechanisms G | ||
| 15 |
Mar 3
Makha Bucha |
Lecture #13 - Data Protection
G
Video Only |
|
| Mar 4 |
Guest Lecture (TBA)
SP-4 Due |
||
| 16 | Mar 10 | Lab #11 - Transactions π¦ G | |
| Mar 11 | Project Presentation | ||
| Mar 26 | Final Exam |