There are 19 chapters in the book, which comprehensively and systematically describe the basic principles and applications of database technology. The main contents include: database system overview, information and data model, relational algebra and relational database theory, database design method, MySQL installation and use, MySQL storage engine and database operation management, MySQL table definition and integrity constraint control, MySQL data operation management, MySQL index, MySQL view, MySQL Stored procedures and functions, MySQL triggers and event schedulers, MySQL permission management, transactions and MySQL multi-user concurrency control, MySQL database backup and restore, MySQL log management, distributed databases and MySQL applications, MySQL applications in Web development, non-relational databases - NoSQL, etc.
This book also introduces the implementation of database technology with MySQL as the background, so that readers can make full use of the MySQL platform to deeply understand the principles of database technology, and achieve the goal of closely integrating theory and practice. At the same time, it also solves the problem of operating system compatibility (32- and 64-bit computers, Windows, Linux and MAC operating systems, etc.) When readers install computer database management system software.
The content of this book is step-by-step, easy to understand, with clear concepts and strong organization. Corresponding examples are given in each chapter. In order to alleviate readers' initial confusion and confusion, this book specifically sets experimental tasks in each chapter. This book can be used as a supporting textbook for the "Database System Principles and Applications" course in related undergraduate majors. It can also be used as a reference for those taking database exams, database application system developers and designers, engineering technicians and other related personnel. For undergraduate students who are not majoring in computer science and want to learn key and practical database technologies, this book can also be used as a textbook.
Reader comments
This book is very practical! It not only systematically explained the principles and applications of databases, but also solved the compatibility issues in installing computer database management system software, which was of great help to me. The examples and experimental tasks in the book also gave me a deeper understanding of database technology in practice. Especially the part about MySQL reminds me of the data management problems when I started my own business. The solutions given in this book are very enlightening. I will recommend it to other friends in need!
This book is very practical! It not only systematically explained the principles and applications of databases, but also solved the compatibility issues in installing computer database management system software, which was of great help to me. The examples and experimental tasks in the book also gave me a deeper understanding of database technology in practice. Especially the part about MySQL reminds me of the data management problems when I started my own business. The solutions given in this book are very enlightening. I will recommend it to other friends in need!