This shows you the differences between two versions of the page.
Both sides previous revision
Previous revision
Next revision
|
Previous revision
Next revision
Both sides next revision
|
people:mlsmith:teaching [2019/07/25 00:45] mlsmith [Relational Databases] |
people:mlsmith:teaching [2019/08/30 13:51] mlsmith [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 | * [[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://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]] |
| |
| |