Skip to content

whysoq520/EmployeeSQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

35 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Employee SQL Queries and report

Tools:

  1. Python 3.7 - SQLAlchemy
  2. PostgreSQL

Results:

  1. Data Modeling ** Create ER diagram with online QuickDBA** http://www.quickdatabasediagrams.com. erd.png

  2. Data Engineering created a table schema for each of the six CSV files (specify data types, primary keys, foreign keys, and other constraints). schema.png

  3. Create DataBase and tables in PostgreSQL Created EmployeeSQL database in postgreSQL, then used the schema to create tables in EmployeeSQL database. createdata.png

  4. Import each CSV file into the corresponding SQL table.
    importtables.png

  5. Salaries Range

salaries.png

  1. Job Titile Salaries

titlesalaries.png

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published