Explore the Books

MySQL Bible

About the book
With the MySQL Bible you'll learn everything you need to know to get you started with MySQL and expand upon that by examining development and best-practices for MySQl implementations.

There is a cd-rom included with the book which contains version 4.1 of MySQL as well as  files created for the book, php and phpMyAdmin and Perl DBI.

MySQL Basics for Visual Learners

This book helps non-programmers learn the basics of MySQL. As usual with books from Visibooks, many screenshots and graphics show how to:

• Administer databases: Back up, delete, restore databases, delete tables.
• Work with tables: Alter tables, update records, delete records.
• Perform queries: Create queries, sort results, add criteria.
• Secure databases: Add and remove users, restrict access.
• Web-enable databases: Use programming commands, join two tables, employ online forms.
• Administering Databases: Delete a table, Back up, delete and restore a database.

MySQL Basics For Visual Learners is a book that teaches you the very first basics of MySQL, the way of doing that is by using a great amount of images and pictures. The graphics and visualizations enable you to "scan" trough the book and zoom in to the topics you like. Although it allows you to go trough the lessons very fast, the information takes up a lot of space so your thick book (168 pages) does contain less information then a standard book format.

For who is this book? This book will teach you the very basics of MySQL, and is therefore best suited for users that make a first start with MySQL. Again, the visuals will help those to pick up methods in this program very easily.

The book covers basic topics such as Instalation, Queries, Managing Databases, Security, Tables and PERL/CGI.

Mastering phpMyAdmin for Effective MySQL Management

Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your databases.

You will learn how to:

• Administer MySQL users and privileges, and get statistics about MySQL servers and databases
• Manage databases, table data and structures, and indexes
• Use bookmarks and metadata
• Generate multiple SQL queries
• Generate better documentation of evolving table structures

Along the way you’ll build a more detailed understanding of SQL and how it works in MySQL.