Understanding internal workings of DBs or other tools
How do you learn the internal workings of databases (e.g. MySQL ) or other components like Kafka while on the job. I recently started interviewing and people really go all out on quizzing about the Internals of these applications and also frameworks like spring boot. Work ex - 4.5 years. #engineering #software #interviews
My last semester in undergrad I took a final course for database systems and this was the book: https://www.amazon.com/Database-Concepts-Abraham-Silberschatz-Professor/dp/0073523321/ref=nodl_ Some parts of it are more theory and I wouldnāt read all of it but I would google the topics individually and read some parts of the book
Designing data intensive applications book especially the reference materials for the chapters about dbs https://www.amazon.com/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/1449373321/ref=asc_df_1449373321/?tag=hyprod-20&linkCode=df0&hvadid=266396064900&hvpos=&hvnetw=g&hvrand=7766933740597034761&hvpone=&hvptwo=&hvqmt=&hvdev=m&hvdvcmdl=&hvlocint=&hvlocphy=9028277&hvtargid=pla-432535594773&psc=1
High level DB internal questions are common. But what Spring questions did they ask you? Never hear anyone asking about framework internals.
Not so much about internals. It was more about the annotations that are used.
Ah gotcha, I feel like better places donāt ask questions like that. Itās a bit of a red flag imo.
the best resource I have come across is CMU course on database and advanced database by Andy Pavlo.. I keep going back there because I like the subject but itās hard to retain all the info.. you can still learn high level concepts and learn things about how indexes work, why order of keys in composite key matter and things like that.. unless you are a DB researcher you are never gonna retain anything for long term..
Following