MySQL Primer books and Ways to share

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:

1. SQL Cookbook [ORIGINAL DOWNLOAD] [Chinese version download]

A progressive SQL instruction manual. 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.

2. The Art of SQL [ORIGINAL DOWNLOAD] [Chinese version purchase]

Simulate 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

3. Oreilly.mysql.stored.procedure.programming.mar.2006.chm

Learn the MySQL stored procedure syntax and write the best textbooks. Although the version is older, but most of the syntax has not changed, more recommended.

4. SQL Application refactoring [ORIGINAL DOWNLOAD]

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:

1. High performance MySQL []

The various parts of MySQL operations are described in great detail and can be read through and read as reference books.

2. mysql database development, optimization and management maintenance []

Teaches a superficial introduction of MySQL related features, more suitable for MySQL operations to get started

3. mysql Technology insider InnoDB storage Engine []

The internal structure of InnoDB is analyzed in detail from the code level, which is suitable for in-depth learning InnoDB

Other resources:

1. Our episode link address

A program similar to MySQL radio, which periodically gives an audio discussion on a MySQL topic every week.

A good choice for learning MySQL & learning English

Operations & Data Ideas

Recommended Books:

1. The Art of capacity planning []

As an operational dimension, capacity planning and capacity forecasting are unavoidable. This book is a good start.

2. Beautiful data:the Stories Behind elegant Data Solutions []

Database operation and data sensitivity is an important trait.

Source: http://www.cnblogs.com/cenalulu/archive/2012/11/12/2483099.html

MySQL Primer books and Ways to share