Using SQL- relational databases

SQL project using PostgreSQL & pgAdmin to explore a database of employee records.

Team project performing ETL on 2020 U.S. Election data, using jupyter notebook, PostgreSQL, and quickDBD.

Fictional company Pewlett Hackard needs to determine the number of retiring employees per title and identify employees who are eligible to participate in a mentorship program. Both tasks are accomplished using SQL queries.

Data modeling, engineering, and analysis of employee data. Created an ERD and table schema, then loaded and analyzed data using PostgreSQL.

Implemented ETL process, exported csv files, and created an ERD diagram and relationship tables and schemas

delivering retirement metrics and work statistics from a large pool of data

Created SQL tables from multiple csv files and sketched and Entity Relationship Diagram

Creating SQL database using PostgreSQL and pgAdmin

Data Modeling, Engineering, SQL to search database for potential credit card fraud

retrieving data from the database with SQL

I design and create a relational database for a pizzeria in MySQL.

To answer important business questions for the company’s HR department, we utilized Postres SQL as the database to load, build, and host the company data. We used pgAdmin to run quarries and generated multiple analyses in a well-designed database with reporting capabilities. The final data reporting can be adapted by any large coorporation to pr…

Designed and Built a database for a pizzeria and ran custom SQL queries

A final group project for the UNC Chapel Hill Data Analytics and Visualization Boot Camp

Analysis of Employee data.

La idea fundamental de este proyecto es permitir la programación de citas a través de la web, con la capacidad de enviar confirmaciones por correo electrónico. Inicialmente, cada usuario podrá iniciar sesión para confirmar sus citas. Este sistema está especialmente diseñado para barberías.

The company Pewlett-Hackard wants to know the number of employess and the titles.The company also asked us to come up with numbers of elegible mentorship program. Number of retiress, their titles and departments.

By utilizing PostgreSQL via pgAdmin, this data analysis helps a large company prepare for a surge of employee retirements.

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