The course "Mastering Postgres" helped me practice query commands and understand why they're important. Inspiring me to explore the 'why' and 'how' behind each one. Truly a great course!Nakolus
Shorten dev cycles with branching and zero-downtime schema migrations.
Hey. Welcome to Mastering Postgres. My name is Aaron Francis. I'm gonna be your teacher throughout this course.
I'm a database educator. Been working with databases for almost 20 years at this point, which makes me feel super old, but I love it so, so much. And the reason that I love it so much is no matter how fast your application is, it's going to be as slow as your slowest query.
We spend all this time arguing about tech stacks and frameworks and languages when there's this giant behemoth at the bottom that we kind of treat as like a black box. A lot of people don't want to go down to that level of the stack and there are just massive performance gains that we can find in the database. Learning the things that we're gonna learn in this course, yes, will help you make better, faster, more performant applications, which is awesome, but it's also gonna help you advance in your career.
After you finish this, there's a very high possibility that you become the database expert on your team, and that's very good for your career. We're gonna go through everything from the basics all the way up to very advanced stuff, but we're gonna walk through it one step at a time. And frankly, honestly, I think it's a lot of fun. Hopefully at the end of this, you feel extremely confident.
A lot of this course is free. It has been made freely available thanks to our generous sponsor, Xata. Xata is a Postgres platform for builders. If you want to take all of this knowledge, but not actually host your own database, I recommend Xata. Go put it on Xata.
Here's the promise that I will make to you. Everything that you're gonna learn here, everything that I'm going to teach you here is going to be honest to goodness, vanilla, raw Postgres. There are some things that Xata makes easier, and I will absolutely mention them as we're learning. But I'm not here to teach you Xata.
I am here to teach you Postgres.
I just happen to think Xata is a good place to put your database, but I want it to be pure and honest Postgres. That's what we're gonna learn here. I'm very excited. I put a ton of work into this. I love teaching. Please reach out, let me know what you think, and I hope you enjoy this course.