You'll learn the skills needed to traverse the stack and develop an entire database-backed web application. By the end of the course, you'll have the fundamentals you need to start building web applications, including how to do Create, Read, Update, and Delete (CRUD) operations on a database, how to apply these operations across both databases and web applications, how to set up relationships between elements of an application, and ultimately how to think about important principles and patterns in building data models for a web application
Overview
Syllabus
- Instructor Interview
- Meet your instructor!
- Course Introduction
- Understand what this course will cover and the learning objectives achieved.
- Interacting with Databases
- Interact with relational databases. Review SQL and the Client-Server Model. Use Postgres, understand DBAPIs, and use psycopg2.
- SQLAlchemy Basics
- Learn to use SQLAlchemy and SQLAlchemy ORM to work with a relational database in Python.
- SQLAlchemy ORM in Depth
- Get to know Model.query and the SQLAlchemy Object Lifecycle to master how to query for and change records in a database.
- Migrations
- Handle changes to your database schema over time using a version control system involving migration files.
- Build a CRUD App with SQLAlchemy - Part 1
- Build out the ability to read and create todo items in our To-do app, handling changes from the database to the views.
- Build a CRUD App with SQLAlchemy ORM - Part 2
- Finish developing our To-Do app with update and delete functionality. Model relationships with To-Do lists.
- Project: Fyyur
- In this project, you'll demonstrate your new SQL and data modeling skills by creating a site to help coordinate bookings between artists and venues.
Taught by
Amy Hua
