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

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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.