SQLAlchemy Basics Course

Go to class
Write Review

Free Online Course: SQLAlchemy Basics Course provided by Treehouse is a comprehensive online course, which lasts for 3-4 hours worth of material. The course is taught in English and is free of charge. SQLAlchemy Basics Course is taught by Megan Amendola.

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