Do you have a recommended database book list? For MySQL and Oracle, thank you.

Reader Kitty asked me the above question in a private letter, and I think it’s typical enough to write an article about it. Because it is almost inevitable for Java programmers to work with databases, MySQL and Oracle happen to be the two most widely used databases.

MySQL and Oracle, both relational databases, are now owned by Oracle, a company that makes great products and whose CEO, Larry Elson, is a great friend of Steve Jobs. Oracle is more of an enterprise application than MySQL. MySQL, on the other hand, is open source and has strong performance, so in recent years it has surged to number one in market share, two blocks ahead of Oracle.

(I seldom use Oracle, so THIS article will focus on MySQL. If you have a thorough understanding of Oracle, please recommend it in the comments area. Thanks.)

Well, next on the book list, I hope friends can like, like, collect, let it eat ash. No, no, no. If you like it, buy a couple of them and read them.

The first book, SQL Will know will know

SQL is a Structured Query Language. There are often some friends who complain, “Brother, what I do in the company is nothing but CURD’s work, and I feel no progress.” CURD in this sentence refers to the business operations related to Create, Update, read and Delete, i.e., the scope of SQL.

But to put it bluntly, no matter how great a product is, its business is always about adding, deleting, changing, and checking.

“SQL must know must know” this book is worthy of the name, can in the shortest time to teach you the most commonly used and most necessary SQL knowledge in the actual work environment, practical extremely strong. This book is used as a reference at MIT, the University of Illinois, and many other universities.

Second, “SQL Learning Guide”

With a small animal on the cover and the “O ‘Reilly” logo, it’s safe to conclude that this is a classic.

SQL Learning Guide (Revised 2nd Edition) this book is based on the SQL92 standard and covers MySQL 6.0 and Oracle 11g. This paper systematically introduces the basic knowledge of SQL language and some advanced features, including SQL data language, SQL schema language, data set operation, sub-query and built-in function and conditional logic.

Regular contact with the database of beginners can always be in the side, use to turn over.

MySQL must Know must Know

Sams Teach Yourself MySQL in 10 Minutes is the original English title of this book. However, the Chinese name is much more elegant.

This book is perfect for beginners who want a quick understanding of database principles and MySQL. It’s fast food, it’s crisp, it’s small, it’s thin, it’s kind of like the Great Gatsby, it’s smooth.

4. Concept of Database System

Wow, here comes the black book! Black books have only one fault, which is that they are boring, but to be honest, black books are fucking classics. Suit quiet undergraduate to read especially, anyway university life besides fall in love outside the most important (hey hey), I feel left study.

A masterpiece in the database field; It is necessary to consolidate the theoretical foundation of database and strengthen the internal work of database technology. For in-depth understanding of the database, in-depth research database, in-depth operation database has a strong guiding role!

In short, there is time to read, really sweet on the right.

InnoDB Storage Engine Edition 2

As we all know, MySQL has two common storage engines, one is MyISAM and the other is InnoDB. Select InnoDB if you need transaction support, or MyISAM if a table is mostly used for reading. InnoDB has been the default engine for MySQL since MySQL 5.5, which means its advantages are obvious.

The book “Inside MySQL Technology :InnoDB Storage Engine (Edition 2)” is an in-depth analysis of InnoDB’s architecture, implementation principles, and working mechanism from the perspective of source code. It also gives a lot of best practices, which can help you to systematically and deeply grasp InnoDB. More importantly, It can give you an excellent guide to designing high performance, high availability database systems.

High Performance MySQL (Version 3)

The cover of this book is a little familiar, and the style is highly similar to the “SQL Learning Guide” recommended before, right? The book is so well known, it’s like the Jay Chou of MySQL, and almost any developer who wants to learn MySQL has to buy it.

I’ve been going through this book in my house, to be honest. The book is very informative, covering almost all aspects of MySQL:

  • The first two chapters are preparatory and cover some basic concepts and performance measurement tools.
  • Chapter 3 to Chapter 7 is the optimization part, from architecture, index, query statement, parameter configuration, software and hardware optimization.
  • Chapters 8 to 14 cover service management and maintenance, covering replication, backup, security and other content and related tools.

High Availability MySQL (Version 2)

Highly Available MySQL: Building a Robust Data Center is a book that explains how to use MySQL’s replication, clustering, and monitoring features in a real-world environment and reveals all aspects of MySQL’s reliability and high availability. It aims to solve the common application bottleneck of MySQL database, and explore various potential solutions to improve performance under the premise of maintaining the continuous availability of MySQL.

This book is suitable for MySQL professionals, otherwise difficult to navigate.

8. Oracle Efficient Design

I can’t help it. Although I don’t use Oracle very much, I have heard some classic books. Highly Effective Oracle Design by Thomas Kyte, one of the world’s foremost experts on Oracle’s expertise and the vice chair of the Oracle Core Technology Group, is a well-reviewed book.

This book is a comprehensive and in-depth explanation of Oracle and database knowledge. It is an advanced manual about Oracle. The content includes: performance toolkit, architecture selection, statement processing, troubleshooting, efficient management, efficient design patterns, efficient PL/SQL programming, etc.

All right, that’s it, guys. I think I’ve got eight books that I can read for a while. Next, I would like to share some of my reading methods. I think this value may be more valuable than the book list itself, and I hope to give some reference to my friends.

1) speed reading

Like introductory books, to be over in the shortest time, such as “SQL will know will”, do not feel that speed read again what also can not remember, it does not matter, its brain capacity is limited. The purpose of speed reading is simple: to get an outline of a book, and to find out if there is anything that fascinates you.

Or if there is any content you do not understand, mark it, and then read it again as a reminder.

2) intensive reading

Is the foundation of speed reading, read it again, you will feel completely different, as if you go to a place to travel, always do a little round, first thought on the map, really in a place, you won’t be dizzy, or have a, “oh, that is like” feeling.

3) the actual combat

The most afraid of reading is to have high eyes and low hands, you think you remember, understand, if you do not start to take notes or knock on the code to combat, basically equal to did not read, because you are reading a technical book, not a philosophy book, right?

It’s not enough just to think with your head. You need your hands to knock, run, execute, and see if the results are in line with expectations and if there are mistakes.

These three steps down, a book will no longer worry about “read and not read the same”, friends have got to?

I am silent King 2, an interesting programmer. If you find this article helpful, please search “Silent King ii” on wechat and read it for the first time.

Interview on GitHub

Original is not easy, do not want a free ticket, please point a praise for this article, it will be the strongest power FOR me to write more high-quality articles.