Advanced Python: Working with Databases 🐍💾📚

Table of Contents

1. Course Overview
2. Course Modules
3. Progress
4. Running Locally
5. Credits

Course Overview

Advanced developers are expected to master database selections, and this course provides an excellent comparison of different types of databases that Python can interact with—SQLite, MySQL, and PostgreSQL. Taught by Kathryn Hodge, this course takes you through the essentials of setting up, querying, and optimizing databases in Python.

Course Modules

Introduction to Databases in Python

• Database definition and types
• Python Database API

Using SQLite in Python

• Creating SQLite database
• Adding multiple records
• Filtering records
• SQLAlchemy
• SQL expression language
• Chapter Challenge

Using MySQL in Python

• Creating MySQL database
• Building Tables
• Inserting Data
• Connecting a Python app to MySQL
• Encapsulating database operations
• Chapter Challenge

Using PostgreSQL in Python

• Creating PostgreSQL database
• Building Tables
• Inserting Data
• Interacting with Postgres using Python
• Encapsulating database operations
• Chapter Challenge

Progress

• Introduction to Databases in Python
• Using SQLite in Python
• Using MySQL in Python
• Using PostgreSQL in Python

Running Locally

See the "Running Locally" section in the original repo's README for steps on how to run the code locally.

Credits

This repository is a personal fork based on the LinkedIn Learning course 'Advanced Python: Working with Databases' by Kathryn Hodge. The original course and repository can be found here.

Original Instructor

Kathryn Hodge

Software Engineer

I highly recommend checking out the full course for a deep dive into advanced Python database interactions, as well as Kathryn Hodge's other courses on LinkedIn Learning.