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
Overview
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
