Stage 1
MySQL success characteristic.
Characterization of MySQL features.
How to install MySQL 5.x server.
MySQL schematization overview.
An introduction to the programs that are used to work with the server.
An introduction to the utilities that are used to work with the server.
Familiarity with server console commands.
An introduction to USE operators.
An introduction to SHOW statements.
INFORMATION_SCHEMA is a database.
How to use it in order to have information about metadata.
Practice.
Database design algorithm.
Introduction to MySQL 5.x – Central Data Types.
How to make the best choice of type in order to save your data.
How the database is normalized.
Characteristics of the keys.
Workbench 8.0.x package overview.
Techniques for its application in database design.
Practice.