Search

You can find the results of your search below.

Matching pagenames:

Fulltext results:

techref
32 Hits, Last modified:
-d university Password for user mlsmith: psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits:
top
7 Hits, Last modified:
OTOC~~ **CMPU-311** \\ **Vassar College, Fall 2021** \\ **Syllabus / Course Wiki** \\ // Welcom... | ^ Office: | SP 104.5 ... | ^ Office Hours: | In person: Tue/Thu 10-12; Wed 1-3; //and by appointment// \\ [[https://vassar.zoom.us/j/8904060254?pwd=ZGN2OEdPNEpvMUVFTlphT0xSRk5jQT09|Zoom]
sched
4 Hits, Last modified:
====== Weekly Schedule ====== * Week 1: Aug 30, First class * Week 2: Sep 6, Labor Day (no class... es of the CAP database * [[week4|Week 4]]: Sep 20, nested queries * [[week5|Week 5]]: Sep 27, joi... tion, query brainstorming, challenges? * [[week10|Week 10]]: Nov 1 * Week 11: Nov 8 * Week 12: Nov 15 * Week 13: Nov 22 * Week 14: Nov 29 *
resources
3 Hits, Last modified:
S 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 * [[
week3
2 Hits, Last modified:
:-) * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP snapshot}} ... e, and price of products with quantity more than 1007. - List the first name and home city of people born in the 1950s. - List the prefix and last n... - List all fields for orders in February of US$20,000 or more. - List all orders from the custome
week10
2 Hits, Last modified:
====== Week 10 ====== ===== Importing Data into Tables from CSV files ===== Here's a reference on h... a table via psql: https://codeburst.io/two-handy-examples-of-the-psql-copy-meta-command-2feaefd5dd90
week6
1 Hits, Last modified:
d 3.5NF [[https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form|BCNF (Boyce-Codd NF)]] -- elim