Skip to content

Challenger for UNCC Data Analytics Bootcamp involving SQLAlchemy using data regarding the weather in Hawaii

Notifications You must be signed in to change notification settings

RickGrimesCodes/Module-9-Challenge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Module 9 PostgreSQL Challenge for UNCC Data Analytics Bootcamp

Hello graders! This challanges was awesome introduction to SQL!

File Directories

Connection String

  • connectionstring.py

Data

  • departments.csv
  • dept_emp.csv
  • dept_manager.csv
  • employees.csv
  • salaries.csv
  • titles.csv

Information

  • csvinfo.txt - contains information about the CSV files
  • databasediagram.txt - database diagram
  • img.png - screenshot of the database diagram

PostgreSQL Scripts

  • analysis.sql - analysis script
  • create_table.sql - create table script

Screenshot of diagram and of the sql script being executed

img image

About

Challenger for UNCC Data Analytics Bootcamp involving SQLAlchemy using data regarding the weather in Hawaii

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published