Created
August 28, 2015 14:26
-
-
Save SophieDeBenedetto/299618b029d5d938842a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Introduction to SQL: What is it? Why do we need to know about it? Basic set-up/installation | |
2. First Lab on SQL: Create, insert into, edit and drop tables | |
* We have a lab that would be good for this: SQL-book-tables. But this lab needs work and also | |
has them coding sql in the terminal. Do we want this or just jump right into using text editor? | |
I think good to start in terminal and then next lab has them in text editor and explains how we | |
are connecting to the databse. | |
* This lab is way to long and wordy. Needs better organization, fewer types of examples. | |
3. Follow up with quiz (missing) | |
4. Creating tables lab - needs readme improvements (objectives are wonky, instructions are lacking, more clarity on | |
how writing sql statements in Ruby project + running those files = executing the sql statements and creating/alterting a DB) | |
5. Insert and select lab - now they are back in the command line--do we want to be consistent? Keep it in the text editor | |
now? Also needs more instructions. These labs should be more hand-holdy overall. | |
6. SQL operators lab - needs a re-write. content is okay but readme and long and not v. well organized. | |
7. Follow up wit operators quiz (missing) | |
8. SQL insert and select lab - needs new reamde | |
9. Update tutorial - needs better readme (missing objectives, generally disorganized, needs to be more of a code along, not just a reading that refers to code | |
10. Delete tutorial - same as above | |
11. SQL update and delete lab - improve readme | |
12. Table relations tutorial - needs to start with what and why (talk about the object relations stuff we just did), make more of a code along | |
13. Joins tutorial - needs better intro (what and why), needs to be more code along | |
14. Quiz on joins and relations (missing) | |
15. Join table lab - needs more thorough instructions, the usual readme improvements | |
16. Bear organizer - improve readme, objectives are misasligned with the purpose of the lab | |
17. Crowdfunding query lab - needs more of a walk through on some of those complex query statements | |
18. SQL library lab - needs better readme, more thorough instructions | |
19. Pokemon scraper + DB - needs strong instructions, especially on how to set up their domain model/associations. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment