Learning Path ⋅ Skills: SQL Libraries, SQLite, SQLAlchemy, Redis, MySQL, MongoDB, ChromaDB, Data Management, NoSQL Databases, Vector Databases
Master database access in Python. Explore SQL libraries, manage data with SQLite and SQLAlchemy, integrate Redis, connect to MySQL and MongoDB, and work with ChromaDB for embeddings and vector databases. Start your journey to efficient data handling today!
Database Access With PythonLearning Path ⋅ 7 Resources
#1
Tutorial
Introduction to Python SQL LibrariesLearn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases and perform common database queries using a Python application.
#2
Course
SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat FilesLearn how to store and retrieve data using Python, SQLite, and SQLAlchemy as well as with flat files. Using SQLite with Python brings with it the additional benefit of accessing data with SQL. By adding SQLAlchemy, you can work with data in terms of objects and methods.
#3
Tutorial
How to Use Redis With PythonIn this step-by-step tutorial, you'll cover how to use both Redis and its Python client library. You'll learn a bite-sized slice of Redis itself and master the redis-py client library.
#4
Course
MySQL Databases and PythonLearn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices and tips to prevent SQL injection attacks.
#5
Tutorial
Python and MongoDB: Connecting to NoSQL DatabasesLearn how to use Python to interface with the NoSQL database system MongoDB. You'll get an overview of the differences between SQL and NoSQL, and you'll also learn about related tools, including PyMongo and MongoEngine.
#6
Course
Starting With DuckDB and PythonLearn how to use DuckDB in Python to query large datasets with SQL or its Python API, handle files like Parquet or CSV, and integrate with pandas or Polars.
#7
Tutorial
Embeddings and Vector Databases With ChromaDBVector databases are a crucial component of many NLP applications. This tutorial will give you hands-on experience with ChromaDB, an open-source vector database that's quickly gaining traction. Along the way, you'll learn what's needed to understand vector databases with practical examples.
Got feedback on this learning path?
Looking for real-time conversation? Visit the Real Python Community Chat or join the next “Office Hours” Live Q&A Session. Happy Pythoning!
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4