Python Database Tutorials

Learn how to interact with and manage data in Python using databases. This knowledge will enable you to build data-intensive applications and help on your journey to becoming a web developer or data analyst.

This section contains all of our tutorials that are related to working with databases in Python. We cover things like SQL and NoSQL databases and how to interact with them using Python and various database frameworks and ORMs.

Real Python Podcast E255 Title Image

The Real Python Podcast – Episode #255: Structuring Python Scripts & Exciting Non-LLM Software Trends

Jun 27, 2025 intermediate ai best-practices career databases django

Introducing DuckDB

Starting With DuckDB and Python

Jun 24, 2025 intermediate databases data-science python

Build an LLM RAG Chatbot With LangChain

First Steps With LangChain

May 20, 2025 intermediate databases data-science

Python and MySQL Database: A Practical Introduction

MySQL Databases and Python

Apr 22, 2025 intermediate databases data-science

Real Python Podcast E247 Title Image

The Real Python Podcast – Episode #247: Exploring DuckDB & Comparing Python Expressions vs Statements

Apr 18, 2025 intermediate databases python

Introducing DuckDB

Introducing DuckDB

Mar 26, 2025 intermediate databases data-science python

Real Python Podcast E244 Title Image

The Real Python Podcast – Episode #244: A Decade of Automating the Boring Stuff With Python

Mar 21, 2025 basics databases tools

Introducing DuckDB

Introducing DuckDB

Mar 17, 2025 intermediate databases data-science python

Build an LLM RAG Chatbot With LangChain

Build an LLM RAG Chatbot With LangChain

Mar 06, 2025 intermediate databases data-science

Asynchronous Tasks With Django and Celery

Asynchronous Tasks With Django and Celery

Dec 08, 2024 advanced databases django web-dev

Web Scraping With Scrapy and MongoDB

Web Scraping With Scrapy and MongoDB

intermediate databases web-scraping

Web Scraping With Scrapy and MongoDB

Web Scraping With Scrapy and MongoDB

Aug 16, 2024 intermediate databases projects web-scraping

What Are CRUD Operations?

What Are CRUD Operations?

intermediate api databases web-dev

Real Python Podcast Episode #201 Title Artwork

The Real Python Podcast – Episode #201: Decoupling Systems to Get Closer to the Data

Apr 19, 2024 databases data-science python

Real Python Podcast Episode #200 Title Artwork

The Real Python Podcast – Episode #200: Avoiding Error Culture and Getting Help Inside Python

Apr 12, 2024 databases python web-scraping

Data Management With Python, SQLite, and SQLAlchemy

SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files

intermediate databases web-dev

Build an LLM RAG Chatbot With LangChain

Build an LLM RAG Chatbot With LangChain

intermediate ai databases data-science

Asynchronous Tasks With Django and Celery

Creating Asynchronous Tasks With Celery and Django

advanced databases django web-dev

Enhance Your Flask Web Project With a Database

Enhance Your Flask Web Project With a Database

intermediate databases flask web-dev

Embeddings and Vector Databases With ChromaDB

Embeddings and Vector Databases With ChromaDB

advanced ai databases data-science machine-learning

Real Python Podcast Episode #165 Title Artwork

The Real Python Podcast – Episode #165: Leveraging the Features of Your Database With Postgres and Python

Jul 21, 2023 databases django python

Real Python Podcast Episode #155 Title Artwork

The Real Python Podcast – Episode #155: Checking Project Dependencies & Python Dev Resource Collections

May 05, 2023 databases django tools

Microsoft Power BI and Python: Two Superpowers Combined

Microsoft Power BI and Python: Two Superpowers Combined

intermediate databases data-science data-viz tools

Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 3

Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 3

intermediate api databases flask web-dev

Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 2

Python REST APIs With Flask, Connexion, and SQLAlchemy – Part 2

intermediate api databases flask web-dev

Build a URL Shortener With FastAPI and Python

Building a URL Shortener With FastAPI and Python

intermediate api databases projects web-dev

Build a URL Shortener With FastAPI and Python

Build a URL Shortener With FastAPI and Python

intermediate api databases projects web-dev

Real Python Podcast Episode #107 Title Artwork

The Real Python Podcast – Episode #107: Type-Safe ORM With Prisma Client & Real Python at PyCon US 2022

Apr 22, 2022 best-practices community databases

Pandas: How to Read and Write Files

Reading and Writing Files With pandas

intermediate databases data-science

The Real Python Podcast

The Real Python Podcast – Episode #52: Connecting to MongoDB and Updates on the Python Packaging Landscape

Mar 19, 2021 databases python tools

Build a Contact Book With Python, PyQt, and SQLite

Build a Contact Book With Python, PyQt, and SQLite

intermediate databases gui projects

Introduction to MongoDB and Python

Python and MongoDB: Connecting to NoSQL Databases

intermediate databases

Python and MySQL Database: A Practical Introduction

Python and MySQL Database: A Practical Introduction

intermediate databases data-science

Handling SQL Databases With PyQt: The Basics

Handling SQL Databases With PyQt: The Basics

intermediate databases gui

The Real Python Podcast

The Real Python Podcast – Episode #34: The Python Modulo Operator & Managing Data With SQLite and SQLAlchemy

Nov 06, 2020 databases projects python

Data Management With Python, SQLite, and SQLAlchemy

Data Management With Python, SQLite, and SQLAlchemy

intermediate databases web-dev

The Real Python Podcast

The Real Python Podcast – Episode #16: Thinking in Pandas: Python Data Analysis the Right Way

Jul 03, 2020 databases data-science numpy

Introduction to Python SQL Libraries

Introduction to Python SQL Libraries

basics databases tools

Data Engineer Interview Questions With Python

Data Engineer Interview Questions With Python

intermediate databases devops

Pandas: How to Read and Write Files

pandas: How to Read and Write Files

intermediate databases data-science

Preventing SQL Injection Attacks With Python

Preventing SQL Injection Attacks With Python

intermediate best-practices databases

Django Migrations: A Primer

Digging Deeper Into Django Migrations

intermediate databases django web-dev

How to Use Redis With Python

How to Use Redis With Python

intermediate databases

How to Create an Index in Django Without Downtime

How to Create an Index in Django Without Downtime

advanced databases django

Django Migrations: A Primer

Django Migrations: A Primer

basics databases django web-dev

Building a Simple Web App With Bottle, SQLAlchemy, and the Twitter API

Building a Simple Web App With Bottle, SQLAlchemy, and the Twitter API

api databases projects web-dev

Deploying Django + Python 3 + PostgreSQL to AWS Elastic Beanstalk

Deploying Django + Python 3 + PostgreSQL to AWS Elastic Beanstalk

advanced databases devops django web-dev

Share Feedback