"MySQL: Beginner's Starter Series"

Database-related knowledge is almost an essential skill for Internet practitioners to escape, especially for db, DA, Dev and test children's shoes.

For MySQL, the following books are recommended:

Entry level: "MySQL must Know"

Into the class: "High-performance MySQL", "in layman's MySQL"

In-depth knowledge: official documentation

In order to facilitate my own and everyone to read my notes, the following will be my personal study of MySQL and related content of the blog content, also considered an index, directory ...

1. Basic Introduction

2. Data retrieval and filtering

3. Search with regular expressions

4. Fields and Common functions

5. Summarize and group data

6. Common syntax and data types

7. Junction table

8, sub-query and group query

9. Inserting, updating and deleting

10, Operation table and full-text search

11. Views and stored Procedures

12. Cursors and Triggers

13. Transaction processing and Character set

14. Management Maintenance and performance optimization

15, MySQL performance tuning of 10 methods

16, SQL statement Daquan

As the company is mainly MySQL-based, so the focus of learning is MySQL, but for the entry is sufficient, whether it is DB2, SQL Server, Oracle or other relational database,

The basic principle and most of the operation of the statement are common, of course, some of the content slightly somewhat, but also is normal ...

Knowledge is only meaningful if it is translated into actual value output ...

"MySQL: Beginner's Starter Series"