Ask HN: How to learn relational database

3 points by navyad 9y ago ↗ HN

I'm a application developer using django, since most of the stuff learn happens behind Django'ORM.

So i'm looking to learn relational database, so that i can design better database system.

Can anybody guide what approach should be taken ?

3 comments

[ 4.1 ms ] story [ 15.4 ms ] thread

paukiatwee 9y ago ↗

You can get started using https://pgexercises.com/ , which focus on Postgres

brudgers 9y ago ↗

My favorite introductory book is Database Systems: The Complete Book, by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. The first edition is probably good enough and usable used copies are often available for less than $10 online.

In terms of interacting with relational databases directly, I've found SQLite's command line interface [the command sqlite3] very lightweight. A potential bonus of 'sqlite3' is running it against SQLite databases for applications already on your machine...be careful though.

Good luck.

navyad 9y ago ↗

One more thing , what could be the important concepts which should be covered ?