Resources for learning about databases
I recently got a Frontend Engineering offer from Facebook. I have dabbled in backend work earlier in my carrier but never did anything beyond simple API’s on a single server. I set a goal for myself that every year I pick a computer science topic & study it thoroughly. I dont have a CS background but I am begining to love CS. I started with Data Structures & Algorithms last year, studied & did over 250 leets, this is why I was able to land an offer with FAANG. Next on my list is Databases, I want to know how they work internally, build a simple RDBS from scratch, learn SQL(I know simple CRUD operations) advanced concepts like procedures & the latest that is being used today. I have googled yes, but I havent found any resource that meets my needs. I also plan to switch to backend soon. Thanks in advance
Since you successfully did Data Structures and Algorithms, would you mind suggesting what resources you used for them?
++
Read Algorithms textbooks by Robert Sedgewick & do your leets.
Ask an one on one with zuckerberger
Sounds like you want to learn database internals. One of the oldest courses in Coursera is dB-class. That might work for you but I found it a bit too dry for my taste. I personally love Andy Pavlo’s lectures. He posts them under the CMU Database group channel on YouTube. Let me know if you have more questions. Happy to help.
Checkout designing data intensive applications. Contains lot of information on database internals around scaling, partitioning, replication, etc
Lol was just thinking about this book and wanted to recommend it too
I recommend it as well, I'm still reading thought it, very easy to understand and reason through