Database Applications
Course Code 241017
Semester 2025-1
Schedule Mon6/Wed7/Wed8
Credits 3/3
Year Year 3
Department 경영학
Instructor: 김용희
Email: yhkim1981@sunmoon.ac.kr
Course Description
Databases are a core technology of the modern digital world, serving as the foundation for all applications and services. This course is designed for students encountering databases for the first time, structured to make complex concepts easy and fun to learn. Students will learn database design methods through real-world examples and acquire skills in using modern database tools such as MySQL or Access.
Learning Objectives
- Understand basic database concepts and terminology
- Design and build simple databases independently
- Acquire skills in querying, inserting, updating, and deleting data using SQL
- Develop simple database applications based on original ideas
- Gain basic knowledge of modern cloud database services
Evaluation
Midterm
30%
Final
30%
Assignment
20%
Attendance
20%
Weekly Schedule
| Week | Topic | Details |
|---|---|---|
| 1 | Understanding Databases and MySQL Installation | Database overview and environment setup |
| 2 | Database Operations | Database creation, management, backup |
| 3 | Understanding Database Modeling | ER diagrams, normalization |
| 4 | MySQL Tools and Utilities | MySQL Workbench, phpMyAdmin |
| 5 | Data Retrieval and Grouping | SELECT statements, GROUP BY, HAVING |
| 6 | Data Insertion, Modification, Deletion, and WITH Clause | INSERT, UPDATE, DELETE, CTE |
| 7 | Data Types and Built-in Functions | Data types, string/date/math functions |
| 8 | Midterm Exam | |
| 9 | Joins and SQL Programming | INNER/OUTER JOIN, subqueries |
| 10 | Tables and Views | Table creation/modification, view utilization |
| 11 | Indexes | Index creation and optimization |
| 12 | Stored Programs | Stored procedures, functions, triggers |
| 13 | Full-Text Search and Partitioning | Full-text search, table partitioning |
| 14 | PHP Programming for Database Integration | PHP-MySQL integration, web application development |
| 15 | Final Exam |
Textbook
Self-developed PPT materials (2021)