Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Mastering Phpmyadmin for Effective MySQL Management 2e [Paperback]

Marc Delisle

Price: CDN$ 38.39 & FREE Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 2 to 5 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.
Join Amazon Student in Canada


Book Description

Oct. 10 2006
This book is an upgrade to phpMyAdmin Version 2.8. Written by a member of the development team, this book serves as a comprehensive guide to helping you unlock the full potential of phpMyAdmin 3.8 phpMyAdmin Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool. MySQL Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, this popularity has also been helped by the existence of phpMyAdmin, the industry standard administration tool that makes database management easy for both the experienced developer and their novice. The powerful graphical interface that it provides to MySQL has made phpMyAdmin an indispensable tool for MySQL and web developers. Every phpMyAdmin user can benefit from unlocking the full potential of this powerful application. 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 will build a more detailed understanding of SQL and how it works in MySQL. As an application developer you'll learn how to use phpMyAdmin to: - Effectively perform day-to-day database and table management. - Create efficient database tables and relational structures - Document your evolving data structure easily As a MySQL server administrator, you will benefit from the in-depth and practical coverage of: - Using phpMyAdmin to manage users and privileges - Getting server and database statistics All database users will be able to expand and refine their knowledge of SQL in a MySQL context by using phpMyAdmin to track SQL execution and results. The prior edition of this book was written for version 2.6. Most of the changes to phpMyAdmin in version 3.8 are in the user interface and not the underlying functionality. This book brings the screen shots and user instructions into line with the new interface. If as a reader you are happy with the new interface already you don't need to upgrade to this new edition of the book. The book begins with a comprehensive tutorial of phpMyAdmin that systematically explains and demonstrates the potential of this tool. It then goes on to show the less well known and generally under-used features and capabilities of phpMyAdmin in depth. Whether you are an experienced developer, system administrator, web designer or new to MySQL, phpMyAdmin is a must have tool for anyone who needs to manage MySQL databases and tables. This book is a must read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

Product Details

  • Paperback: 250 pages
  • Publisher: Packt Publishing; 2nd Revised edition edition (Oct. 10 2006)
  • Language: English
  • ISBN-10: 1847191606
  • ISBN-13: 978-1847191601
  • Product Dimensions: 23.5 x 19.2 x 1.8 cm
  • Shipping Weight: 499 g
  • Amazon Bestsellers Rank: #2,144,611 in Books (See Top 100 in Books)

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  3 reviews
6 of 7 people found the following review helpful
5.0 out of 5 stars How to Use phpMyAdmin Nov. 16 2006
By Diane Cipollo - Published on Amazon.com
Format:Paperback
The purpose of this book by Marc Delisle is to teach you how to use phpMyAdmin, which is a popular open source program for working with a MySQL database using the phpMyAdmin user-friendly graphic interface. Most PHP programmers use MySQL for their database needs because these two technologies work so well together. For those who have not yet worked with phpMyAdmin and MySQL, this book will help you get up and running quickly. And for those programmers who have taught themselves to use phpMyAdmin by trial and error, this book will introduce and explain those features you may have missed.

The author begins with an introduction to phpMyAdmin. He covers the main features and some history of the program. After that, he jumps right in to the installation, configuration and security issues for the Linux, Apache and IIS servers. Of course, if you are using phpMyAdmin with your web host account, you may not have much control over these issues. Once the program is installed, he explains the user interface and discusses those easy-to-use features that make this program so popular.

Delisle starts with the basic tasks such as creating databases and setting up tables. He explains the different types of data, table fields and the various choices you have when performing many tasks. Next, he shows you how to move tables between databases and how to backup, copy and move databases between servers. Although the user-friendly graphic interface is what makes phpMyAdmin so nice, you may at some time need to use the SQL commands alone. The author covers the most common tasks you may encounter. Finally, he moves on to more advanced issues such as administrative tasks and generating database reports and documentation.

Marc Delisle is a developer and project administrator for the phpMyAdmin project. He also teaches at the College de Sherbrooke, Quebec, Canada.
2 of 2 people found the following review helpful
5.0 out of 5 stars Great book! May 13 2007
By Dorothy Hesson - Published on Amazon.com
Format:Paperback
If you don't like command-line interface with your computer, phpMyAdmin is a great tool! And if you want to learn the right way to interact with phpMyAdmin, this book is your perfect resource!

I stumbled upon a phpMyAdmin screencast by DeLisle at a conference. His calm and collected presentation style along with a great clarity for instruction is repeated in this book.

Mastering phpMyAdmin has enabled me to move out of my limited comfort zone with database management in general. The book is clearly laid out to give you step-by-step instructions to make a database work for you.

I highly recommend this book, and DeLisle's Creating your MySQL Database: Practical Design Tips and Techniques as well. They are great books!
1 of 1 people found the following review helpful
5.0 out of 5 stars A nice update Jan. 20 2007
By Rene - Published on Amazon.com
Format:Paperback
I've got a review copy of the phpMyAdmin 2.8 book as well as the previous edition of this book. The old edition already was rather comprehensive and had all the features that phpMyAdmin has cleary laid out.

Still, the layout of the new edition improved a notch, this is a nice update. While you probably won't need the book if you already have the old edition, it is a nice book to help you get out the most of phpMyAdmin.

Look for similar items by category


Feedback