Difference between revisions of "CSC220 Schedule 2010"
(→Weekly Schedule) |
(→Weekly Schedule) |
||
Line 198: | Line 198: | ||
* [http://dev.mysql.com/doc/refman/5.0/en/join.html Joining tables] | * [http://dev.mysql.com/doc/refman/5.0/en/join.html Joining tables] | ||
* [http://dev.mysql.com/doc/refman/5.0/en/create-index.html Creating an '''Index'''] | * [http://dev.mysql.com/doc/refman/5.0/en/create-index.html Creating an '''Index'''] | ||
+ | * [http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html How MySQL uses '''Indexes'''] | ||
* [http://dev.mysql.com/doc/refman/5.0/en/create-view.html '''Creating''' a ''View''] and [http://dev.mysql.com/doc/refman/5.0/en/views.html '''Using''' a ''View''] | * [http://dev.mysql.com/doc/refman/5.0/en/create-view.html '''Creating''' a ''View''] and [http://dev.mysql.com/doc/refman/5.0/en/views.html '''Using''' a ''View''] | ||
Revision as of 07:53, 20 October 2010
Contents
Weekly Schedule
Week | Topics | Reading |
Week 1 9/08 |
|
|
Week 2 9/13 |
|
|
Week 3 9/20 |
|
|
Week 4 9/27 |
|
|
Week 5 10/04 |
|
|
Week 6 10/11 |
Fall Break
|
|
Week 7 10/18 |
|
|
Week 8 10/25 |
|
|
Week 9 11/01 |
|
|
Week 10 11/08 |
|
|
Week 11 11/15 |
|
|
Week 12 11/22 |
|
|
Week 13 11/29 |
|
|
Week 14 12/06 |
|
|
Week 15 12/13 |
|
|
Links and Resources
Bash Shell
Linux Utilities
- Good information on Grep (Thanks Sharon!)
MySQL
- MySQL Tutorial ebook.
- Examples of Common Queries on dev.mysql.com
- Select Syntax on dev.mysql.com
- Counting rows with count()
Maps/GIS
- The State of Mapping APIs, Adam DuVander, O'Reilly Radar, 7 Sept. 2010.
Tips & Tricks
List of Programs
Miscellaneous Information