Learn SQL and Databases Class (Part 5 of 5 Web Dev Series)

Dec 12, 2015 10 am - 12 pm
This is class 4 of 5 for the Web Development Series of classes. These classes should give you the basics for building your own website, making a web application, building the server side scripting for Internet of Things projects, or even mobile web applications for tablets and smartphones.

In this specific class we'll go over Structured Query Language (SQL) - the language used with databases. We'll go through the w3Schools SQL tutorial and explain how to use the different queries in the real world for things like e-commerce inventory and shopping carts, membership databases, and even web guest books! We'll use our front door lock and Seltzer CRM database as an example of a database we use right here at the Melbourne Makerspace.

Here's some of the links we'll be using in the class:

Wiki page for SQL class: https://wiki.melbournemakerspace.org/classes/sqlclass

w3Schools SQL tutorial: http://www.w3schools.com/sql/default.asp

CRUD, basic SQL statements: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete

MySQL: https://www.mysql.com/ Oracle: https://www.oracle.com/database

MS SQL: https://en.wikipedia.org/wiki/Microsoft_SQL_Server

MongoDB: https://www.mongodb.com/

SQLite: https://www.sqlite.org/