Introduction to Database

Transcript

1. DATABASE SWATHIK.COM
2. EVERY MINUTE FACEBOOK USERS SHARE AROUND 2M PIECES OF CONTENT TWITTER USERS TWEET OVER 200K TIMES GOOGLE RECEIVES OVER 4M SEARCHES 2
3. WHAT IS A DATABASE? A SYSTEM TO STORE MANIPULATE AND RETRIEVE DATA 3
4. WHERE ARE THEY USED?
5. DATABASE TABLE GROCERIES
7. SQL STRUCTURED QUERY LANGUAGE
8. 8 SELECT * FROM GROCERIES; INSERT INTO GROCERIES ( NAME, PRICE, CATEGORY) VALUES (‘BLUEBERRIES’, ‘3.0’, ‘FRUITS’);
9. 9 UPDATE GROCERIES SET PRICE = 5.0 WHERE NAME = ‘BLUEBERRIES’; DELETE FROM GROCERIES WHERE CATEGORY = ‘VEGETABLES’;
10. MYSQL POSTGRES IBM DB2 ACCESS DB MONGODB REDIS 10
11. RAILS APP SQLITE 11
12. ACTIVERECORD MAGIC SELECT * FROM GROCERIES; GROCERY.ALL
13. THANK YOU!