¶ Teaching
¶ First-year computer science
- Program by Design - The computer science core of a liberal arts education
- How to Design Programs - An Introduction to Programming and Computing
- Racket - Includes the DrRacket programming environment
- WeScheme - Web-based programming environment
- CSCI 0111 - Brown CS Computing Foundations
- Flâneries by Prabhakar Ragde
- Functional Introduction to CS Part I and Part II
- Functional Data Structures
- How to Design Classes
- Javalib (Github repo)
- Objects First with Java (video lectures)
- Kathi Fisler's Infinite Trees
¶ Programming Languages
- Shriram's Introduction to Programming Languages course (archived)
- Matthew's Programming Languages course (Fall 2017)
- RacketCon video presentations
¶ Parallel Programming
¶ Relational Databases
- Software
- PostgreSQL (RDBMS)
- DBeaver Community (native IDE)
- pgAdmin (browser-based IDE)
- Courses
- Marist's Database Systems course, by Alan Labouseur
- with many links to further readings and resources
- Stanford's Introduction to Databases course, by Professor Jennifer Widom
- Marist's Database Systems course, by Alan Labouseur
- 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
- Ten SQL Concepts You Should Know for Data Science Interviews
- 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: PDF
- I have the original 1989 poster hanging in my office. Here's a scan:
- Texts and References
- Database System Concepts, Seventh Edition, by Silberschatz, Korth, and Sudarshan
- Database Design, Second Edition, by Adrienne Watt
- SQL Cheat Sheet
- SQL Cheat Sheet by Luke Harrison
¶ Github
- Git cheat sheets
- GitHub Flow guide
- GitHub-Flavored Markdown guide
- GitHub Classroom Getting Started Guide
¶ Online
- Student-centered remote teaching: lessons learned
- 5 Low-Tech, Time-Saving Ways to Teach Online During Covid-19
- How to Be a Better Online Teacher: Advice Guide