PASS Day 2 - Postgres Fundamentals for SQL folks precon
This session was taught by Grant Fritchey and Ryan Booz, which is a great match up. Ryan is an expert on Postgres and Grant has gotten deep into Postgres over the last three years which pairs well with his decades of SQL Server experience.
This was a great course for me to help me bridge the gap and answer some of my n00b’ish questions. Like what are extensions and why do I care. Turns out, extensions extend the functionality of Postgres and you shouldn’t ignore them until later. The answer is almost always, there’s an extension for whatever you need, and if there isn’t…write one. Of course I suppose that has the same warnings about open source projects on GitHub. There’s no guarantee the extension will continue to be maintained or that it’ll work in an upgrade.
Grant and Ryan wrote a postgres book that they signed and gave out for free.