Database
Programming in Practice (Spring 2025) @ K-DAI, KMITL
Instructor
Teach and develop the course. Topics include data models, query languages (focusing on SQL), physical
data organization,
storage model (NSM, DSM, PAX), query engine, query planning and optimization, concurrency control, and
recovery control. DuckDB is used to demonstrate the concepts.
Distributed Data Storage (Fall 2024) @ CMKL University
Instructor
Teach and develop the course. Topics include multi-disk systems (RAID), internal consistency mechanism,
caching, distributed system basics, and distributed file systems (multi-client, multi-server).
Parallel Computing (Fall 2024) @ CMKL University
Instructor
Teach and develop the course. Topics include performance, parallelism basics, modern computer architecture
(pipelining, superscalar, out-of-order processing, multicore, GPU), instruction-level parallelism
(unrolling, separate
accumulator, vectorization), and shared-memory parallelism (memory consistency, cache coherency). SIMD,
POSIX thread (pthread), and OpenMP are
used to
demonstrate the concepts.
Storage and File System Fundamentals (Fall 2024) @ CMKL University
Instructor
Teach and develop the course. Topics include device management, persistent storage (HDD, NAND Flash SSD),
file
system design and implementation
techniques.
Database Management (Fall 2024) @ SUIC
Instructor
Teach and develop the course. Topics include SQL (single-table, multiple-table, DDL, constraints) and
logical database design. MySQL and DuckDB are used to demonstrate the concepts.
Special Topic
in Computer Science 2: Computer Systems (Fall
2024) @ Computer Science, KMITL
Co-Instructor
Teach and develop the course. Topics include data abstraction, machine language, memory hierarchy, code
optimization, virtual memory, dynamic memory allocation, network programming, concurrent programming, and
thread-level parallelism.
Foundation of
Programming (Summer 2024) @ K-DAI, KMITL
Instructor
Teach and develop the course. Topics include problem solving, algorithmic thinking, abstractions,
structured programming (sequential, selective, iterative), subprograms, object-oriented programming
(object, message passing, inheritance), file
I/O, and well-documented code.
Database
Programming in Practice (Spring 2024) @ K-DAI, KMITL
Co-Instructor
Co-teach and co-develop the course. Topics include SQL (single-table, multiple-table, DDL, constraints)
and
logical database design. DuckDB is used to demonstrate the concepts.