This course systematically covers the fundamental principles, design, and implementation methods of databases. It primarily introduces the following topics: introduction to database systems, relational algebra, SQL (the standard language for relational databases), normalization theory and database design, database security and integrity, database backup and recovery, and database concurrency control.
课程介绍
【Course Introduction】
This course emphasizes the integration of theory and practice, dividing its objectives into knowledge, skills, and qualities.
Knowledge Objectives
Master the basic concepts, fundamental principles, and architecture of database systems; become proficient in using the standard language for relational databases; master database system design methods, and be able to design and develop database application systems in practical application environments.
Skills Objectives
Develop the ability to apply foundational knowledge of computer engineering and basic database theories to solve real-world engineering problems; familiarize students with the development environment and debugging techniques of database systems, equipping them with the skills to develop application software for database systems.
Qualities Objectives
Integrate ideological and political elements such as core socialist values, craftsmanship spirit, development perspectives, traditional culture, humanistic spirit, scientific literacy, and innovation capacity with professional knowledge. This aims to instill a sense of national pride, scientific spirit, professional ethics, engineering literacy, and foster a sense of social responsibility and innovative spirit in students.
【Course Features】
This course is rich in examples and emphasizes an application-oriented approach, focusing on developing students’ abilities to solve real-world problems by strengthening case-based teaching. It integrates theory and practice, using case studies like the student-course database and employee-department database as the main thread to explain the basic principles, design, and implementation methods of databases, making the teaching more targeted.
The course emphasizes the hierarchical nature of knowledge and the gradual development of skills. It includes a wealth of practical examples in the chapters, hands-on computer lab exercises, and useful post-lesson exercises. The course offers 564 minutes of video content and explanations of 37 important knowledge points, making it suitable for beginners to learn the principles and applications of databases.
【Teaching Team】
Yang Chen: Associate Professor at the School of Software, Dalian University of Foreign Languages, and Director of the Network Engineering Teaching and Research Office. Her research interests include machine learning security and privacy protection, and network security. She teaches courses such as “Database Principles,” “Oracle Database Applications,” and “Computer Networks,” and has accumulated extensive practical teaching experience. She has published over thirty educational reform and academic papers and is the chief editor of textbooks such as Database Principles and Oracle Applications, Integrated Teaching and Practical Guide for Oracle Database Applications, Computer Networks, and Integrated Teaching and Practical Guide for Computer Networks.
课程目标
1. Master the basic concepts, fundamental principles, and design methods of database systems
2. Master the development methods, tools, and environments for database application systems
3. Possess strong engineering and technical abilities in analyzing, designing, coding, managing, and maintaining database application software projects
4. Possess the ability to analyze and solve problems, as well as practical operational and application innovation skills
适合人群
1. Learners with a basic understanding of relational models, SQL language, database design, and normalization theory
2. Learners interested in relational models, SQL language, database design, and normalization theory