Lesson 1
Instructor Interview
Meet your instructor!
SQL and Data Modeling for the Web
Course
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
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
Intermediate
4 weeks
Real-world Projects
Completion Certificate
Last Updated March 5, 2024
SQLAlchemy • Flask • Object-relational mapping • Relational database transactions
Command line interface basics • Basic SQL • Basic web development
Course Lessons
Lesson 2
Course Introduction
Understand what this course will cover and the learning objectives achieved.
Lesson 3
Interacting with Databases
Interact with relational databases. Review SQL and the Client-Server Model. Use Postgres, understand DBAPIs, and use psycopg2.
Lesson 4
SQLAlchemy Basics
Learn to use SQLAlchemy and SQLAlchemy ORM to work with a relational database in Python.
Lesson 5
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.
Lesson 6
Migrations
Handle changes to your database schema over time using a version control system involving migration files.
Lesson 7
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.
Lesson 8
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.
Lesson 9 • Project
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 The Best
Amy Hua
Instructor
Amy has 6+ years of experience as a software professional, building everything from data visualizations to self-driving cars. She's been a bootcamp instructor, StartupBus mentor, and Girls Who Code instructor.
The Udacity Difference
Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.
Demonstrate proficiency with practical projects
Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.
Gain proven experience
Retain knowledge longer
Apply new skills immediately
Top-tier services to ensure learner success
Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.
Get help from subject matter experts
Learn industry best practices
Gain valuable insights and improve your skills
Unlock access to SQL and Data Modeling for the Web and the rest of our best-in-class catalog
-
Unlimited access to our top-rated courses
-
Real-world projects
-
Personalized project reviews
-
Program certificates
-
Proven career outcomes
Full Catalog Access
One subscription opens up this course and our entire catalog of projects and skills.
Month-To-Month
4 Months
Average time to complete a Nanodegree program
Get Started Today
SQL and Data Modeling for the Web
Month-To-Month
- Unlimited access to our top-rated courses
- Real-world projects
- Personalized project reviews
- Program certificates
- Proven career outcomes
4 Months
- All the same great benefits in our month-to-month plan
- Most cost-effective way to acquire a new set of skills