block4 overview

Databases

SQL

• http://www.w3schools.com/sql/sql_intro.asp
• http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
• http://www.sqlite.org/
• http://zetcode.com/db/sqlite/
• https://mariadb.org/ (http://www.mysql.com/)
• http://www.postgresql.org/

noSQL

• http://mongodb.org/
• http://couchdb.apache.org/
• http://cassandra.apache.org/

Study

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database