Follow along with Dee Yan, our fictional data science intern, as she assumes the job of interim database administrator at the fictional aerospace startup, Red:4. She’ll learn PostgreSQL like we all do: on the job and under pressure.
She needs to assemble, normalize, query and optimize data from the Cassini mission so it can go along as reference material for SELFI, NASA’s next-generation sensor that has a singular job: verify life under Saturn's ice moon: Enceladus.
Mostly a PostgreSQL tutorial, this book also has a narrative element in the spirit of The Martian. You'll start out with the basics: creating tables and importing data. Soon, however, you'll be awash in glorious SQL and data from space, creating functions, common table expressions and calculating aggregates using window functions.
Is there life under the ice of Enceladus? Let's ask the data...
This is an ebook that is delivered in epub, PDF and Kindle formats.
I’ve found the book to be a treasure trove of Postgres features. CTEs are blowing my mind right now. I’m a backend engineer, and I’ve been sharing what I’ve learned with my coworker who is a DBA. She is picking up some tips through me now! I haven’t found a good, engaging tutorial for these intermediate/advanced Postgres tricks, and "A Curious Moon" fills this gap. As a bonus, I’m also picking up some bash tips from the book.
-- Loren Stewart