Skip to content

Instantly share code, notes, and snippets.

@SophieDeBenedetto
Created August 28, 2015 14:26
Show Gist options
  • Save SophieDeBenedetto/299618b029d5d938842a to your computer and use it in GitHub Desktop.
Save SophieDeBenedetto/299618b029d5d938842a to your computer and use it in GitHub Desktop.
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