GitHub - tomwright01/swc-modular-sql: Repo for converting Software carpentry novice SQL lessons to modular format

tomwright01 / swc-modular-sql Public

Notifications You must be signed in to change notification settings
Fork 1
Star 0

Repo for converting Software carpentry novice SQL lessons to modular format

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 61 Commits
img		img
00-setup.ipynb		00-setup.ipynb
00-setup.md		00-setup.md
01-select.ipynb		01-select.ipynb
01-select.md		01-select.md
02-sort-dup.ipynb		02-sort-dup.ipynb
02-sort-dup.md		02-sort-dup.md
03-filter.ipynb		03-filter.ipynb
03-filter.md		03-filter.md
04-calc.ipynb		04-calc.ipynb
04-calc.md		04-calc.md
05-null.ipynb		05-null.ipynb
05-null.md		05-null.md
06-agg.ipynb		06-agg.ipynb
06-agg.md		06-agg.md
07-join.ipynb		07-join.ipynb
07-join.md		07-join.md
08-create.ipynb		08-create.ipynb
08-create.md		08-create.md
09-prog.ipynb		09-prog.ipynb
09-prog.md		09-prog.md
README.txt		README.txt
gen-survey-database.sql		gen-survey-database.sql
index.md		index.md
sqlitemagic.py		sqlitemagic.py

Repository files navigation

# Time estimates for instructors

* n = 1
* median = 3 hours

# Resources

*   `gen-survey-database.sql`: re-generate survey database used in examples.
*   `sqlitemagic.py`: IPython Notebook plugin to support SQLite interaction.

# Notes

* Run 'sqlite3 survey.db < gen-survey-database.sql' to re-create survey database before loading notebooks.