Ask HN: Need to Learn about Databases

#1

Post by deninho » Tue, Mar 24, 2020, 9:53 AM UTC

So, here's the thing. I have a Physics degree, and I am now (well, whenever coronavirus let us get out again) finishing my masters degree in Automation and Control. I've had Data Structures courses, but, due to some changes in the curriculum, I couldnt attend any databases course. So, I would like to invest my free time due to the quarantine, to learn about databases. But, I don't know what should I study, so I'd be grateful, if you could point me in the right direction (technologies, courses etc)

Thanks in advance :)

And keep safe people

Re: Ask HN: Need to Learn about Databases

#2

Post by brudgers » Tue, Mar 24, 2020, 1:44 PM UTC

Berkeley CS 186, Spring 2015. https://www.youtube.com/playlist?list=PLhMnuBfGeCDPtyC9kUf_h...

Re: Ask HN: Need to Learn about Databases

#3

Post by jrjsmrtn » Tue, Mar 24, 2020, 2:02 PM UTC

I recommend you the "Manga Guide to Databases" :-) It's a very, very good introduction to relational databases and SQL.

https://www.amazon.com/Manga-Guide-Databases-ebook/dp/B007XL...

Re: Ask HN: Need to Learn about Databases

#4

Post by deninho » Thu, Mar 26, 2020, 9:21 AM UTC

brudgers wrote: post #2

Berkeley CS 186, Spring 2015. https://www.youtube.com/playlist?list=PLhMnuBfGeCDPtyC9kUf_h...

thanks, I'll start watching the videos :)

Re: Ask HN: Need to Learn about Databases

#5

Post by deninho » Thu, Mar 26, 2020, 9:22 AM UTC

jrjsmrtn wrote: post #3

I recommend you the "Manga Guide to Databases" :-) It's a very, very good introduction to relational databases and SQL. https://www.amazon.com/Manga-Guide-Databases-ebook/dp/B007XL...

I'll give it a try, though I don't really like manga for entertainment, so I guess it will be a bit difficult to keep me focused for studying :p Thanks a lot

Re: Ask HN: Need to Learn about Databases

#6

Post by jrjsmrtn » Fri, Mar 27, 2020, 12:21 PM UTC

deninho wrote: post #5

jrjsmrtn wrote: post #3

I recommend you the "Manga Guide to Databases" :-) It's a very, very good introduction to relational databases and SQL. https://www.amazon.com/Manga-Guide-Databases-ebook/dp/B007XL...

I'll give it a try, though I don't really like manga for entertainment, so I guess it will be a bit difficult to keep me focused for studying :p Thanks a lot

Yeah, I know... :-) I have to credit the PostgreSQL core developers, you know: people experts in DBMS developments %-) They talked about it on the mailing lists almost ten years ago and I was intrigued. Since then, I probably have bought about 20 of them to distribute among colleagues or co-developers. For non-programmers who learned and created business applications with MS Excel, MS Access or Google Sheets, it was a gentle approach to relational databases and SQL, and helped a lot to migrate those solutions to (real) DBMS or ERP.