To add to suggestions of others, the SQL Antipatterns was also an insigtful read about basic pitfalls of db design.<p>I have also found first chapters from Designing Data Intensive Applications helpful to get context around sql/nosql dbs.
I like Practical SQL from No Starch Press: <a href="https://nostarch.com/practicalSQL" rel="nofollow">https://nostarch.com/practicalSQL</a><p>I didn't learn from the book myself, but I read it to evaluate it as a teaching tool for juniors and wound up recommending it.