The Complete Python/PostgreSQL Course 2.0 (Udemy.com)
Take the next step in your Python development by leveraging the power of PostgreSQL and databases!
Created by: Codestars by Rob Percival
Produced in 2021
What you will learn
- How to leverage the power of databases (in-memory, SQLite, and PostgreSQL) to upgrade your Python applications
- Prevent common pitfalls: avoid SQL injection attacks, store database credentials securely, and optimize the performance of your applications
- Understand how databases work and how to take advantage of their features from the ground up, by building multiple projects
- This is a no-nonsense, no-frills course on fully mastering PostgreSQL and how to use it effective within and outside of your Python apps
- Learn how to work with dates and times effectively in Python applications
- Produce engaging charts, graphs, and reports using database data
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course Description
Master PostgreSQL and use it in your Python apps!
Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.
In addition, all the database knowledge you'll 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 on fully understanding PostgreSQL and effectively integrating it with your Python applications. If you're a Python developer or you use Python at all, and you want to start using a PostgreSQL database, you're going to love this course!
You will:
Add data storage to your Python apps with in-memory databases, SQLite, and PostgreSQL.
Understand when to use different types of databases in your applications.
Build a programming journal project to learn how to add a SQLite database to your application.
Create a movie watch-list app 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 app to PostgreSQL to identify the differences between PostgreSQL and SQLite.
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Extend the polling app to work with dates and times, and avoid common timezone pitfalls.
Learn how to structure Python apps professionally, to make development easy when working with databases.
Explore advanced SQL and PostgreSQL concepts such as user-defined functions, stored procedures, locking, and async database connections with Python.
Take all your knowledge and apply it to produce data analysis reports and charts using matplotlib.
As you can see, you're going to learn a lot!
But this is a no-nonsense, no-frills course. Every 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 code-along videos when we're working with Python. But you won't just be watching me code! I've carefully planned and mapped out every project and feature we add, and I encourage you to try them on your own first, before following along with me!
Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.
I've 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 completing this course you'll 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 for more information and to try out the course!
I'll see you on the inside!
Who this course is for:
Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applicationsBusiness analysis and data scientists who want to create larger applications or interact with larger data sets through a database
Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.
In addition, all the database knowledge you'll 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 on fully understanding PostgreSQL and effectively integrating it with your Python applications. If you're a Python developer or you use Python at all, and you want to start using a PostgreSQL database, you're going to love this course!
You will:
Add data storage to your Python apps with in-memory databases, SQLite, and PostgreSQL.
Understand when to use different types of databases in your applications.
Build a programming journal project to learn how to add a SQLite database to your application.
Create a movie watch-list app 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 app to PostgreSQL to identify the differences between PostgreSQL and SQLite.
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Extend the polling app to work with dates and times, and avoid common timezone pitfalls.
Learn how to structure Python apps professionally, to make development easy when working with databases.
Explore advanced SQL and PostgreSQL concepts such as user-defined functions, stored procedures, locking, and async database connections with Python.
Take all your knowledge and apply it to produce data analysis reports and charts using matplotlib.
As you can see, you're going to learn a lot!
But this is a no-nonsense, no-frills course. Every 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 code-along videos when we're working with Python. But you won't just be watching me code! I've carefully planned and mapped out every project and feature we add, and I encourage you to try them on your own first, before following along with me!
Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.
I've 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 completing this course you'll 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 for more information and to try out the course!
I'll see you on the inside!
Who this course is for:
Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applicationsBusiness analysis and data scientists who want to create larger applications or interact with larger data sets through a database
Instructor Details
- 4.6 Rating
92 Reviews
Codestars by Rob Percival
Best-selling Udemy instructor Rob Percival wants to revolutionize the way people learn to code by making it simple, logical, fun and, above all, accessible. But as just one man, Rob couldnt create all the courses his students - more than half a million of them - wanted.
Thats why Rob created Codestars. Together, the instructors that make up the Codestars team create courses on all the topics that students want to learn in the way that students want to learn them: courses that are well-structured, super interactive, and easy to understand. Codestars wants to make it as easy as possible for learners of all ages and levels to build functional websites and apps.
More courses by Codestars by Rob Percival
The Complete Machine Learning Course with Python (2021)
3.8 (406 Reviews)
Provider: Udemy
Time: 17.5h
$11.99
The Complete Python Course - Learn Python by Doing (2021)
4.7 (380 Reviews)
- Provider: Udemy
- Time: 35h
$11.99
The Complete Sketch 5 Course - Design Apps & Websites 2018 (2018)
4.6 (362 Reviews)
- Provider: Udemy
- Time: 14.5h
$11.99
The Complete JavaScript Course - Beginner to Professional (2021)
4.3 (345 Reviews)
- Provider: Udemy
- Time: 34h
$11.99
The Complete React Js & Redux Course - Build Modern Web Apps (2018)
4.5 (333 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
The Complete ARKit Course - Build 11 Augmented Reality Apps (2021)
4.6 (311 Reviews)
- Provider: Udemy
- Time: 9.5h
$11.99
More postgresql courses
SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)
- Provider: Udemy
- Time: 22h
$11.99
Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)
- Provider: Udemy
- Time: 15.5h
$11.99
Reviews
- Video Duration:
13.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
