This article lists some of the books that are available for MySQL and OPS entry and advanced use.
Background: There are always many students in the forum who want to learn the database, or to do some preparation for the DBA. Over the years as a MySQL DBA grew up with some accumulation and sentiment, hereby take it out and share it with you.
Getting started with SQL
It is necessary to be proficient in writing SQL before you are ready to become a MySQL DBA. Equivalent conversions between exists and joins, basic row-and-column conversions, and the mastery of SQL loops can be very helpful for subsequent operations and tuning efforts.
Recommended Books:
- SQL Cookbook a progressive SQL guide. Every business requirement, the book uses mysql,sql server,oracle three kinds of grammar to parse. Can be ordered as a learning book, or later as a tool book review.
- The ART of SQL simulates SQL tuning into a battle for tactical analysis. More is to teach the SQL architecture design knowledge, the actual tuning instance is not many, translation sucks, suggest to see the original
- "SQL Application Refactoring"
- MySQL Stored Procedure programming learns the MySQL stored procedure syntax and the best textbook written. Although the version is older, but most of the syntax has not changed, more recommended.
MySQL Getting Started & proficient
If you have mastered the basic SQL writing skills, you can go to the MySQL product itself to get started learning
Recommended Books:
- The High Performance MySQL | MySQL, a high-performance MySQL Bible, is now in its third edition. The various parts of MySQL operations are described in great detail and can be read through and read as reference books.
- "Easy to use MySQL database development, optimization and management Maintenance" Chinese original books are more suitable for a primer. This paper introduces the related features of MySQL more superficially, and is more suitable for MySQL operation and maintenance.
- MySQL Technology insider: InnoDB Storage engine analyzes the internal structure of INNODB in detail from the code level, and is suitable for in-depth learning InnoDB.
Other Learning Resources
MySQL Beginners In addition to learning theoretical knowledge through books, there are a variety of other ways to learn.
- Our episode, a program similar to MySQL radio, periodically gives an audio discussion on a MySQL topic every week. is a good choice to learn English mysql&
- MySQL Planet covers almost all of the blog RSS feeds from the MySQL industry Daniel. Subscription is highly recommended!
- MOOC all kinds of public courses website will have free MySQL introductory course audition. This is not an exhaustive list.
Operations & Data Ideas
Recommended Books:
- The Art of Capacity planning | The art of capacity planning as an operational dimension inevitably involves capacity planning and capacity forecasting. This book is a good start.
- "Beautiful data:the Stories Behind Elegant Data Solutions" database operation is an important trait in the sensitivity of the information.
From:jobbole
MySQL Primer books and Ways to share
