In daily work and study, whether it is development, operation and maintenance, testing, or architect, database is an essential “required course”, but also a necessary magic tool to raise salary. Among Internet companies, MySQL is the most widely used open source database. But mysql knowledge is very wide, knowledge is also very scattered, the learning process is more tortuous, for beginners, often do not know where to start, learn database, in the end is to learn what it? For students who have a certain foundation, they may always stay in the stage of adding, deleting, changing and checking, unable to further improve. When operating and maintaining, they do not know how to handle emergencies; When developing write service SQL, I wrote a lot of statements with potential performance problems. This article recommends some paths and resources to learn about mysql. May not be the fastest way, but I believe that you certainly have certain help.
primary
For those who are just starting out with mysql, I do not recommend reading directly. Most of the books are difficult to understand and easy to discourage beginners. For this kind of students, I would like to first go through the rookie tutorial -MySQL, the tutorial directory is clear, step by step, you can follow the directory order step by step to learn.
Site B is also a good place to learn. It is recommended to learn MySQL database in one day. There are plenty of practice videos in the course. After learning, I can roughly understand the basic concepts and operations of database, table, index, add, delete, change and check, etc.
For those of you who like to read, check out “MySQL Must Know, Must Know”. This book focuses on the basics and gets you started with MySQL from scratch.
Relevant books can be obtained by following the public account [will play code] reply [PDF]
The advanced
For students who don’t want to be limited to adding, deleting, modifying and checking, I recommend reading + practice + sharing. Of course, I will also share with you a few other high quality resources that I know.
books
- Inside MySQL: InnoDB storage engine
Jiang Chengyao’s MySQL Technology Insider: InnoDB Storage Engine is my first book. This book analyzes InnoDB’s architecture, implementation principles and working mechanism from the perspective of source code in depth, and gives a lot of best practices to help you master InnoDB systematically and deeply. In addition, this is also an interview treasure book, truly understand the contents of the book, should be able to deal with most of the interview.
- High performance MySQL
The book is a classic in the field of mysql, with extensive influence, covering mysql architecture and history, benchmarking and performance profiling, database hardware and software performance optimization, replication, backup and recovery, high availability and scalability, and mysql in the cloud and mysql related tools. Each chapter is a relatively independent topic, and the reader can choose to read it on its own. Not to be missed by DBAs who want to dig deep into mysql.
Relevant books can be obtained by following the public account [will play code] reply [PDF]
Blog resources
- The official document: dev.mysql.com/doc/refman/…
- Taobao monthly report: mysql.taobao.org/monthly/
Video resources
www.bilibili.com/video/av201… This is a mysql tutorial released by a training institution on b website. It is more in-depth, and the content of the interview is also more common. If you can’t eat the book, you can have a look.
Geek time: MySQL Combat 45 lecture
First of all, this is really not dragging, and many big V’s have recommended this course, I also bought this course, read several times, every time there is a new harvest, this column content has a certain depth, but the teacher is relatively easy to understand, after-class problems fit the actual production problems. In addition, every time after reading the article, it is suggested to leave a message below, there are a lot of high-quality messages, supplement the article may be confused place.
Practice practice
This may be a part that most people lack in learning, but in fact it is very important. For example, the understanding of indexes and locks is far from enough. Reading books or videos is not enough.
In order to make it easier for you to learn, I built a mysql test instance and assigned each user a unique username and password. As long as you follow the public account [will play code], reply [mysql] to get your account password. There is no routine, it is not fictitious, the water is not deep, you can grasp it.
Write an article
This is the last point I want to say, in the learning process, we’d better form the habit of writing articles. Try to use their own logic to connect multiple knowledge points together to form a surface. It’s not easy, but understanding the knowledge after writing it will be a great help. In the past, I thought I could understand the database transaction log. Some time ago, I wanted to write a related article. When I really wrote, I didn’t know how to start. Although the article is not perfect, it does learn a lot of details that I didn’t notice before.
Write in the last
If you like this article, welcome to pay attention to the public account “will play code”, focus on plain English to share practical technology.
Welfare of public account
Mysql > get free test database!!
Reply [PDF] get continuous update massive learning materials!!