Skip to content

Explored employee data from the 1980s and 1990s through data modeling, engineering, and SQL analysis. Uncovered insights into demographics and trends.

Notifications You must be signed in to change notification settings

ericfayhuynh/SQL-Intro

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 

Repository files navigation

Intro to SQL Challenge

Objective

As a newly hired data engineer at Pewlett Hackard, the goal was to perform a comprehensive research project focused on employees hired during the 1980s and 1990s. This project involved data modeling, data engineering, and data analysis, with the aim of designing table schemas, importing CSV files into a SQL database, and answering specific questions related to the employee data.

Summary

Engaged in a multifaceted data engineering project at Pewlett Hackard, focusing on employees from the 1980s and 1990s. Created table schemas, imported CSV data, and conducted SQL-based data analysis to gain insights into employee demographics and trends.

Tools/Libraries Used

  • SQL
  • QuickDBD (for Entity Relationship Diagram creation)
  • SQL database management system (e.g., PostgreSQL)

About

Explored employee data from the 1980s and 1990s through data modeling, engineering, and SQL analysis. Uncovered insights into demographics and trends.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published