Virtual course of: Udemy |
Master PostgreSQL and use it in your Python applications! Python and PostgreSQL are two of the most in-demand skills in the world.
After completing this course, you will be sure to add both to your resume.
Furthermore, all the database knowledge you will gain in this course is easily transferable to other databases such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and others.
The focus of this course is to fully understand PostgreSQL and integrate it effectively with your Python applications.
If you're a Python developer or user of Python, and want to get started with a PostgreSQL database, you'll love this course! You'll be able to: Add data storage to your Python applications with in-memory databases, SQLite, and PostgreSQL.
Understand when to use different types of databases in your applications.
Create a program journal project to learn how to add an SQLite database to your application.
Create a movie playlist application to explore how to improve your database design over time, as well as how to model different types of relationships.
Migrate the movie watch list application to PostgreSQL to identify the differences between PostgreSQL and SQLite.
Build a polling app to learn advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Extend your survey app to work with dates and times, and avoid common time zone errors.
Learn how to structure Python applications professionally, to make COMPUTER SCIENCE easier when working with databases.
Explore advanced SQL and PostgreSQL concepts such as user-defined functions, stored procedures, locking, and asynchronous database connections with Python.
Take all your knowledge and apply it to produce data analysis reports and graphs using matplotlib.
As you can see, you will learn a lot! But this is a hands-on, no-frills course.
Each lecture has been planned, crafted and edited to be perfectly concise and to the point.
That way you can learn everything, quickly and easily.
Throughout the course, we have animated diagrams to explain database concepts, as well as videos of code when working with Python.
But you won't just see me code! I've carefully planned and mapped every project and feature we add, and I encourage you to try them out for yourself first, before following me! Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you have learned.
I have been teaching and helping students online for over 7 years, and this course is the culmination of my teaching experience.
I know how to help you understand concepts fully and quickly, in the best way for you.
Upon completion of this course, you will be able to easily extend your Python applications with database functionality using PostgreSQL.
You'll know how to answer questions using data, and you'll definitely be able to list PostgreSQL as one of your strongest skills.
Check out the free preview videos to learn more and try out the course! See you inside! You can easily extend your Python applications with database functionality using PostgreSQL.
You'll know how to answer questions using data, and you'll definitely be able to list PostgreSQL as one of your strongest skills.
Check out the free preview videos to learn more and try out the course! See you inside! You can easily extend your Python applications with database functionality using PostgreSQL.
You'll know how to answer questions using data, and you'll definitely be able to list PostgreSQL as one of your strongest skills.
Check out the free preview videos to learn more and try out the course! See you inside!
Udemy has the largest repository of online courses in the world
Access to the content of the course, once finished, so you can enjoy its future updates
Experts in their fields from all over the world share their expertise on Udemy
From all over the world, 480 million times have been enrolled in Udemy courses
Hello how can I help you? Are you interested in a course? About what subject?
Add a review