How to create CRUD Application with Python and PostgreSQL

How to create CRUD Application with Python and PostgreSQL, available at $54.99, has an average rating of 4.25, with 26 lectures, based on 84 reviews, and has 20030 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners to Python or Beginners to Programming or Beginners to SQL It is particularly useful for Beginners to Python or Beginners to Programming or Beginners to SQL.

Enroll now: How to create CRUD Application with Python and PostgreSQL

Summary

Title: How to create CRUD Application with Python and PostgreSQL

Price: $54.99

Average Rating: 4.25

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $54.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Beginners to Python

Beginners to Programming

Beginners to SQL

Target Audiences

Beginners to Python

Beginners to Programming

Beginners to SQL

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.

Course Curriculum

Chapter 1: Setup PostgreSQL Database Server

Lecture 1: Introduction

Lecture 2: What is CRUD

Lecture 3: What is PostgreSQL

Lecture 4: Install PostgreSQL for Windows

Lecture 5: Install PostgreSQL on Macs

Lecture 6: Create database and table

Lecture 7: Create sequence and alter table column

Chapter 2: Setting Up Python

Lecture 1: Installing Python 3 on Macs

Lecture 2: Installing Python on Windows

Lecture 3: What is tkinter

Lecture 4: Install Atom text editor

Lecture 5: What we will create

Lecture 6: Project design and sketch

Lecture 7: Create Project directory and Python File

Lecture 8: Create Application GUI – Part 1

Lecture 9: Create Application GUI – Part 2

Lecture 10: Create and activate a virtual environment

Lecture 11: Install Psycopg2 database adapter

Lecture 12: Create database configuration file

Lecture 13: Connect to PostgreSQL Database from Python file

Lecture 14: Create a class and methods

Lecture 15: Create standalone functions

Lecture 16: Binding button widgets to functions

Lecture 17: Testing the application

Lecture 18: Viewing database data with SQL

Lecture 19: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 16 votes

4 stars: 27 votes

5 stars: 39 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!