How to create CRUD Application with Python and PostgreSQL
What you'll learn
- Setup PostgreSQL Database Server
- Create a new database and table
- Create a sequence to provide automatic numbering on a column
- Alter column in a table
- Create database connection configuration file
- Create Graphical User Interface with tkinter
- Create message pop up messages on application
- Create and activate a virtual environment
- Create a class and methods
- Create functions
- Bind button widgets to functions
- Connect to PostgreSQL Database Server from Python Application
Requirements
- Basic knowledge of SQL will help
- Basic knowledge of Python will help
- Basic knowledge of PostgreSQL
Description
In this course you learn how to interface a Python application program with a PostgreSQL database. Python has various modules that you can use to interact with databases. We will install psycopg2 connector module to enable us interact with PostgreSQL database from our Python application.
We will be installing PostgreSQL Database Server and also create a new database and table that our Python application will interact with.
We will create the Python application frontend using Tkinter which is a built in Python module used to create graphical user interfaces . From tkinter module we will import ttk module which is a themed widget library that contains various types of widgets like buttons,labels etc that we can use to build the graphical user interface for our Python application. We will also import other bits and pieces from the tkinter module that our Python application will use.
Also we will create a database configuration file that twill be used to interact with the PostgreSQL database from our Python application.
Who this course is for:
- Beginners to Python
- Beginners to Programming
- Beginners to SQL
Instructor
- 4.2 Instructor Rating
- 44,438 Reviews
- 792,555 Students
- 400 Courses
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.