SQLAlchemy Basics Course (How To)

Creating a SQL database including model creation and CRUD using SQLAlchemy.

What you'll learn

• Create a database model
• Interact with a database using CRUD (create, read, update, and delete)
• Use queries to access specific information

Introduction to SQLAlchemy

Learn about SQLAlchemy, a Python Object Relational Mapper, to create and interact with a database.

Chevron 10 steps

• What is SQLAlchemy?

  6:37

• Creating a Model

  8:37

• Creating a Movie Model

  3 objectives

• Create and Read with SQLAlchemy

  8:57

• ORM, Models, and Creation

  6 questions

• Update, Rollback, and Delete

  11:32

• Movie Database Continued

  4 objectives

• Querying

  15:18

• Querying the Movie Database

  2 objectives

• SQLAlchemy Fundamentals

  5 questions

Working with SQLAlchemy

Use your knowledge of Python and SQLAlchemy to create a command-line application.

Chevron 11 steps

• Project Overview

  8:13

• Creating Our Book Database

  8:04

• Setting Up Our App

  9:56

• Import Book CSV

  10:28

• Cleaning Data

  8:45

• Create and Read Books

  17:33

• Search for a Book

  12:06

• Update and Delete Books

  15:47

• Analyze Books

  9:28

• Analyzing the Movie Database

  1 objective

• SQLAlchemy Quiz

  5 questions