About This Course

Mysql is the most popular open source database in the world, and we choose it as the teaching database.MySQL, together with other open source softwares Apache and PHP, forms a golden development environment adhering to the spirit of "GUN".MYSQL can be used for Web database development with broad application prospects.

Through the study of this course, you can quickly learn to put knowledge into practice, and you，a learner now, will soon become a developer.Through the study of this course, you will fully understand the principle of relational database and build the database that you need.With MySQL, we can abstract the objective world as a data model, and then develop into a system that can run on a computer.It is hardly no distance between the information at your fingertips and the torrent of data in the cloud, between the spark of your thoughts and wisdom of interconnecting everything.

Requirements

Fundamentals of College Computer

Course Staff

Zhao Xiaoxia

Zhao Xiaoxia, female, born in 1965, professor, master tutor, is now faculty of Kunming University of Science and Technology.The main courses she teaches include “Visual FoxPro Database Programming”, “MySQL Database Technology and Application”, “University Computer Basics”, and “Webpage Design courses”.

Fu Xiangqiong

Fu Xiangqiong, Teacher and Associate Professor of Computing Center of Kunming University of Science and Technology.In July 2000,graduated from the Nonferrous Metallurgy Department of Kunming University of Science and Technology with a bachelor's degree.In May 2003,graduated from the school of information automation, Kunming University of science and technology with a master's degree in computer science.With 17 years of teaching experience in universities,the main courses are "University Computer Foundation","University Computer Foundation(bilingual)","Programming in c language","Programming in c language(bilingual)","Programming in Java language","Computer network","Computer network (bilingual)","Special English for Computer Science","Dynamic web design","Web Design","Multimedia technology and Application","Network security","Network architect training","Network engineer training","Linux operating system",etc.Presided over and participated in a number of national, provincial and university level projects, presided over a number of university enterprise cooperation projects.Published 7 papers, edited and participated in the compilation of 10 textbooks with more than 300,000 words.Won the science and technology award of the Ministry of railways, provincial science and technology award, provincial and university level teaching awards, etc.

Pan Shengmin

Pan Shengmin, professor of Kunming University of Science and Technology, Vice Chairman of Youth Education Branch of National University Computer Education Research Association. Teaching multiple courses such as "C Language Programming", "WEB Database Design", "Network Information Security", and "MySQL Database Design". In recent years, he has published more than 40 papers and has led and participated in over 20 scientific research and educational reform projects. As the editor in chief, I have published 1 scientific monograph and 11 textbooks. As an editor, I have published 17 textbooks. He has won the first prize of teaching achievement of Kunming University of Science and Technology, the famous teacher of Kunming University of Science and Technology and many other awards.

Zheng Fahong

Zheng Fahong, male, born in 1973, associate professor of Kunming University of Science and Technology.He teaches “C Programming”, “University Computer Basics”, “Visual Basic Programming”, “Visual FoxPro Programming”, and “MySQL Database Technology and Application”.

Du Wenfang

Du Wenfang, a faculty member at Kunming University of Science and Technology. He teaches “University Computer Basics”, “C Language Programming”, “Database Design” and “Multimedia Technology and Application”. Main research directions: multimedia technology, database.

Liu Lingbing

Liu Lingbing, male, born in 1981, with master’s degree in computer software and theory, is working in the Computing Center of Kunming University of Science and Technology as lecturer.Over the past 10 years, he has taught many courses in programming, database, computer network and so on. He mainly focuses on software system architecture and software development technology. He has got the qualification certificate as system analyst, and accumulated rich experience in information system development.

Hao Xi

Hao Xi, female, born in 1979, Master of Engineering in Computer Software and Theory, lecturer of Kunming University of Science and Technology.She teaches “C Language Programming”, “MySQL Database Technology and Application” and “University Computer”.

Ma Xiaojing

Ma Xiaojing, female, born in 1977, a lecturer at Kunming University of Science and Technology.She teaches “C language programming”, “Python language programming”, and “University Computer”.

Kou Weili

Kou Weili, professor, PhD and PhD supervisor. a faculty member of Southwest Forestry University. He visited the University of Oklahoma in the United States. Expert of correspondence evaluation of National Natural Science Foundation of China. Reviewer of multiple SCI journals such as International Journal of Remote Sensing, GIScience & Remote Sensing, Advances in Space Research.

Zhang Lin

Zhang Lin, male, graduated from Kunming University of Science and Technology in 1991, Master of Engineering in industrial electrical automation, a faculty member of the School of Electrical and Information Engineering, Jinqiao College, Kunming University of Science and Technology. He has worked in enterprises for nearly 20 years, engaged in the construction of enterprise information systems, and has been a full-time teacher for more than 8 years, mainly teaching courses in information processing technology, information system development, software project management, and computer networks.

Zhang Chunhong

Zhang Chunhong, female, born in 1977, associate professor, is now teaching in the School of Information Engineering department, faculty of Arts and Sciences, Yunnan Normal University.She has engaged in computer teaching and basic computer teaching for more than ten years.Her main research direction is computer application, education and teaching evaluation.

Li Jufang

Li Jufang, female, born in 1987, graduate degree, a teacher and lecturer of City College of Science and Technology, Chongqing University.She teaches “Database Principles”, “Object-oriented Programming”, “NoSQL Database Technology”, and “Python Programming”.

Zhang Jun

Zhang Jun, male, born in 1990, teaching assistant, faculty of Yuxi Normal University, Yunnan Province.The main courses he teaches include “Object Oriented Programming”, “Data Structure”, “MySQL Database Design and Application”.

Question

Q: What is a database?
A: A database is a structured collection of data that is organized and stored in a way that allows for efficient retrieval, manipulation, and management.

Q: What are the different types of databases?
A: There are various types of databases, including relational databases, NoSQL databases, object-oriented databases, hierarchical databases, and more.

Q: What is a relational database?
A: A relational database is a type of database that organizes data into tables with predefined relationships between them. It uses structured query language (SQL) for data retrieval and manipulation.

Q: What is SQL?
A: SQL (Structured Query Language) is a programming language used for managing and manipulating relational databases. It allows users to query, insert, update, and delete data from a database.

Q: What is normalization in database design?
A: Normalization is the process of organizing data in a database to minimize redundancy and ensure data integrity. It involves breaking data into logical tables and establishing relationships between them.

Q: What is MySQL?
A: MySQL is an open-source relational database management system (RDBMS) that is widely used for storing and managing structured data.

Q: How do I install MySQL?
A: You can download and install MySQL from the official MySQL website. They provide installation packages for various operating systems.

Q: What programming languages can I use with MySQL?
A: MySQL can be used with several programming languages, including but not limited to PHP, Python, Java, and C#. It provides APIs and connectors for seamless integration.