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.