MySQL Primer books and Ways to share

Source: Internet
Author: User

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:

    1. 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.
    2. 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
    3. "SQL Application Refactoring"
    4. 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:

    1. 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.
    2. "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.
    3. 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.

    1. 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&
    2. MySQL Planet covers almost all of the blog RSS feeds from the MySQL industry Daniel. Subscription is highly recommended!
    3. 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:

    1. 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.
    2. "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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.