Difference between revisions of "Tutorials"
Jump to navigation
Jump to search
m (DRW moved page Programming Tutorials to Tutorials: Generalizing from programming tutorials to just tutorials) |
(Add tutorials on data organization and data cleaning) |
||
| Line 1: | Line 1: | ||
* [https://kbroman.org/dataorg/ Organizing Data in Spreadsheets] - Tips on how to store data in a spreadsheet in a way that will make it easiest to sustainably work with. | |||
* [https://www.youtube.com/watch?v=7Ma8WIDinDc Data Cleaning Principles] - A video of a talk from csv,conf6 on how to approach and think about cleaning data. The slides are [https://kbroman.org/Talk_DataCleaning/data_cleaning.pdf here]. | |||
* [https://missing.csail.mit.edu/ The Missing Semester] - A series of MIT class videos teaching a lot of practical things that developers need to know. | * [https://missing.csail.mit.edu/ The Missing Semester] - A series of MIT class videos teaching a lot of practical things that developers need to know. | ||
* [https://gitlab.com/slackermedia/bashcrawl bashcrawl] - A text adventure to teach shell skills. | * [https://gitlab.com/slackermedia/bashcrawl bashcrawl] - A text adventure to teach shell skills. | ||
Revision as of 02:02, 6 June 2022
- Organizing Data in Spreadsheets - Tips on how to store data in a spreadsheet in a way that will make it easiest to sustainably work with.
- Data Cleaning Principles - A video of a talk from csv,conf6 on how to approach and think about cleaning data. The slides are here.
- The Missing Semester - A series of MIT class videos teaching a lot of practical things that developers need to know.
- bashcrawl - A text adventure to teach shell skills.
- SQL Murder Mystery - "The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime."
- "... If you really want to learn a lot about SQL, you may prefer a complete tutorial like Select Star SQL."
- An Introduction to VisiData - One way to learn the best power tool for exploring and analyzing CSV files, SQLite databases, Excel files, and many other file formats. VisiData is also handy for editing, manipulating, and joining CSV files. Click here to install it.