Differences

This shows you the differences between two versions of the page.

--- people:mlsmith:teaching [2019/07/25 00:45]
mlsmith [Relational Databases]
+++ people:mlsmith:teaching [2023/04/11 22:55] (current)
mlsmith
@@ Line 1: / Line 1: @@
 ===== Teaching =====
 ~~NOTOC~~
+==== General ====
+  * [[https://www.csprofessor.org/|Computer Science Educator's Hub]]
 ==== First-year computer science ====
@@ Line 8: / Line 11: @@
   * [[http://www.racket-lang.org/|Racket]] - Includes the DrRacket 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)
+  * Kathi Fisler's [[people:mlsmith:infinite-trees|Infinite Trees]]
 ==== Programming Languages ====
@@ Line 19: / Line 27: @@
   * [[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 ====
@@ Line 36: / Line 48: @@
     * [[http://www.sqlcourse.com/|SQL Course]]
     * [[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://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]]