Please enable JavaScript.
Coggle requires JavaScript to display documents.
MySQL (Query (SELECT, WHERE, And, Or, Not, ORDER BY, SELECT TOP, LIKE, IS…
MySQL
Query
SELECT
WHERE
And, Or, Not
ORDER BY
SELECT TOP
LIKE
IS NULL, IS NOT NULL
WILDCARD
IN
BETWEEN
Analysis
COUNT(),
AVG()
SUM()
MIN()
MAX()
GROUP BY
How to design DB table ?
UML
https://www.youtube.com/watch?v=UI6lqHOVHic
ERD
https://www.youtube.com/watch?v=QpdhBUYk7Kk
Normalization
https://www.youtube.com/watch?time_continue=469&v=xoTyrdT9SZI
data manipulation
Insert Into
Update
Delete
table manipulation
UNION
JOIN
INNER
LEFT
RIGHT
FULL
optimization
Index