Difference between revisions of "Ksherbina Week 6"
From LMU BioDB 2013
(Added comments.) |
(Added more comments.) |
||
| Line 3: | Line 3: | ||
==Movies from Text Files to Tables== | ==Movies from Text Files to Tables== | ||
| − | <!-- 1. Code: select * from movie where year < 1915 | + | <!-- 1. Code: select * from movie where year < 1915 --> |
| + | <!-- 3. Code: select * from movie where title ~ '''' --> | ||
| + | <!-- 4. Code: select count(*) from movie where title ~ '^Star ' --> | ||
| + | <!-- 5. Code: select count(*) from movie where year > 1939 and year < 1950 --> | ||
| + | <!-- Part of 6: select * from movie inner join rating on (rating.movie = movie.id) where member = '42' and rating = '5' --> | ||
Revision as of 17:29, 26 September 2013
| 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 |
