Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Advanced Python: Working with Databases

via LinkedIn Learning

Overview

Explore the database options for powering your Python apps. Learn how to create and connect to different types of databases, including SQLite, MySQL, and PostgreSQL.

Syllabus

Introduction
  • Using databases to level up your Python applications
1. Introduction to Databases in Python
  • What is a database?
  • Relational databases
  • Non-relational databases
  • Python Database API
2. Using SQLite in Python
  • What is SQLite?
  • Creating an SQLite database
  • Inserting your first record into an SQLite database
  • Adding multiple records at a time to an SQLite database
  • Filtering records in an SQLite database
  • What is SQLAlchemy?
  • Setting up a virtual environment for SQLAlchemy
  • Executing a SQL query with SQLAlchemy
  • Using the SQL expression language to write maintainable code
  • Challenge: Create an SQLite database
  • Solution: Create an SQLite database
3. Using MySQL in Python
  • What is MySQL?
  • Creating a MySQL database
  • Building tables in a MySQL database
  • Adding data to a MySQL database
  • Connecting a Python application to a MySQL database
  • Encapsulating database operations
  • Setting up MySQL in Python using SQLAlchemy
  • Building a model with SQLAlchemy ORM
  • Adding up a foreign key with SQLAlchemy ORM
  • Using SQLAlchemy Sessions to transact on a MySQL database
  • Retrieving data using SQLAlchemy ORM
  • Challenge: Create a MySQL database
  • Solution: Create a MySQL database
4. Using PostgreSQL in Python
  • What is PostgreSQL?
  • Creating a PostgreSQL database
  • Creating a table in Postgres using Python
  • Inserting data into a Postgres database
  • Interacting with a Postgres database using Python
  • Setting up SQLAlchemy Core to connect to a Postgres database
  • Manipulating with Postgres data using SQLAlchemy Core
  • Setting up SQLAlchemy ORM to connect to a Postgres database
  • Manipulating with Postgres data using SQLAlchemy ORM
  • Challenge: Create a Postgres database
  • Solution: Create a Postgres database
Conclusion
  • Continue using databases in Python applications

Taught by

Kathryn Hodge

Reviews

4.6 rating at LinkedIn Learning based on 203 ratings

Start your review of Advanced Python: Working with Databases

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.