courses:cs381-2020:resources

Relational Databases

Software
- PostgreSQL (RDBMS)
- DBeaver Community (native IDE)
  - Here's a screenshot of how to configure DBeaver from a CS linux workstation:
  - And here's a screenshot of how to configure DBeaver with an SSH Tunnel from your laptop:
- pgAdmin (browser-based IDE)
Lectures / Tutorials
- Learn SQL with Socratica: a YouTube lecture series
- PostgreSQL Tutorial
- How to Install and Use PostgreSQL
- PostgreSQL in 4 hours: Learn PostgreSQL Tutorial on YouTube
- SQL Course
- SQL Tutorial by w3schools
- SQL Tutorial and SQL Cheat Sheet
- 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:
  - and here is Marc Rettig's faithful recreation of the poster: rettignormalizationposter.pdf