Academic Year/Semester: 111-1
Course Number: 130032
Instructor: Chien-Hung Chen
Course Title: Programming (1)
Grade: 2 Credits: 3.0
Class location: Room 241+Room 268, Management Building
Class hours: 1bcd
This course aims to cultivate the following core competencies for students:
- Information technology application and innovation ability (for bachelor’s degree program)
- Information technology professional competence (for master’s degree program)
Course objectives:
Databases are an important core of various information management systems. This course has the following objectives: (1) to cultivate students’ ability to plan databases, (2) to cultivate students’ ability to use SQL to operate database systems, (3) to cultivate students’ basic management abilities for database systems, and (4) to establish students’ concepts of linking database planning, operation, and system requirements.
Instructor office hours: Lcation:Tue. 10:am-11am or by appointment. Room 5105, College of Management
Teaching approach:
Teacher lectures and practical exercises.
Classroom discussions and demonstrations.
Self-learning through Stanford online courses.
Grading criteria:
Exam: 80%
Regular performance: 20% which includes attendance, participation in class discussions, quiz scores, in-class exercises, homework, self-directed learning activities, and additional contributions to the course.
Course schedule (week, topic, activities, evaluation/assignment, text, etc.):
Week 1: Introduction to Database Management. Homework.
Week 2: Data and Data Modeling Concepts, Xampp: the Apache Friends Testing Environment. Classroom Practice.
Week 3: SQL: Data Definition Language and Data Manipulation Language. Classroom Practice.
Week 4: SQL: SQL Delete, insert. Classroom Practice.
Week 5: SQL: DML: update, select. Classroom Practice.
Week 6: Quiz: Single table query.
Week 7: SQL: Functions, Grouping and Aggregation.
Week 8: Data Modeling with multiple entities.
Week 9: Quiz: Multiple table query.
Week 10: SQL: Complex Query with Subqueries (I). Classroom Practice.
Week 11: Quiz: Subquery.
Week 12: Data Modeling & Normalization. Classroom Practice, Assignment.
Week 13: Views, Store Procedures and Triggers. Classroom Practice.
Week 14: Transaction processing. Classroom Practice.
Week 15: Final Exam.
Week 16: Database Administration: General Concepts & Access Controls. Classroom Practice.
Week 17: Exploring new trends and applications of Database Systems. Self-learning.
Week 18: Implementing Database Applications. Self-learning.