The Basics of SQL and Data Science


Many data science pros will tell you: learning SQL was one of the best investments in their career, even though the language is a bit basic. See why so many developers become data pros in this 2-hour video tutorial featuring data from the Cassini mission.

Add our bestseller A Curious Moon for 25% off!

A Curious Moon was a big gamble for me, personally, as I tried to weave a fictional, sci-fi narrative (like The Martian) together with a solid tutorial. It's worked out very well! Add this book to your Postgres library!


Learning SQL can be a chore - mainly because online course typically have you creating DVD stores and learning dry syntax rules.

It's so much more fun in the real world... let me show you what I mean using real data from NASA and Cassini...

A Skillset To Last Your Entire Career

sql skills are always in demand

It might be hard to believe but SQL consistently ranks in the top 10 programming languages, even though it's not a programming language! It's ahead of languages like Go, Swift and Ruby - consistently! That's because SQL people are always needed!

Developing a data sense will make you a super star

People do horrible things with data and spreadsheets, introducing errors, bias and often data that's simply trash. Being able to "sense" these issues and then correct them can save your company millions of dollars, making you look like the badass you are.

Sometimes You need to just go sideways

When building an application that uses a relational backend, you inevitable come to a point where your data access tool (usually an ORM) is causing too many headaches due to crappy code and slow queries. Leveraging your new database skills, you can easily step around that tool as needed, creating and optimizing a solution that is not only elegant - it will outlast your entire tech stack.

You will learn SQL and databases the way we all do: under the gun

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.