/employee_query_sql

Primary LanguageJupyter Notebook

employee_query_sql

EmployeeSQL Folder

contains all Resource .csv files used to create tables for SQL database.

EmployeesDBD.sql

exported SQL file used to create diagram for Tables and Key References.

QuickDBD-Employees DBD.png

Reference image of database diagram.

employees_query.sql

SQL queries used to create the tables and key references for each csv.

analysis_query.sql

Example Query Reference Guide
SQL queries into employee database for analysis, e.g. associated salaries, titles, department, management references, etc.

SQL_engine.ipynb

jupyter notebook analysis utilizing SQLALechmy to query and review common salary ranges visualized within a histogram, as well as average salary for each employment title charted in a bar plot.