Category: Uncategorized

Drawing in Visio:flow charts

Generally speaking, if you want to draw flow charts, you will first think of Visio, because of its excellent performance in drawing flow charts.Here we mainly introduce the main use of flow chart. Basic flow charts: Used to create flow charts, sequence diagrams, information tracing diagrams, process planning diagrams, and structure prediction diagrams, including shapes,… Continue reading Drawing in Visio:flow charts

Basic steps of database design

According to the standard design method, considering the whole process of database and its application system development, the database design is divided into the following 6 stages ： 1. Requirements analysis  (Usually from the top down) The first step in database design is to accurately understand and analyze user needs (including data and processing).  Requirements analysis… Continue reading Basic steps of database design

MySQL Practical tips! Good habits for writing SQL

1. Explain the execution plan after writing SQL (SQL performance optimization) Daily development write SQL, try to develop this good habit ah: after writing SQL, with explain analysis, especially pay attention to not go index. 2. Alter table delete or update statement add limit When executing a delete or update statement, add a limit as… Continue reading MySQL Practical tips! Good habits for writing SQL

A way to learn about the cutting edge of computer technology?

In my opinion, there are three aspects to understand cutting-edge computer technology. On the one hand, it is technical information, on the other hand, academic research, and on the other hand, technical details. The topic may focus more on technical details, such as what newer technologies (languages, frameworks, etc.) are applied in each development field.… Continue reading A way to learn about the cutting edge of computer technology?