erdEducation Reform and Development2652-53642652-5372Bio-Byword Scientific Publishing Pty. Ltd.10.26689/erd.v7i5.10588ArticleResearch on the Design and Implementation of Case Teaching in MySQL Database Coursehttps://artdesignp.com/journal/erd/7/5/10.26689/erd.v7i5.10588ZhouQian,ZhangJing2025752025-05-29With the rapid development of information technology, the demand for data processing and data storage in all walks of life is increasing. MySQL, as an open-source relational database management system, has been widely used in various application systems because of its high performance, high reliability, and ease of use. This paper aims to discuss the design and implementation of case teaching in the MySQL database course, and improve students’ understanding of the theoretical knowledge of MySQL database and practical ability through specific case analysis. Through the design of a series of cases related to actual business scenarios, combined with theoretical teaching and practical operation, students can master the basic operation of MySQL database, data query and analysis, and data security and protection skills.

Zhou D, 2021, MySQL Database Basic Example Tutorial. Posts and Telecommunications Press, Beijing, 238.

Feng Y, Pan Z, Jia Q, et al., 2019, Differentiation Teaching Practice of Oracle Database Based on Talent Training Goals. Education and Teaching Forum, 2019(10): 136–137.

Xiong Q, 2023, Application Analysis of MySQL Database in the Era of Big Data. Information and Computer (Theoretical Edition), 35(14): 209–212.

Zhao L, Qian B, 2017, Application of Case Teaching Method in Computer Courses in Higher Vocational Colleges – A Case Study of Python Course Teaching in A School. Computer Knowledge and Technology, 17(26): 267–268 + 276.

Fan S, Yu X, Zhang C, et al., 2024, Project-Based Teaching Practice Based on Integration of Production and Education. Journal of Higher Education, 10(27): 122–125.

Tian H, 2017, Review and Countermeasures of Software Engineering Case Teaching. Electronic Commerce, 2017(8): 83–84.

Gao Y, 2024, Exploration on the Teaching Model of “MySQL Database Application” Course in Adult Colleges and Universities. Wireless Internet Technology, 21(6): 116–118.

Liu C, Wang C, 2024, Design of Teaching Evaluation System of MySQL Database Course. Electronic Technology, 53(1): 393–395.

Pu Q, 2019, Talent Training Target-Oriented Oracle Database Teaching Practice. Economic Research Guide, 2019(33): 141 + 157.

Zhang H, 2019, Database Design and Optimization of Student Information Management System. Information and Computer (Theoretical Edition), 36(11): 244–246.

Yang G, 2019, Research on Data Privacy and Security Mechanism of MySQL Database. Information and Computer (Theoretical Edition), 32(20): 140–142.

Zhao B, Jia X, 2023, In-Depth Evaluation and Analysis of Classroom Teaching Effect. Journal of Electrical and Electronic Teaching, 45(4): 160–165.

Zhang C, Wang Y, 2024, A Brief Analysis of the Questionnaire on the Effect of Practical Teaching Under the Online Teaching Mode. China New Communication, 26(9): 34–36.

Tang H, Li L, Liu J, 2019, Research on the Application of ChatGPT in MySQL Database Teaching in Higher Vocational Colleges. Internet of Things Technology, 14(6): 156–158.

Wang X, 2024, Research on Innovation of University Teaching Management Based on Big Data Analysis. Journal of Science and Education, 2024(21): 19–22.