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

Treehouse

SQLAlchemy Basics Course (How To)

via Treehouse

Overview

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

Syllabus

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

Taught by

Megan Amendola

Reviews

Start your review of SQLAlchemy Basics Course (How To)

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.