Udacity part of Accenture logo

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

  • 1 month

  • Last Updated November 19, 2024

Skills you'll learn:

SQLAlchemyFlask

Prerequisites:

Command line interface basicsBasic SQLBasic web developmentBasic PythonRelational database basics

Intermediate

1 month

Last Updated November 19, 2024

Skills you'll learn:

SQLAlchemy • Flask • Object-relational mapping • Relational database transactions

Prerequisites:

Command line interface basics • Basic SQL • Basic web development

Course Lessons

Lesson 1

Instructor Interview

Meet your instructor!

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

Photo of Amy Hua

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

Enroll in SQL and Data Modeling for the Web. Choose the plan that works for you

All Access monthly

  • Cancel Anytime

  • Unlimited access to our top-rated courses

  • Hands-on projects with expert feedback

  • Personalized career coaching and interview prep

  • Program Certificates

Best Value

All Access bundle1

  • All the same great benefits as our monthly plan

  • The most cost-effective way to develop the skills you want

  1. 1Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.

Your subscription also includes:

SQL

(288)

2 months

Beginner

Udacity Accenture logo

Company

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

© 2011-2025 Udacity, Inc. "Nanodegree" is a registered trademark of Udacity. © 2011-2025 Udacity, Inc.
We use cookies and other data collection technologies to provide the best experience for our customers.