Data normalization and modelings in SQL
Employees, departments, and salaries, oh my!
This is a classic demonstration of SQL queries on an employee database. The tables are normalized so queries across them align on unique id numbers.
The schema and queries folder has the table creation information as well as the queries to find general information about the employees at PH. It also includes an example of importing SQL into Python tables using SQL Alchemy and plotting average salaries by title using pandas and matplotlib.
