Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQLAlchemy Basics!
You have completed SQLAlchemy Basics!
Preview
Use queries to create a small analysis of your book database.
Challenges
- Try creating one menu function
- Add docstrings to each function
- Add type hinting
- Try creating pagination for the books so you only see 5 books at a time when viewing them
- Try giving the user options for searching for a book (besides searching by id)
- Try adding other columns to your database like topic area, difficulty level, number of pages, etc.
- Try creating a practice app using SQLAlchemy!
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
I've chosen a few small items, but
I encourage you to think of your own and
0:00
add them here as well.
0:01
The ones I came up with are the most
recently published book in the database,
0:03
the oldest book in the database and
the total number of books in the database.
0:08
Let's start with the newest
book in the database.
0:14
Let's create a variable
called newest_book.
0:16
And it should be equal
0:21
to session.query(Book).order
0:24
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up