MySQL getting started books and methods _ MySQL

MySQL getting started books and methods sharing bitsCN.com

On chinaunix, there are always a lot of students who want to learn about the database or prepare for the DBA. As a MySQL DBA, I have accumulated some experience and insights over the past few years. I would like to share this with you.

SQL entry

Before preparing to become a MySQL DBA, it is necessary to be proficient in writing SQL statements. Equivalent conversions between exists and join, basic row-column conversions, SQL loops, and other skills are of great help for subsequent O & M and optimization.

Recommended books:

1. SQL Cookbook[Original download] [Chinese version download]

A step-by-step SQL instruction manual. MySQL, SQL Server, and Oracle syntaxes are used for parsing each business requirement.

It can be used as a learning book in sequence or as a tool book later.

2. The Art of SQL[Original download] [Chinese version purchase]

Optimize SQL statements into a battle for tactical analysis. It is more about teaching the knowledge of SQL architecture design. there are not many tuning instances in practice, and the translation is poor. we recommend that you check the original version.

3. OReilly. MySQL. Stored. Procedure. Programming. Mar.2006.chm

Learn MySQL stored procedure syntax and the best textbooks. Although the version is old, most of the syntaxes have not been changed. it is recommended.

4. SQL application reconstruction[Original download]

MySQL beginners & proficient

If you have mastered the basic SQL writing skills, you can get started with the MySQL product.

Recommended books:

1. High Performance MySQL []

I have provided a detailed description of each part of MySQL O & M, which can be read or used as a tool book.

2. For more information, see MySQL database development, optimization, management, and maintenance. []

I briefly introduced the related features of MySQL, which is suitable for MySQL O & M entry.

3. MySQL Technology Insider innodb storage engine []

Detailed analysis of the internal structure of Innodb from the code level, suitable for in-depth study of innodb

O & M & Data ideas

Recommended books:

1. The Art of Capacity Planning []

Capacity planning and capacity prediction are inevitable for O & M. This book is a good start.

2. Beautiful Data: The Stories Behind Elegant Data Solutions []

Database O & M is sensitive to data.

BitsCN.com