Mysql learning plan recommended for novices

Recommended for novices mysql Learning plan

If novices want to start learning mysql, here is a suggestion for the novices, which will help to systematize their learning.

Learning steps:

1. Download and install. Familiar with mysql configuration files and directory structure.

2. Mysql startup, login and exit, common commands and syntax specifications of mysql.

3. Mysql data type and operation data table, table addition, deletion, modification and query. Subquery, join table query, inner join, outer join (left outer, right outer).

4. Be familiar with MySQL operators and functions, date functions, time functions, information functions, aggregate functions, encryption functions, custom functions, and permission management.

5. Be familiar with the stored procedures of mysql and the calling of stored procedures.

6. Be familiar with the characteristics of each storage engine of mysql.

7. Master at least one mysql graphical management tool. (phpMyAdmin, Navicat, MySQL Workbench, etc.)

Thank you everyone for reading, I hope you will benefit a lot.

This article is reproduced from: https://blog.csdn.net/wang740209668/article/details/50099383

Recommended tutorial: "MySQL Tutorial"

The above is the detailed content of Mysql learning plan recommended for novices. For more information, please follow other related articles on the PHP Chinese website!