Skip to content

Programming for Data Science with Python subproject: Investigate a Relational Database with SQL

Notifications You must be signed in to change notification settings

WangYuTum/project-investigateSQLDB-udacity

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Intro to Data Science Nanodegree Subproject

The repository contains the project information of the Investigate a Relational Database from Udacity Nanodegree Programming for Data Science with Python. Please refer to the course website for more details.

Project Goals

  1. Explore and query the Sakila DVD Rental database
  2. Answer 4 business/analytical questions by querying the database.

Database ERD

source: http://www.postgresqltutorial.com/postgresql-sample-database/

Questions and Query Results

Here is a list of questions and answers we want to investigate on the database. The SQL queries are provided in queries.sql.

Question 1

Question 2

Question 3

Question 4

About

Programming for Data Science with Python subproject: Investigate a Relational Database with SQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published