Mastering phpMyAdmin for Effective MySQL Management

'By the end of the book, I'm left with a superb phpMyAdmin install that does a thousand times more than I've ever accomplished with the app before.'

Mastering phpMyAdmin for Effective MySQL Management

Mastering
Marc Delisle

'By the end of the book, I'm left with a superb phpMyAdmin install that does a thousand times more than I've ever accomplished with the app before.'
$23.99
$29.99
RRP $23.99
RRP $29.99
eBook
Print + eBook

Get unlimited access to this and 3,500 other courses today!

With unlimited access to a constantly growing library of over 3,500 courses, a subscription to Mapt gives you everything you need to get that next promotion or to land that dream job. Cancel anytime.

+ Collection
Free Sample

Book Details

ISBN 139781904811039
Paperback242 pages

Book Description

phpMyAdmin
Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use the 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 the 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.

Table of Contents

What You Will Learn

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.

As an application developer you'll learn how to use phpMyAdmin to:

  • Effectively perform day-to-day database and table management.
  • Create better database tables and relational structures
  • More easily document your evolving data structure

As a MySQL server administrator, you'll 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 expand and refine their knowledge of SQL in a MySQL context through using phpMyAdmin to track SQL execution and results.

Authors

Table of Contents

Book Details

ISBN 139781904811039
Paperback242 pages
Read More

Read More Reviews

Recommended for You

Mastering phpMyAdmin 3.1 for Effective MySQL Management
$ 20.99
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99