MySQL introductory books and method sharing

This article lists some books suitable for entry and advanced use of MySQL and operation and maintenance.

Background: There are always many students on major forums asking about learning databases, or preparing to join the DBA industry. Over the past few years, I have gained some accumulation and insights on my growth as a MySQL DBA, and I would like to share them with you.

Getting started with SQL

Before preparing to become a MySQL DBA, being able to write SQL proficiently is a necessary condition. Equivalent conversion between exists and join; basic row-column conversion; proficiency in SQL loops, etc. will be of great help to subsequent operation, maintenance and tuning work.

Recommended books:

1. SQL Cookbook A step-by-step SQL instruction manual. Each business requirement is analyzed in the book using three syntaxes: MySQL, SQL Server, and Oracle. It can be used as a study book sequentially or as a reference book later.

2. 
   

3. The Art of SQL Simulate SQL tuning into a battle and conduct tactical analysis. It is more about imparting knowledge on SQL architecture design. There are not many actual tuning examples, and the translation is terrible. It is recommended to read the original version

4. 
   

5. ##

   SQL Application Refactoring

6. 
   

7. MySQL Stored Procedure Programming The best textbook to learn MySQL stored procedure syntax and writing. Although the version is older, most of the syntax has not changed, so it is recommended.

---

MySQL Getting Started & Proficient

If you have mastered basic SQL writing skills, you can start learning about the MySQL product itself

Recommended books:

1. High Performance MySQL The Bible of the MySQL world has now reached its third edition. It introduces various parts of MySQL operation and maintenance in great detail. You can read it thoroughly or refer to it as a reference book.

2. 
   

3. In-depth introduction to MySQL database development, optimization, management and maintenance One of the original Chinese books that is more suitable for getting started. The tutorial briefly introduces the related features of MySQL, which is more suitable for getting started with MySQL operation and maintenance.

4. 
   

5. MySQL Technology Insider innodb Storage Engine A very detailed analysis of the internal structure of Innodb from the code level, suitable for in-depth study of Innodb.

---

Other learning resources

In addition to learning theoretical knowledge through books, there are various other ways to learn MySQL.

1. Our Episode A program similar to MySQL Radio, there will be an audio discussion on a MySQL topic regularly every week. It is a good choice for learning MySQL & learning English

2. 
   

3. MySQL Planet Covers almost all blog RSS summaries of the big guys in the MySQL industry. Highly recommended to subscribe!

4. 
   

5. MOOC various public course websites will have free MySQL introductory course trials. I won’t list them all here.

---

Operation & data thinking

Recommended books:

1. The Art of Capacity Planning As an operation and maintenance person, it is inevitable to do capacity planning and capacity forecasting. This book is a great start.

2. 
   

3. Beautiful Data: The Stories Behind Elegant Data Solutions Data sensitivity in database operation and maintenance is an important characteristic.

The above is the detailed content of MySQL introductory books and method sharing. For more information, please follow other related articles on the PHP Chinese website!