Database Principles and Design Laboratory Tutorial (MySQL Edition)

This book uses the popular database management system MySQL and the database modeling tool PowerDesigner 16.5 as the operational platform. It meticulously organizes and designs 13 hands-on experiments, including the installation of MySQL, basic database operations, basic table operations, data manipulation, data querying, data integrity control, indexing, views, database security control, stored procedures and functions, transactions and locks, using PowerDesigner for database modeling, and connecting to the database with Java through JDBC. The purpose of the experiments in this book is clear, the steps are clear and operable, and the knowledge points are arranged step by step, from shallow to deep, enabling readers to effectively apply theory to practice and facilitate the consolidation of database theoretical knowledge. Each experiment is followed by a moderate amount of exercises for students to practice after class.This book can serve as a teaching book for hands-on experiments in database courses for undergraduate students majoring in Software Engineering and Computer-related disciplines in colleges and universities. It can also be used as a reference book for database administrators and developers of database application systems.