Search

Fulltext results:

techref

34 Hits, Last modified: 4 years ago

-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

19 Hits, Last modified: 4 years ago

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]

week3

8 Hits, Last modified: 4 years ago

:-) * 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 name of people who

resources

6 Hits, Last modified: 4 years ago

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 * [[

assigns

4 Hits, Last modified: 4 years ago

/docs.google.com/presentation/d/14ZGspXHp_mwviHXyy033yvY5Kty7BtgS5p171-ZFqzs/edit?usp=sharing_eil_dm&ts=61a5450c|Presentation]] ... s://docs.google.com/presentation/d/1h_L6wnOBK6s9B-0g6aR-bCdrnroQMXbD6RsBebC9MO4/edit?usp=drive_web|Pr... presentation/d/1eVOAbWnWPg_lOZmwqR_XCfVuuWPLjvrTlz0DSe1x33A/edit|Presentation]]

sched

4 Hits, Last modified: 4 years ago

====== 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 *

week5

3 Hits, Last modified: 4 years ago

==== ===== Join Queries ===== {{:courses:cs311-2021:joy-of-joins.png?nolink|}} Querying the CAP Da... ver: * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP snapshot}} * Starter script: {{ :courses:cs311-2021:cap-queries-joins.sql.txt | cap-queries-joins.s

week4

2 Hits, Last modified: 4 years ago

ver: * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP snapshot}} ... rebel.com/sites/rebel/files/pdfs/sql-cheat-sheet-2021-web.pdf|SQL cheatsheet PDF]] in the left sideba

week10

2 Hits, Last modified: 4 years ago

====== 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

sidebar

1 Hits, Last modified: 4 years ago

at Sheet]] * [[https://www.jrebel.com/sites/rebel/files/pdfs/sql-cheat-sheet-2021-web.pdf|PDF]]

week6

1 Hits, Last modified: 4 years ago

d 3.5NF [[https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form|BCNF (Boyce-Codd NF)]] -- elim