==== Relational Databases ====

  * Software
    * [[https://www.postgresql.org/|PostgreSQL]] (RDBMS)
    * [[https://dbeaver.io/|DBeaver Community]] (native IDE)
      * Here's a screenshot of how to configure DBeaver from a CS linux workstation: \\ {{dbeaver-screenshot.png?200|}}
      * And here's a screenshot of how to configure DBeaver with an [[techref|SSH Tunnel]] from your laptop: \\ {{dbeaver-tunnel-screenshot.png?200|}}
    * [[https://www.pgadmin.org/|pgAdmin]] (browser-based IDE)
  * 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]]
    * [[https://www.sqltutorial.org/|SQL Tutorial]] and [[https://www.sqltutorial.org/sql-cheat-sheet/|SQL Cheat Sheet]]
    * [[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 |}}