Python & PostgreSQL: Build Database Applications

Python与PostgreSQL实战：构建数据库应用

掌握Python与PostgreSQL结合，从零构建真实数据库应用。本课程涵盖连接配置、SQL执行、增删改查及完整应用开发，适合中级学习者快速上手。无需PostgreSQL基础，轻松打造数据驱动项目。

Published 3/2026
Created by Ashutosh Pawar
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 36 Lectures ( 3h 49m ) | Size: 1.55 GB

Learn how to connect Python with PostgreSQL and build real database-driven applications step by step

What you’ll learn
✓ Connect Python applications to PostgreSQL databases
✓ Install and configure PostgreSQL and pgAdmin
✓ Execute SQL queries from Python programs
✓ Insert, retrieve, update, and delete database records
✓ Work with real database tables in Python applications
✓ Build a complete database-driven application using Python and PostgreSQL

Requirements
● Basic knowledge of Python programming
● Familiarity with basic programming concepts such as variables and functions
● No prior knowledge of PostgreSQL is required

Description
Python & PostgreSQL: Build Database Applications

Databases are a fundamental part of modern software development. In real-world applications, programs need to store, retrieve, and manage data efficiently. One of the most powerful open-source database systems used in production environments is PostgreSQL.

In this course, you will learn how to connect Python applications with PostgreSQL and build database-driven applications step by step.

Instead of only focusing on theory, this course emphasises practical learning through real coding examples. You will learn how Python programs communicate with a PostgreSQL database and how to perform common database operations directly from your Python code.

We will start by setting up PostgreSQL and creating a database. Then you will learn how to connect Python to PostgreSQL using a database driver and execute SQL queries from your Python programs.

You will also learn how to perform essential database operations such as

• inserting data

• retrieving records

• updating existing data

• deleting records

By the end of this course, you will build a complete database-driven application using Python and PostgreSQL, helping you understand how backend applications manage data in real-world systems.

This course is designed to help Python developers quickly learn how to integrate PostgreSQL databases into their applications.

What You Will Learn

• Connect Python applications to PostgreSQL databases

• Install and configure PostgreSQL and pgAdmin

• Execute SQL queries from Python programs

• Insert, retrieve, update, and delete database records

• Work with real database tables in Python applications

• Build a complete database-driven application using Python and PostgreSQL

Requirements

• Basic knowledge of Python programming

• Familiarity with basic programming concepts such as variables and functions

• No prior knowledge of PostgreSQL is required