How to create a database training plan?

Question

Database

Interested in databases. In this regard, I am trying to draw up a clear plan of action: what to consider and in what order.
1. Where to start: directly from SQL code or from database theory; about how they are designed, etc.?
2. At what stage to master the DBMS?
3. What literature to read, or rather, what sequence to follow?
I've been scratching my head over these questions for a few days. And all because there is no clear sequence.

Answer 1

Start with theory, figure out what databases are, what they eat with and how to install them, see what databases are, find out what is the difference between sql and nosql databases.
Then you need to learn sql, take some book on sql, read and practice, make some small crud applications.
Now you can start designing, come up with some kind of database, for example, an online store, think about the structure and relationships between tables, try normalizing and denormalizing relationships, figure out what it is and when to use it.

Answer 2

enough
further practice, for example

Answer 3

in my opinion, to begin with:
- administration - put for example Virtual Box and create CentOS machines and try installing mysql / mariadb, posgresql and something else nosql or a columnar database there.
- then try to create a schema and objects in it - tables, key fields, foreign keys, data types, indexes, then master the normalization: 1,2,3 form.
- then try to load more than 10 million rows and try to solve optimization issues.
- then try to consider options for writing clients in different programming languages ​​(OBDC, JDBC, etc.)

Answer 4

here