Differences

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

--- people:mlsmith:teaching [2019/07/22 11:00]
mlsmith [Programming Languages]
+++ people:mlsmith:teaching [2019/12/18 16:57]
mlsmith [First-year computer science]
@@ Line 8: / Line 8: @@
   * [[http://www.racket-lang.org/|Racket]] - Includes the DrRacket programming environment\\
   * [[http://www.wescheme.org/|WeScheme]] - Web-based programming environment
+  * [[https://cs.brown.edu/courses/csci0111/index.html|CSCI 0111]] - Brown CS Computing Foundations
   * [[https://cs.uwaterloo.ca/~plragde/flaneries/FDS/|Functional Data Structures]] – a flânerie by [[https://cs.uwaterloo.ca/~plragde/flaneries/|Prabhakar Ragde]]
   * [[http://www.ccs.neu.edu/home/matthias/htdc.html|How to Design Classes]]
@@ Line 17: / Line 18: @@
   * Shriram’s [[http://cs.brown.edu/courses/csci1730/2012/|Introduction to Programming Languages]] course (archived)
   * Matthew’s [[http://www.eng.utah.edu/~cs5510/|Programming Languages]] course (Fall 2017)
-  * [[http://www.youtube.com/playlist?list=PLXr4KViVC0qLyXpinlARzSDWaQTCzaGw3|RacketCon 2013]]
+  * [[https://www.youtube.com/user/racketlang/videos|RacketCon]] video presentations
-  * [[https://www.youtube.com/playlist?list=PLXr4KViVC0qJp4_2uTTAOjt-4URQBAR4c|RacketCon 2019]]
 ==== Relational Databases ====
@@ Line 31: / Line 32: @@
   * Lectures / Tutorials
     * [[https://youtu.be/nWyyDHhTxYU|Learn SQL with Socratica]]: a YouTube lecture series
+    * [[http://www.postgresqltutorial.com/|PostgreSQL Tutorial]]
+    * [[https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04|How to Install and Use PostgreSQL]]
     * [[https://youtu.be/qw--VYLpxG4|PostgreSQL in 4 hours]]: Learn PostgreSQL Tutorial on YouTube
     * [[http://www.sqlcourse.com/|SQL Course]]
     * [[https://www.w3schools.com/sql/|SQL Tutorial by w3schools]]
-  * Texts
+    * [[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.:
-    * [[https://opentextbc.ca/dbdesign01/|Database Design, Second Edition]], by Adrienne Watt
+      * 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]]
+==== 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]]