Chapter 1:"Introduction to MySQL"
This Chapter introduces some important concepts of RDBMS, It explains in general lines the side of client-server application of MySQL. The important concepts of DDL, DML, DCL are also explained...
Chapter 2:"Relational Database Principles"
It explains the reason of using a Database and not text files or spreadsheets. It starts the design of the example database that will grow through the book. It explains also some important rules about the relation between the tables. And it gives you the basic types of MySQL. And explains the meaning of a NULL value on a Database and how to test it.
Chapter 3:"Installing and Getting Started with MySQL"
This chapter gives you the ways that you can use to install MySQL, from source, from binaries. The installation is explained in a Linux system and Windows.
Chapter 4:"Accessing Your Data"
As the name says it covers some methods to access the data stored on the database. You will learn to use mysql command line tool. The SELECT SQL command is very well explained, for example ordering the selection of your data, performing calculations with the same, or even performing restricted selections with the clause WHERE. The joins of the tables were not forgotten.
Chapter 5:"MySQL Graphical Tools"
This chapter, we could say that it is an extension of the 4th chapter. However this one is not concerned about the Selection of Data, but it concerns in a detailed way the tools you can use to access Data. It covers the command line of MySQL (and include quick references of the command line options, and the internal commands). You will learn also, to create your scripts and process it on a batch mode. But for those who hate command line tools the GUI tools are also reviewed, like KSql KMySQL, MySQLGUI and for the window clients the ODBC, a connection through Access and Excel.
Chapter 6:"Changing your Data"
This Chapter will teach how to populate your database using the INSERT SQL command, having in mind NULL values, values with auto_increment (filled automatically when adding new records). But it talks about something very specific of MySQL, the command LOAD DATA, with which you will be able to import data from your text files (assuming that the fields are separated by a character such as a ','). With a similar function of the last one you will be teached the command mysqlimport. The UPDATE and DELETE commands are also focused...
Chapter 7:"Advanced Data Selection"
You've already a chapter dedicated to the selection of data, however this one brings to you other features of the SQL, like the use of functions (e.g. SUM, AVG, MIN, MAX, COUNT). The concept of grouping data when selecting the same is also exposed. The joins you can perform with the SELECT are also treated (e.g. the UNION Join, the SELF Join, the Outer Join). And probably, a thing that you might appreciate when dealing with complex data selection is the Subqueries...
Chapter 8:"Data Definition and Manipulation"
I've found this chapter very important to me, so I advice you to read it carefully, the ideas here are very but very important. The concepts behind the creation of a table, the kinds of tables that MySQL supports, and each one is the best for your needs. The cautions you must make when converting values. But I think the most important is the explanation given to the kind of fields. Exemplifying the difference between CHAR and VARCHAR, between SMALLINT and INT, between DATE and TIME, and so on...
Chapter 9:"Transactions and Locking"
In the last chapter the things started to warm a little, here they get very deep, introducing the concept of multi-user use of a given database, this is here a transaction gets in. So commands like COMMIT or ROLLBACK gets in scene. The locking is also well explained and exemplified. The locking, as you will see, will depend on the kind of table you have chosen. Commands like LOCK, UNLOCK, will start to be familiar to you.
Chapter 10:"MySQL Administration"
Here the administrators will find all the necessary skills to start learning the administration of MySQL, like stopping and starting the database server, configuring users and their privileges. The server logs, the control files (files that have the configuration of the server, of the clients) are also introduced as well as recovering corrupted data.
Chapter 11:"Database Design"
This chapter has with it important concepts that you must have always in mind when building databases. It gives you concepts like the entities and their relation with tables, the relations and the cardinality of them are also reviewed, exemplified with the relationship diagrams.
Chapter 12:"Accessing MySQL from C and C++"
You will learn what library you must include, what the functions they provide. The code is well explained and easy to follow (for the C programmers).
Chapter 13:"Accessing MySQL from PHP"
This chapter covers the configuration of PHP to use MySQL as well as the respective programming.
Chapter 14:"Accessing MySQL from Perl"
As the last one, this starts with the installation of the DBI modules of Perl, the conventions used, and the respective programming to select data, insert data from and into to the database.
Chapter 15:"Accessing MySQL from Java"
This chapter covers the installation of the JDBC driver, and the code you must edit to perform the operations you need on your database.
Chapter 16:"Further information and Resources"
This last ones provides a list of resources you might find useful.