Employee Data Engineering (SQL)

SQL Data Engineering Project - Pewlett Hackard:

Data Modeling:
● Inspected six CSV files to understand the dataset.
● Created an Entity Relationship Diagram (ERD) to visualize table relationships using tools like QuickDBD.

Data Engineering:
● Designed a table schema for each CSV file, specifying data types, primary keys, foreign keys, and constraints.
● Ensured uniqueness for primary keys or created composite keys for unique identification.
● Created tables in the correct order to handle foreign keys.
● Imported each CSV file into its respective SQL table.

Data Analysis:
● Listed employee numbers, last names, first names, sex, and salaries for all employees.
● Listed first names, last names, and hire dates for employees hired in 1986.
● Provided details about managers, including department number, name, employee number, last name, and first name.
● Displayed department numbers, employee numbers, last names, first names, and department names for each employee.
● Listed first names, last names, and sex of employees named Hercules with last names starting with the letter B.
● Provided details of employees in the Sales department, including employee numbers, last names, and first names.
● Listed employees in the Sales and Development departments, including employee numbers, last names, first names, and department names.
● Presented frequency counts of employee last names in descending order.

Conclusion:
● Successfully completed data modeling, engineering, and analysis tasks for Pewlett Hackard.
● Demonstrated proficiency in SQL, database design, and data analysis.
● Contributed to understanding and extracting valuable insights from historical employee data.
● Highlighted skills essential for data engineering roles.