Computer Science | Vassar College
Computer Science | Vassar College
  • Log In

CMPU-311

CMPU-311

  • General
  • Schedule
  • Assignments
  • Resources
  • Tech Ref
  • zyBook
  • SQL Cheat Sheet
    • PDF
  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Pinterest
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
    • Teams
  • Recent Changes
  • Send via e-Mail
  • Print
  • Permalink

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
    • A Complete 15 Week Curriculum to Master SQL for Data Science
    • 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
Computer Science | Vassar College

Computer Science | Vassar College