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

Google, IBM & Meta Certificates – 40% Off a Year
One Coursera Plus subscription covers most Professional Certificates on Coursera. 40% off a full year through Dec 2.
Unlock All Certificates

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.

  • What is SQLAlchemy?
  • Creating a Model
  • Creating a Movie Model
  • Create and Read with SQLAlchemy
  • ORM, Models, and Creation
  • Update, Rollback, and Delete
  • Movie Database Continued
  • Querying
  • Querying the Movie Database
  • SQLAlchemy Fundamentals

Working with SQLAlchemy

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

  • Project Overview
  • Creating Our Book Database
  • Setting Up Our App
  • Import Book CSV
  • Cleaning Data
  • Create and Read Books
  • Search for a Book
  • Update and Delete Books
  • Analyze Books
  • Analyzing the Movie Database
  • SQLAlchemy Quiz

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.