Skip to content
/ Udacity_PostgreSQL_For_Data_Analysis Public

This repo contains the practice postgreSQL queries from the course "SQL for Data Analysis" of Udacity. It uses the parch and posey database.

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

HemaPriyaVelaga/Udacity_PostgreSQL_For_Data_Analysis

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
L1_postgresql_Basic.sql
L1_postgresql_Basic.sql
 
 
L2_postgresql_Joins.sql
L2_postgresql_Joins.sql
 
 
L3_postgresql_Aggregations.sql
L3_postgresql_Aggregations.sql
 
 
L4_postgresql_SubQueries_TempTables.sql
L4_postgresql_SubQueries_TempTables.sql
 
 
L5_postgresql_DataCleaning.sql
L5_postgresql_DataCleaning.sql
 
 
L6_postgresql_advanced_WindowFunctions.sql
L6_postgresql_advanced_WindowFunctions.sql
 
 
L7_postgres_advanced_SQLjoins_PerformanceTuning.sql
L7_postgres_advanced_SQLjoins_PerformanceTuning.sql
 
 
README.md
README.md
 
 
erd-parch.png
erd-parch.png
 
 
parch-and-posey.sql
parch-and-posey.sql
 
 

Repository files navigation

PostgreSQL For Data Analysis - Udacity Course

This repository contains all the practice SQL questions and the solution queries that are a part of this course

The entire course uses a database called "Parch and Posey" which has info about a paper selling (imaginary)company.

ERD of Parch&Posey postgreSQL database

About

This repo contains the practice postgreSQL queries from the course "SQL for Data Analysis" of Udacity. It uses the parch and posey database.

Topics

postgresql performance-tuning joins aggregation subqueries window-functions

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published