Welcome to The Complete Python and PostgreSQL course 2.0!
My name is Jose Salvatierra and I'll be your instructor in this course.
I'm a software developer turned online teacher, with over 120,000
students on Udemy.
I'm also the founder of Teclado, where I help my students level up their coding.
Today I'm here to help you learn, use, and eventually master PostgreSQL and how to use it from your
Python apps from scratch. You'll need no PostgreSQL or database experience at all.
Some Python or programming experience will be helpful, but we've got a complete Python refresher
included in this course.
Other than that you'll learn everything you need, from the ground up.
PostgreSQL (also called just Postgres) is one of the top relational database systems in the world, used
by giants such as Instagram, Skype, The Guardian and even Apple.
But also, after taking this course on Postgres you'll find it really easy to learn other relational
database systems, such as MySQL because the concepts are really similar. Postgres is so popular
because it has excellent performance. It's also got advanced features such as JSON and Key-value pair
storage; and it's free and open-source with an excellent team of contributors making it better every
single day. In each section of this course, you learn
how to build and extend Python projects to add more and more database functionality to them.
You'll learn about the fundamentals of SQL, such as creating tables and retrieving data;
what relational data really is and how to work with it using JOINs.
We'll explore psycopg2 to interact with PostgreSQL using Python; advanced querying
with nested queries, views, functions, and stored procedures;
how to work with dates and times correctly so you don't run into some very common problems;
how to plot graphs and charts with your data; and much much more. So by the end of this course,
not only will you know and understand everything you need to know about databases,
you'll also have tons of practical experience using Postgres in your python apps.
Whether you're a python developer who wants to start harnessing the power of databases, or maybe a sysadmin
or data analyst who wants to take the best of both Python and Postgres,
this course is for you!
So there you have it.
If you want to learn more about Python and databases and Postgres, join the course!
I'll see you on the inside!