SQLworkshop

Code and data to build a SQLite database of Fortune 500 stock data

Run make to build the SQLite database from the data here.

Name		Name	Last commit message	Last commit date
Latest commit History 51 Commits
SQLFortune500		SQLFortune500
pdf		pdf
sql_scripts		sql_scripts
.gitignore		.gitignore
Makefile		Makefile
README.md		README.md
SQL_Data_Set_01_April_10_18.xlsx		SQL_Data_Set_01_April_10_18.xlsx
SubqueryEg.md		SubqueryEg.md
all_stocks_5yr.csv		all_stocks_5yr.csv
day1_solutions.tex		day1_solutions.tex
day2_solutions.tex		day2_solutions.tex
day3_questions.tex		day3_questions.tex
day3_solutions.tex		day3_solutions.tex
fang.sql		fang.sql
index.html		index.html
join_notes.md		join_notes.md
little.R		little.R
matchTickerLocationCompanyNames.R		matchTickerLocationCompanyNames.R
sic-codes.csv		sic-codes.csv
sql_cheatsheet.pdf		sql_cheatsheet.pdf
subqueries.sql		subqueries.sql
to_sqlite.R		to_sqlite.R

Provide feedback