Not a book, but if you're looking to learn modern SQL in a hands-on way, I created Mastery with SQL (masterywithsql.com) specifically because I was frustrated with traditional SQL (and PostgreSQL) content that's lacking in high quality and challenging exercises. Mastery with SQL has over 150 exercises, ranging from easy to very difficult, where you're primarily working with a single database and trying to answer inte…
Ask HN: What are some books where the reader learns by building projects?
141–150 of 188 posts
Re: Ask HN: What are some books where the reader learns by building projects?
#142Elements of Computing Systems by Nisan and Schocken has you 'build' a computer from basic logic gates to CPU/Memory to assembler, VM, etc. all the way to a running program. https://www.nand2tetris.org/
Re: Ask HN: What are some books where the reader learns by building projects?
#143Re: Ask HN: What are some books where the reader learns by building projects?
#144A Curios Moon - a data science mystery that teaches you PostgreSQL by working on projects that use real nasa data sets in a fictional setting (your role as a data science intern at red:4) https://bigmachine.io/products/a-curious-moon/
This is really nice book. It assumes you are a developer/good with computers, though, so some of the things like dev environment setup are ommited
Re: Ask HN: What are some books where the reader learns by building projects?
#145https://www.labri.fr/perso/nrougier/from-python-to-numpy/
A book teaching Numpy vectorization.
Re: Ask HN: What are some books where the reader learns by building projects?
#146Re: Ask HN: What are some books where the reader learns by building projects?
#147I'm currently writing a book for PragProg called Building Distributed Services with Go (though it mostly applies to other languages too) that's walks you through building a distributed database from scratch. You can sign up on this mailing list to know when it's available: https://travisjeffery.us4.list-manage.com/subscribe?u=1e3ff7... .
The link doesn't quite work there. But I'd be interested in signing up.
via his comment history :)
Re: Ask HN: What are some books where the reader learns by building projects?
#148Assembly Language and Computer Architecture Using C++ and Java , Course Technology, 2004
Compiler Construction Using Java, JavaCC, and Yacc, IEEE/Wiley, 2012
Re: Ask HN: What are some books where the reader learns by building projects?
#149Clojure for the Brave and True is a very fun project-based book. As someone who struggles getting through technical books, I found this one a real joy and it kept my attention to the very end. https://www.braveclojure.com/
Re: Ask HN: What are some books where the reader learns by building projects?
#150Splash of Code by Joel Dare