Differences

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

--- people:mlsmith:teaching [2019/07/22 15:09]
mlsmith [Programming Languages]
+++ people:mlsmith:teaching [2019/08/30 13:51]
mlsmith [Relational Databases]
@@ Line 31: / Line 31: @@
   * 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]]