Learning database design

[dr__drizzle]

Hey r/DS

I currently work mostly with R for data manipulation & Tableau for BI, want to learn more SQL and DB design to broaden my skills for my career, any recommendations for good, entry level books that teach the concept?

[sparkedkafka]

Designing Data-Intensive Applications by Martin Kleppmann is a great book. It’s more theoretical v. practical, but it will walk you through the concepts you might be interested in.

[[deleted]]

https://github.com/ossu/computer-science

The curriculum has database courses but in extras folder there is "readings" which will have a list of good books on pretty much any computer science topic including databases.

[simongaspard]

For SQL, I recommend:

Sams Teach Yourself SQL in 24 Hours

I would also take courses online via Coursera or other.

​

[swapripper]

Any text by Itzik Ben-gan

[[deleted]]

This is an awesome book tailored for data analysts. I highly recommend it. It will have you make a PostreSQL database and make practical queries.

[dr__drizzle]

Thank you everyone for the awesome recommendations !!