PostgreSQL Projects
Medical Data Normalization
• Created an ER Diagram by inspecting the table containing information about patients and products used, and outcomes
• Used postgres to normalize data to third normal form, which involves removing duplicates, exploring candidate keys, and removing functional dependencies
• Ran queries that involve: joins, subqueries, aggregation and HAVING
• Wrote CREATE TABLE statements to implement the data model
Air BnB Data Analysis
• Performed both a python and SQL analysis. In the SQL analysis:
• Created a staging table for Air BnB data set by inspecting the data and its data types.
• Cleaned up the dataset to remove any null values.
• Calculated several statistics such as average price of listings per neighborhood, average price of each room type, the counts for each room type, and the least and most expensive listings.