This course introduces advanced database design concepts and application development techniques. Topics include schema refinement and physical database design, query processing and optimization, tuning, transaction concepts, real-world database programming techniques, and comprehensive database application development techniques. It is the prerequisite course for "Advanced Database Management". Both undergraduate and graduate students in computer science major can take this course.