Just launched! Get 30% off Rails Revisited Have a Look
robconery.com

PostgreSQL Fundamentals

March 21, 2024 | Stuff
You'll learn the basics of SQL and databases using PostgreSQL and you'll have the time of your life doing it. We use a real set of data: the analysis data from Cassini's flybys of Enceladus. There might actually be life up there and you're going to query the data to find out!
***

As a new DBA, You'll be given the raw data that Cassini gathered during its time orbiting Saturn and passing by Enceladus. You're going to load this data, transform it into a solid relational design using PostgreSQL, and then export it for analysis by the analytical team. When you're done, you'll be able to create tables and views, run analytical queries and tweak data as needed. You'll be on your way to your new life as a data pro.

Join over 15,000 programmers just like you and me

I have a problem when it comes to trying new things and learning about computer science stuff. I'm self-taught, so it's imperative I keep up with what's going on. I love sharing, so sign up and I'll send along what I've learned right to your inbox.