https://www.cs.vassar.edu/ 2026-06-09T13:26:48+00:00 https://www.cs.vassar.edu/ https://www.cs.vassar.edu/_media/favicon.ico text/html 2021-11-01T18:36:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week10?rev=1635791766&do=diff Week 10 Importing Data into Tables from CSV files Here's a reference on how to import data from a CSV file into a table via psql: <https://codeburst.io/two-handy-examples-of-the-psql-copy-meta-command-2feaefd5dd90> text/html 2021-09-20T18:25:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/sidebar?rev=1632162327&do=diff CMPU-311 * General * Schedule * Assignments * Resources * Tech Ref * zyBook * SQL Cheat Sheet * PDF text/html 2021-09-20T18:29:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.cs.vassar.edu/courses/cs311-2021/week4?rev=1632162591&do=diff Week 4 Nested Queries Querying the CAP Database on our postgres server: * CAP database creation [script] * [CAP snapshot] * Starter script: [cap-queries-nested.sql] * Class exercise: solutions to queries Reading assignment for next week: * zyBook Chapter 3: Database Design HW for next week: