Conery Rob. A Curious Moon

Big Machine, 2017. — 386 p.Learn PostgreSQL like we all do: on the job and under pressure.
Assemble, normalize, query and optimize data from the Cassini mission so it can go along as reference material for 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.Lift Off
Transit
The Enceladus Database
Importing The Mission Plan
Using Make
In Orbit
Normalization
Importing Events, Again
White and Black Smokers
Flyby
First Attempt
A Bent Field
Getting Nowhere
E-0, The First Enceladus Flyby
Sargeable and Non-Sargeable Queries
Using a View to Make Querying Easier
Gold Trace in The Mission Plan
Full-Text Queries
Using a Materialized View
Sniff The Sky
I Did It!
Hello INMS
Working With The INMS CSVs
Who Remembers This Stuff?
Using CSVSQL
Successful Import
Inspecting The Data
Cherry Picking the Nadir
Transforming Data with CTEs
Something Gnawing At Me
Ring Dust
The Analysis Window
Basic Function of the CDA
Refactor Part 1: A Better CTE
The Flybys Table
CDA Data Audit
Importing CDA Data
Examining CDA Data
Calculating Cassini’s Speed
Playing with Speed Data
A Simple Window Function
A Tight Ship
Postgres is correct
The Data-First Mindset
Why Postgres?
Gravity Assist
The Analysis Team
Flyby Trigonometry
Calculating the Analysis Window
Calculating the Analysis Window, Try 2
If No Can, No Can
Revision: Doing It By Hand
OMG OMG OMG OMG!
The INMS Tutorial
Under The Ice
Daltons In The Plumes
Importing Chemical Data
Look at Me!
Understanding the INMS Readings
Loading The INMS Readings
A Junction Table
Indexes vs. Joins
Timestamps and Indexes
Advanced: Using Ranges
Comparing The Speeds
Putting It Together: A Chemical Query
Exploring INMS Readings
One Last Query