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 Sun December 22 2024 4:03 am

attachments [paper clip]

  last modified size
TXT command_line_sqlite3.txt Sun Dec 22 2024 04:03 am 7.0K
TXT create.sql Sun Dec 22 2024 04:03 am 415B
TXT populate.sql Sun Dec 22 2024 04:03 am 1.3K