Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
people:mlsmith:teaching [2019/07/25 00:45]
mlsmith [Relational Databases]
people:mlsmith:teaching [2019/12/18 16:57] (current)
mlsmith [First-year computer science]
Line 8: Line 8:
   * [[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.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]]   * [[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]]   * [[http://​www.ccs.neu.edu/​home/​matthias/​htdc.html|How to Design Classes]]
Line 36: Line 37:
     * [[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+    * [[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]]
  
 +==== 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]]