phpMyAdmin exists for you to run a MySql database via PHP commands, but also by doing so thru a web interface. In part this is because the web page paradigm is so dominant. But also because MySql for all its power is rather awkward to directly deal with, unless you are already expert in it. Yes, I know that sounds a little circular, because it certainly is. Breaking out of that rough input impedance is why this book teaches phpMyAdmin.
There are many general purpose settings that you can configure. Chapter 3 walks through the most important of these. You also need to learn the syntax of the directives that control the settings. The notation is not the most concise, but at least as evidenced by the book's examples, it can be fairly self documenting. Speaking of general settings, one of the nicest is surely the ability to pick your language. The labels and other online help have been i18n to the major languages.
But perhaps the most common administration activities you'll need relate to editing and deleting data in a table - or rather, in a subset of a table. Typically this will be in a single row. Then multiple rows. The text shows that this is straightforward. More complex tasks are possible - like changing the structure of an existing table. A common operation is to add a column and edit its attributes. Via phpMyAdmin, all this is possible.
Note that the author assumes that you are already versed in the theory of relational databases and in the syntax of SQL. Given this, you can treat the entire text as a nice GUI front end to avoid as much as possible a direct editing of SQL commands. The GUI makes it easier and less error prone.
The text also roams into ancillary topics that are not strictly SQL, but which are largely unavoidable. There is a brief walkthrough of XML, LaTex, CSV and PDF. As a database administrator, you may well run into these, when gathering input data into your MySql tables.
But perhaps the nicest features are in Chapter 12, which deals with advanced issues of multi-table queries. You can make automatic joins. And there is a visual builder tool that provides a very intuitive means of making a long query.
I am an experienced RDBMS programmer (over 25 years). Phpmyadmin (pma) is proving to be a great user interface if you do not want to write SQL statements yourself (& why would you?). I am not fully up to speed with pma yet but after 3 weeks I have easily been able to set up a Language DBase with over 15 inter-related tables with many Queries. Setting up table Relationships are easy to establish and there are many TABs for working on your DB & Tables, such as: create, browse, insert into, quiery, edit, set indexes (single & multi column), searching data and many other options not yet fully discovered. I have 3 small issues though! 1. This book is not up to date. The latest release of pma appears to be much more facilated than the book but I believe there are online updates available from the author's website not yet investigated 2. You would really need to be fairly experienced in database management to get along with this book. 3. There are many new abbreviations in this book, so a separate section on these would be good in any new edition. Finally, a 4 star rating is fair at this point in time but could be a 5 star rating by the time I get to the last page. 3. Happy reading😃
A fairly comprehensive book for someone who has a reasonable grasp of the concepts prior to reading it. Misses out lots of items, the main one , which is what I bought it for is Views, which hardly get a mention. Could do with an update, as it does not deal with the changes in the latest versions of either item. Not for the beginner.
This book is really a good read. First off all, it will guide your through all the odds and ends of phpMyAdmin. In case you have never ever worked with this tool before, there is no better place to start.
Marc shows various aspects of phpMyAdmin basing his book on a tutorial like convention. All you have to do is to understand what he says, and follow his steps. This way, after reading the book, you will have your own copy of phpMyAdmin ready to go. As this book is an easy to follow by beginners it may be slightly boring for advanced phpMyAdmin admins who are looking for phpMyAdmin reference.
I am giving five here, even though I would expect more condensed content. However, this book is advertised (at the cover) as book for beginners. It is exactly as cover says - the book is an easy, gentle, and comprehensive introduction to phpMyAdmin.