Internet
Seminar

Spring 2019
course
site

Tue March 26

Discuss status of and timeline for the server-side project. Can you present something a week from today?

I'll do a bit more SQL, then let you use the time to work on the project.

I've attached the files we created and the sqlite3 dialog that we did in class.

sql join

Look at this wikipedia explanation .

Joins come in different flavors.

sql recursive

Another way to generate a "temporary" table : the sqlite docs

An example

Work through exercise 10 of SQL Exercises - the warehouse , looking at the intermediate results by hand.

asides

https://cs.marlboro.college /cours /spring2019 /internet /notes /server2
last modified Thu March 28 2024 11:59 am

attachments [paper clip]

  last modified size
TXT command_line_sqlite3.txt Thu Mar 28 2024 11:59 am 7.0K
TXT create.sql Thu Mar 28 2024 11:59 am 415B
TXT populate.sql Thu Mar 28 2024 11:59 am 1.3K