Tanisha Cooper Logo Image
Tanisha Cooper

Project 4: PostgreSQL

The challenge was a research project on Pewlett Hackard employees from the 1980s and 1990s using SQL: data modeling, data engineering, and data anlysis.

Project Image

Project Overview

The challenge utlizized data modeling, engineering, and analysis to build a SQL database with six tables. Using employee data from historical csv files, the database and tables were sucessfully imported.

The objective included: inspect csv files, utilize QuickDatabase to create an ERD of the schema/tables, and complete data engineering and analysis.

Tools Used

SQLAlchemy
PostgreSQL
Github
GIT