UDACITY
UDACITY Logo

SQL and Data Modeling for the Web 

  • Offered byUDACITY

SQL and Data Modeling for the Web
 at 
UDACITY 
Overview

Enhance your skills with our online course. Learn Data Modeling and SQL, master relational databases, and leverage Python for database logic

Duration

4 weeks

Total fee

69,700

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

SQL and Data Modeling for the Web
 at 
UDACITY 
Highlights

  • Earn a certificate from Udacity
  • Flexible learning program
  • Technical mentor support
  • Practical tips and industry best practices
  • Unlimited submissions and feedback loops
  • Additional suggested resources to improve
Read more
Details Icon

SQL and Data Modeling for the Web
 at 
UDACITY 
Course details

What are the course deliverables?
  • Understand what this course will cover and the learning objectives achieved
  • Interact with relational databases. Review SQL and the Client-Server Model. Use Postgres, understand DBAPIs, and use psycopg2
  • Learn to use SQLAlchemy and SQLAlchemy ORM to work with a relational database in Python
  • Get to know Model.query and the SQLAlchemy Object Lifecycle to master how to query for and change records in a database
  • Handle changes to your database schema over time using a version control system involving migration files
  • Build out the ability to read and create todo items in our To-do app, handling changes from the database to the views
  • Finish developing our To-Do app with update and delete functionality. Model relationships with To-Do lists
  • 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
Read more
More about this 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

SQL and Data Modeling for the Web
 at 
UDACITY 
Curriculum

Instructor Interview

Course Introduction

Interacting with Databases

SQLAlchemy Basics

SQLAlchemy ORM in Depth

Migrations

Build a CRUD App with SQLAlchemy - Part 1

Build a CRUD App with SQLAlchemy ORM - Part 2

Project: Fyyur

SQL and Data Modeling for the Web
 at 
UDACITY 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by UDACITY

Free
6 weeks
Beginner
– / –
4 months
Intermediate
Free
4 weeks
Intermediate
Free
1 hours
Beginner
View Other 435 CoursesRight Arrow Icon
qna

SQL and Data Modeling for the Web
 at 
UDACITY 

Student Forum

chatAnything you would want to ask experts?
Write here...