Difference between revisions of "CSC220 Schedule 2010"
(→Weekly Schedule) |
(→Weekly Schedule) |
||
Line 196: | Line 196: | ||
|| | || | ||
* [http://www.faqs.org/docs/ppbook/x1428.htm Anatomy of a SQL query] | * [http://www.faqs.org/docs/ppbook/x1428.htm Anatomy of a SQL query] | ||
− | * [http://dev.mysql.com/doc/refman/5.0/en/join.html Joining tables] | + | * Joins |
− | * [http://dev.mysql.com/doc/refman/5.0/en/create-index.html Creating an '''Index'''] | + | ** [http://dev.mysql.com/doc/refman/5.0/en/join.html Joining tables] |
− | * [http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html How MySQL uses '''Indexes'''] | + | * Indexes |
− | * [http://dev.mysql.com/doc/refman/5.0/en/create-view.html '''Creating''' a ''View''] | + | ** [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://www.bluerwhite.org/btree/ B-Trees] (used for indexes) | ||
+ | * Views | ||
+ | ** [http://dev.mysql.com/doc/refman/5.0/en/create-view.html '''Creating''' a ''View''] | ||
+ | ** [http://dev.mysql.com/doc/refman/5.0/en/views.html '''Using''' a ''View''] | ||
|- style="background:#eeeeff" valign="top" | |- style="background:#eeeeff" valign="top" |
Revision as of 08:05, 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