I started as a student intern at a commercial lending startup and dropped out to work there full time (if I'd have graduated it'd have been right into the teeth of the 07-08 crash). I did a lot of database design, data access framework implementation, web service layers, and CI infrastructure. Most of my ensuing career has been more of the same.
Concepts are the important part. Relational databases all more or less conform to one standard, and once you understand what's going on internally it's easy to go from SQL Server's SELECT TOP 100... to everybody else's SELECT ... LIMIT 100. A b-tree index does the same thing no matter who wrote it, and so on. Chasing specific implementations without a solid grasp of the fundamentals of data storage and access is how you get caught up in fads like the "document stores will kill relational stores" thing of the early 10s; document stores are an important niche class, but they're not an RDBMS replacement. It's more important to know what problems they solve than the exact details of their usage.
SELECT TOP 100...
SELECT ... LIMIT 100
Books: Lex de Haan & Toon Koppelaars' Applied Mathematics for Database Developers and Charity Majors & Laine Campbell's Database Reliability Engineering are both excellent.
Thanks for the recommendations. I'll check them out.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.