Reddit reviews Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (2nd Edition)
We found 4 Reddit comments about Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (2nd Edition). Here are the top ones, ranked by their Reddit score.
Relational Database DesignDisign ObjectivesTerminologyEstablishing Table StructuresAnaylyzing the current database
Hug looks really interesting, I hadn't heard of it before. My recommendation however is that you use something like Flask or Django with Django-rest-framework. Hug doesn't really have the documentation, tutorials, or blog posts that can be helpful for beginners with web APIs (if you're not a beginner apologies, but that's the impression I got from your post.) The core idea around Hug seems solid, but you're going to be figuring a lot out on your own, which will inevitably lead to first-timer mistakes.
As far as databases go, before coding anything, read Database Design for Mere Mortals. You're not going to become a DBA overnight, but you'll avoid many of the common beginner mistakes.
Database Design for Mere Mortals is an excellent book that simply explains how databases work, what normalization is and why it's important, and how to create good, well-designed databases.
As far as learning SQL, MSDN has a lot of good documentation on it. I also recommend SQL Server Central, as they have some tests that will help you figure it out.
And, as always, almighty Google should have some excellent information.
I hope this helps you!
https://www.amazon.com/Database-Design-Mere-Mortals-Hands/dp/0201752840
I read that book back in college for my Databases class and thought it was a pretty easy read. It's long, but can also surprisingly be a quick read, esp if you just go thru it w/ a highlighter and don't take much notes beyond that.
There's also a newer version of the book available.
Are there any specific questions you have about databases tho, or any specific topics that confuse you? What database software are you guys working with? MySQL? MariaDB? Microsoft Access? PostgreSQL? MongoDB?
This is a FANTASTIC book. If I had three thumbs they would all be, ahem, up. ;)
It is platform-agnostic. It's not about learning how to use SQL Server, or Access. It teaches you database design without confusing you with textbook-type instruction.