Both sides previous revision Previous revision Next revision | Previous revision |
people:mlsmith:teaching [2019/07/25 00:45] – [Relational Databases] mlsmith | people:mlsmith:teaching [2023/04/11 22:55] (current) – mlsmith |
---|
===== Teaching ===== | ===== Teaching ===== |
~~NOTOC~~ | ~~NOTOC~~ |
| |
| ==== General ==== |
| * [[https://www.csprofessor.org/|Computer Science Educator's Hub]] |
| |
==== First-year computer science ==== | ==== First-year computer science ==== |
* [[http://www.racket-lang.org/|Racket]] - Includes the DrRacket programming environment\\ | * [[http://www.racket-lang.org/|Racket]] - Includes the DrRacket programming environment\\ |
* [[http://www.wescheme.org/|WeScheme]] - Web-based programming environment | * [[http://www.wescheme.org/|WeScheme]] - Web-based programming environment |
* [[https://cs.uwaterloo.ca/~plragde/flaneries/FDS/|Functional Data Structures]] – a flânerie by [[https://cs.uwaterloo.ca/~plragde/flaneries/|Prabhakar Ragde]] | * [[https://cs.brown.edu/courses/csci0111/index.html|CSCI 0111]] - Brown CS Computing Foundations |
* [[http://www.ccs.neu.edu/home/matthias/htdc.html|How to Design Classes]] | * [[https://papl.cs.brown.edu/2020/index.html|Programming and Programming Languages]] text |
* [[http://www.ccs.neu.edu/javalib/NewWorld/|Javalib]] | * [[https://cs.uwaterloo.ca/~plragde/flaneries/|Flâneries]] by Prabhakar Ragde |
| * Function Introduction to CS [[https://cs.uwaterloo.ca/~plragde/flaneries/FICS/|Part I]] and [[https://cs.uwaterloo.ca/~plragde/flane/FICS2/|Part II]] |
| * [[https://cs.uwaterloo.ca/~plragde/flaneries/FDS/|Functional Data Structures]] |
| * [[https://felleisen.org/matthias/HtDC/htdc.pdf|How to Design Classes]] |
| * [[https://github.com/TesterViera|Javalib]] (Github repo) |
* [[http://www.youtube.com/user/objectsfirstwithjava|Objects First with Java]] (video lectures) | * [[http://www.youtube.com/user/objectsfirstwithjava|Objects First with Java]] (video lectures) |
| * Kathi Fisler's [[people:mlsmith:infinite-trees|Infinite Trees]] |
| |
==== Programming Languages ==== | ==== Programming Languages ==== |
* [[https://www.youtube.com/user/racketlang/videos|RacketCon]] video presentations | * [[https://www.youtube.com/user/racketlang/videos|RacketCon]] video presentations |
| |
| ==== Parallel Programming ==== |
| |
| * [[http://www.pdcunplugged.org/|PDC Unplugged]] |
| * [[https://csinparallel.org/index.html|CSinParallel]] |
==== Relational Databases ==== | ==== Relational Databases ==== |
| |
* [[http://www.sqlcourse.com/|SQL Course]] | * [[http://www.sqlcourse.com/|SQL Course]] |
* [[https://www.w3schools.com/sql/|SQL Tutorial by w3schools]] | * [[https://www.w3schools.com/sql/|SQL Tutorial by w3schools]] |
* Texts | * [[https://towardsdatascience.com/ten-sql-concepts-you-should-know-for-data-science-interviews-7acf3e428185|Ten SQL Concepts You Should Know for Data Science Interviews]] |
| * [[http://marcrettig.me/blog/|Marc Rettig's blog]] where you can download the classic Data Normalization Poster which was given away as a gift for subscriptions to Database Programming and Design Magazine.: |
| * I have the original 1989 poster hanging in my office. Here's a scan: {{:people:mlsmith:5-rules-of-data-normalization.jpg?50|}} |
| * and here is Marc Rettig's faithful recreation of the poster: {{ :people:mlsmith:rettignormalizationposter.pdf |}} |
| * Texts and References |
* [[https://www.db-book.com/db7/|Database System Concepts, Seventh Edition]], by Silberschatz, Korth, and Sudarshan | * [[https://www.db-book.com/db7/|Database System Concepts, Seventh Edition]], by Silberschatz, Korth, and Sudarshan |
* [[https://opentextbc.ca/dbdesign01/|Database Design, Second Edition]], by Adrienne Watt | * [[https://opentextbc.ca/dbdesign01/|Database Design, Second Edition]], by Adrienne Watt |
| * [[https://jrebel.com/rebellabs/sql-cheat-sheet/|SQL Cheat Sheet]] |
| * [[https://websitesetup.org/sql-cheat-sheet/|SQL Cheat Sheet]] by Luke Harrison |
| |
| ==== Github ==== |
| |
| * [[https://education.github.com/git-cheat-sheet-education.pdf|Git cheat sheets]] |
| * [[https://enterprise.github.com/downloads/en/github-flow-cheatsheet.pdf|GitHub Flow guide]] |
| * [[https://enterprise.github.com/downloads/en/markdown-cheatsheet.pdf|GitHub-Flavored Markdown guide]] |
| * [[https://www.youtube.com/playlist?list=PLIRjfNq867bewk3ZGV6Z7a16YDNRCpK3u|GitHub Classroom Getting Started Guide]] |
| ==== Online ==== |
| |
| * [[https://er.educause.edu/blogs/2020/4/student-centered-remote-teaching-lessons-learned-from-online-education|Student-centered remote teaching: lessons learned]] |
| * [[https://www.chronicle.com/article/5-Low-Tech-Time-Saving-Ways/248519|5 Low-Tech, Time-Saving Ways to Teach Online During Covid-19]] |
| * [[https://www.chronicle.com/interactives/advice-online-teaching?cid=rclink|How to Be a Better Online Teacher: Advice Guide]] |