Search

Fulltext results:

top

22 Hits, Last modified: 5 years ago

**Vassar College, Fall 2021** \\ **Syllabus / Course Wiki** \\ // Welcome to our course wiki. It will be updated throughout the semester with important course information, so check here regularly. // ====

week5

5 Hits, Last modified: 5 years ago

==== Week 5 ====== ===== Join Queries ===== {{:courses:cs311-2021:joy-of-joins.png?nolink|}} Queryin... bouseur for permission to use his materials!)) on our postgres server: * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP snapshot}} * Starter script: {{ :courses:cs311-2021:cap-queries-joins.sql.txt | cap-que

techref

4 Hits, Last modified: 5 years ago

inal window open up an SSH tunnel through mote to our postgres server: <code> $ ssh -L 5555:postgres:54... edu </code> \\ where ''username'' is the name of your CS account. Then from a second local terminal window access our postgres server directly from the command line: <... de> \\ where ''username'' is (again) the name of your CS account, and ''dbname'' is the name of the dat

resources

3 Hits, Last modified: 5 years ago

gure DBeaver with an [[techref|SSH Tunnel]] from your laptop: \\ {{dbeaver-tunnel-screenshot.png?200|}}... * [[https://youtu.be/qw--VYLpxG4|PostgreSQL in 4 hours]]: Learn PostgreSQL Tutorial on YouTube * [[http://www.sqlcourse.com/|SQL Course]] * [[https://www.w3schools.com/sql/|SQL Tutorial by w3schools]] * [[https:/

week3

3 Hits, Last modified: 5 years ago

elcome back!! \\ \\ Querying the CAP Database on our postgres server: * //with thanks to Alan Labous... materials!// :-) * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP... Be certain to end each query with a semi-colon. Your final script should execute all of the queries in... * \\ * Nested queries * Starter script: {{ :courses:cs311-2021:cap-queries-nested.sql.txt |cap-que

assigns

2 Hits, Last modified: 5 years ago

ls8&utm_campaign=designshare&utm_medium=link&utm_source=sharebutton|Presentation]] | | 6 | Hero ... sar) * Business accelerator / Venture Capital (source: non-profit.org) * Olympic-related (countries

sidebar

2 Hits, Last modified: 5 years ago

d|Schedule]] * [[assigns|Assignments]] * [[resources|Resources]] * [[techref|Tech Ref]] * [[https://learn.zybooks.com|zyBook]] * [[https://jrebel.

week4

2 Hits, Last modified: 5 years ago

bouseur for permission to use his materials!)) on our postgres server: * CAP database creation {{ :courses:cs311-2021:cap.txt |script}} * {{cap.pdf|CAP

sched

1 Hits, Last modified: 5 years ago

ase project names for postgres, identifying data sources, design and normalization, query brainstorming

week6

1 Hits, Last modified: 5 years ago

sar) * Business accelerator / Venture Capital (source: non-profit.org) * Olympic-related (countries