Hi, I've seen lots of posts on various forums and am getting the impression that people learning RDBMS systems like PostgreSQL, MySQL and even SQLite are not been given a good foundation in RDBMS fundamentals. They don't even seem to know what 3td normal form is or understand the basics of optimisation. I.e. I've seen exercises where the solution was to return the whole table and use a rand function (in the language, i.e. Python) to get a random row, rather than get the server to do this. Also the basic idea of returning only the columns you need to reduce network traffic.
Anyway my question. Has anyone found a good simple to follow unbloated video explaining RDBMS fundamentals and good practices? Other videos that would be good are normalisation and one on good practice (i.e. basic optimisation).
The other thing that would be fun would be 10 commandments for RDBMS design and access :).
submitted by
/u/LifeAffect6762 [link] [comments] 
