Where to start learning the database?

Question

Database

I am studying to be a system analyst (in fact, everything is mixed up, that it is not clear what we will have as a result). And I was pretty interested in databases. At the university, we had:
1. Entity-relationship models (er-model)
2. Normalization method (up to 5 forms)
3. History of relational / pre-relational databases
4. Recall sets from clear logic
5. Studied possible situations with keys ( primary/external/alternative)
software:
1. Oracle Data Modeler (but I did the schemas right away in SQL Dvlp)
2. Oracle SQL Developer (logical> physical> generation script> database creation on the server> filling tables> SQL queries)
How best to continue develop in this direction?
What books would you recommend for structuring information? Since there is a feeling that I know something from the database, but it was all given in such fragments that, in fact, I don’t know anything ... Although I did everything from scratch myself.

Answer 1

Bill Carwin, "SQL Database Programming", on database design antipatterns;
Ben Forta, "SQL in 10 minutes" - here you can learn about constructions, the syntax of which is the same in each DBMS, but the syntax of something more serious, for example, transactions, stored procedures, indexes, cursors, etc. each DBMS has its own, well, the standard library of functions also has its own. Choose a DBMS and study it.
Vikram Vaswani, "MySQL. Usage and Administration", - if you want in MySQL, then the book is the very thing; entity-relationship diagrams can be done in mysql-workbench and it seems even to force the server to build a database on them.
I don't know anything about Oracle, to be honest.