The school of progr amming and development n a n o d e g r e e s y L l a b u s




Download 1.17 Mb.
Pdf ko'rish
bet3/9
Sana02.03.2023
Hajmi1.17 Mb.
#43979
1   2   3   4   5   6   7   8   9
Bog'liq
Udacity Enterprise Syllabus Full Stack Web Developer nd0044
1667458021 (1), 1698295492
LESSON TITLE
LEARNING OUTCOMES
CONNECTING AND 
INTERACTING WITH 
DATABASES
• 
Describe and explain the client-server model.
• 
Describe and explain the TCP/IP communication protocol.
• 
Describe and explain the base unit of database work: transactions.
• 
Install the PostgreSQL database management system.
• 
Create and manage Postgres databases with the psql client.
• 
Install the psycopg2 Python+Postgres database driver.
• 
Create and manage Postgres databases using the psycopg2 Python 
database driver.
Nanodegree Program Overview
Learn More at 
WWW.UDACITY.COM/ENTERPRISE
5
FULL STACK WEB DEVELOPER
Course 1: SQL and Data Modeling for the Web
Master relational databases with the power of SQL, and leverage Python to incorporate database logic into 
your programs.
For your first project, you’ll be building out the data models and database for an artist/venue booking 
application. The fictitious startup Fy-yur is building a website that facilitates bookings between artists who 
can play at venues, and venues who want to book artists. 
This site:
• 
Lets venue managers and artists sign up, fill out their information, and list their availability for shows.
• 
Lets artists browse venues where they can play, and see what past/upcoming artists have been booked 
at a venue.
• 
Lets a venue manager browse artists that would like to play in their city, and see what past/upcoming 
venues where the artist has played/will be playing.
The goal of this project is to build out the data models for this booking application. A prototype design of 
the web app will be provided. You’ll use SQLAlchemy and Postgresql to build out the data models upon 
which this site will rely. You’ll write out both the raw SQL and SQLAlchemy commands to run for powering 
the backend functionality of the website.
Design a Venue Booking Database
Project


Nanodegree Program Overview
Course 1: SQL and Data Modeling for the Web, cont.

Download 1.17 Mb.
1   2   3   4   5   6   7   8   9




Download 1.17 Mb.
Pdf ko'rish

Bosh sahifa
Aloqalar

    Bosh sahifa



The school of progr amming and development n a n o d e g r e e s y L l a b u s

Download 1.17 Mb.
Pdf ko'rish