Ksherbina Week 6

Katrina Sherbina

Class Page    User Page

Assignment Description

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Week 12

Week 13

Week 15

Class Journal

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Individual Journal

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Other

Week 5: Database Wiki

Final Project

Team H(oo)KD Project Page

Journal Club Presentation

Project Individual Journal

Movies from Text Files to Tables

1. Code:

select * from movie where year < 1915

Output:

4975;1909;"D.W. Griffith: Years of Discovery 1909-1913"
7654;1896;"Lumiere Brothers' First Films"
9103;1914;"Tillie's Punctured Romance"
10898;1914;"Cabiria"

2. Code:

select * from movie where year > 1979 and year < 1990 and title ~ '[0-9][0-9][0-9][0-9]'

Output:

217;1988;"Cherry 2000"
1163;1984;"2010: The Year We Make Contact"
1399;1984;"1984"
1480;1988;"Cold Summer of 1953"
4882;1985;"Butthole Surfers: Blind Eye See All: Live 1985"
5482;1989;"Gundam 0080: War in the Pocket"
5890;1985;"Transylvania 6-5000"
7725;1984;"Hong Kong 1941"
15128;1988;"1969"
15269;1989;"Mystery Science Theater 3000: The Crawling Hand"
15390;1987;"Eric Clapton & Friends: Live 1986"
16985;1982;"The 2000 Year Old Man"
17007;1987;"Teenage Mutant Ninja Turtles (1980s)"

3. Code:

select * from movie where title ~ '

Output:

4;1994;"Paula Abdul's Get Up & Dance"
9;1991;"Class of Nuke 'Em High 2"
19;2000;"By Dawn's Early Light"
23;2001;"Clifford: Clifford Saves the Day! / Clifford's Fluffiest Friend Cleo"
27;1962;"Sesame Street: Elmo's World: The Street We Live On"
30;2003;"Something's Gotta Give"
32;2004;"ABC Primetime: Mel Gibson's The Passion of the Christ"
34;2003;"Ashtanga Yoga: Beginner's Practice with Nicki Doane"
37;1973;"Zatoichi's Conspiracy"
54;1952;"We're Not Married"