WDI_Day11.md

#Day 11

grandma exercise: https://gist.github.com/mathildathompson/9455409

#SQL (Structured Query Language)

---

SQLite 3

Learn SQL the hard way: ("http://sql.learncodethehardway.org/book/")

PostrgreSQL SQLite Documentation

SQL uses table. This is where you are storing your data.

CREATE - INSERT READ - SELECT UPDATE - UPDATE DELETE - DELETE --> CRUD . The operations we want to be able to do.

sqlite3 in Terminal to open SQL.

###COMMANDS:

DROP TABLE "Name" - removes the table from the database

SELECT "value" FROM "name of table" --> Selects only the value from your table.

example: SELECT first_name FROM person; SELECT name, breed FROM pet; SELECT * FROM person WHERE first_name != 'Zed';

(Aaron Patterson)

'*' = splat operator

##Homework

Movie database 4

Style butterflies app

Error Handle Butterflies

SQL the hard way