The book, MySQL: The Complete Reference, provides a complete and detailed picture of MySQL and the developments that have taken place in the recent years. This also provides expert commentary on the resources and features such as disaster recovery, transactional integrity, mobile phone support, scalability and other client and server programming. The book is divided into four parts. The first part largely deals with the installation process. These chapters introduce the databases and provide a technical summary of MySQL. There is also a chapter on the configuration and installation of the software. The second part deals with the usage of MySQL and contains chapters that provide information about the basics, data types, functions, and operators. It also deals with working with databases and tables, joins, sub queries and transactions. The third part deals with administration, where users learn about the access control, security and privileges. There are also chapters on administration and configuration, maintenance, backup and recovery, and performance optimization. One will also learn about MySQL replication in the book. The last part deals with development and includes the C language, APIs, Perl and PHP. MySQL: The Complete Reference is highly useful for database administrators and developers. It provides a systematic coverage of all software installation and configuration. Students can also practice SQL and create MySQL based applications with the help of this book. It contains both theoretical and practical examples. The salient features of this text include instructions provided for Windows, UNIX and Linux, use of different data types, managing data, using transactional support, and creating applications with the latest version of MySQL.

More Details about Mysql: The Complete Reference

General Information  
PublisherMcGraw Hill
Publish YearJanuary 2014