Codestars by Rob Percival
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.
Everything you’ll learn in this course is relevant to other database systems too, like MySQL, Microsoft SQL Server, or Oracle.
With this course, you’ll master PostgreSQL and how to work with it from Python. If you use Python and you want to augment your skills with a database, you’ll love this course!
You will:
Work with different types of databases (in–memory, SQLite, and PostgreSQL), and understand when to use each in your Python apps.
Build a programming journal project to add a SQLite database to your Python application.
Improve a database design incrementally so you’re not bound by your initial design.
Model different relationships with PostgreSQL, including one–to–many and many–to–many.
Reduce errors by applying database changes using database migrations with Python and alembic.
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Work with dates and times in PostgreSQL, and avoid common timezone pitfalls.
Structure Python apps like a professional, to make development much easier.
Instructor Details
Courses : 13
Specification: The Complete Python/PostgreSQL Course 2.0
|
21 reviews for The Complete Python/PostgreSQL Course 2.0
Add a review
| Price | $12.99 |
|---|---|
| Provider | |
| Duration | 13.5 hours |
| Year | 2022 |
| Level | Intermediate |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$12.99
Prateek Shukla –
Great course to learn Python & Postgres! I like the way Jose teaches the basic concepts of python, he makes python with postgresql look easy. Having multiple big projects in the course allows us to apply all the concepts while learning the theoretical concepts.Also, the quiz exercises at the end of the course make it more interactive and thought provoking.
Almin Colakovic –
This is an amazing and in depth course for SQLite and PostgreSQL. My previous experience with SQL has been at a basic level, where you mostly just store and retrieve data from a database. It’s first after taking this course I really see the power and potential of really knowing and understanding how to properly use databases. Jose is doing an amazing job of trying to explain all this by building different projects. Some topics can be really advanced with a lot of different syntaxes, my suggestion is don’t try to rush through it, but rather press pause and take a look at this e book that’s supplied with courser or simply try to understand what Jose is saying by rewatching those parts. Really really good and in depth course. 5 stars.
Regha Abraham –
Whiles every project always have room for improvement, I must say it is an excellent course as I comment below. FOUNDATION: adding a crash, but detailed Python beginners course is awesome. I find this introduction very key as the foundation to the main course. Just about anyone can jump in and learn; the beginner, the intermediate and advanced programmer. Everyone can jump in and enjoy his classes. COURSE PROGRESSION: The topics are interrelated, as one topic leads you seamlessly to the other, making the learning process both interesting and coherent. COURSE PRESENTATION: the slides and pattern of teaching makes it easy for a beginner to understands. This is made possible by your amazing use of image representation. THE VIDEO representations are great! By this, I mean the videos are short but detailed; that alone is magical, One video unfolding the other. EXERCISES: we learn by trying out various exercises. Every class has an accompanied exercise(s) which aids one in the learning experience by challenging you to work and master the art.
Jovan Xin –
Clear, detailed. Haven’t finished the course yet but already able to utilize SQLite in my projects 🙂
Tesilimi Oladimeji Yusuf –
Jose is a natural teacher and this course is probably the best you will get anywhere. The entire Python and Postgress SQL were clearly and succinctly taught and extremely enjoyable. This has become the known hallmark of Jose if you have ever taken any of his other courses. This course is great and I highly recommend it to anyone serious about knowing Python and using the language for real world projects at a professional level. Thanks, Jose!
Richard Bongard –
Want to learn Python? Want to understand how to build an application in Python and how to store your data in to a Relational Database? I can tell you after taking this course it will all make sense. I have some 30 year old programming experience and some SQL experience, but Jose attention detail is great. He breaks everything down and describes the entire process in detail. I have taken other courses. These are the best.
Mahmoud –
Honestly, this is an amazing course, I also love how the instructor is really active and will actually help you out if you need help.
Kristofor Lawson –
Jose is one of the best teachers on Udemy and the PostgreSQL course does not disappoint. I find his teaching style easy to follow and I love the depth in the content. I find myself truly understanding what I’m trying to code. If you’re wanting to learn PostgreSQL then this is the course for you.
CSI SD –
Perfect.
Arun Kumar –
Jose is having good approach to make things clear.
Iain Robinson –
Another good course from Jose. Enjoyed learning the interaction between Python and PostgreSQL.
Abhimanyu Kumar –
Well explained topics…..easy to understand!!! Jose is excellent teacher..
Nishchal Chaudhary –
If you are expecting the individual to already know python, starting off with very basics of printing is a waste of time. Instead, show good pythonic practices of using print statements or better show how to do proper logging.
Sahil Kumar –
well explained videos..best learning method
David Carrasquilla Retana –
It’s just Great! Thanks so much for this Learning path!
Timothy Day –
So far yes, I am learning new things, but not so much that I can’t follow it.
Rodrigo Ibaceta –
Yes! I’m actually learning things I didn’t know I needed!
George Rebello –
Great course, lots of examples that can be referred to for real world applications! The only negative in my opinion, is that the instructor speaks and types incredibly fast, so don’t be surprised if you find yourself playing the videos at x0.75.
Mario Jensen –
Probably the best instructor I’ve ever learned from. Keeps out the extra fluff and provides examples for best practices and also shows what would break the code. Awesome.
Sharath kumar –
Best course for python with SQLite and PostgreSQL with hands on projects. Overall good experience.
Luis Olascoaga –
Great course!