Especially suited to students, the fourth edition of this book introduces SQL through MySQL, the most popular open-source database management system. Readers will learn how to declare, manipulate, evolve, and query tables with their various characteristics and associated elements (integrity and verification constraints, indexes, sequences, and views). They will be introduced to all the concepts of MySQL's procedural language (variables, control structures, etc.).
Especially suited to students, the fourth edition of this book introduces SQL through MySQL, the most popular open-source database management system. Readers will learn how to declare, manipulate, evolve, and query tables with their various characteristics and associated elements (integrity and verification constraints, indexes, sequences, and views). They will be introduced to all the concepts of MySQL's procedural language (variables, control structures, database interactions, subroutines, cursors, transactions, exception handling, triggers, and dynamic SQL). This book also explains how to use a MySQL database by programming with Java (JDBC) or PHP. This edition includes the features of the production version 5.6 of MySQL: XML handling, signals, and events. Query optimization is also covered in detail: how the optimizer works, the use of statistics, and execution plans. Each important concept is introduced with a simple and educational example, and each chapter concludes with a series of exercises (with answers available online) that will allow the reader to test their knowledge.
