SQL Class

When and Where

DATE TBD
10 am to 12 pm
401 N. Wickham Rd, Suite 135 Melbourne, FL
Find us with our contact page

Description

Like all of our classes, this is a free class to the public. However, donations of any amount are graciously accepted!
This class will touch on the basics of SQL (Structured Query Language) and do some simple statements to pull from an online DB. We’ll show how to get a database installed on your own computer so you can play with SQL offline if you want. We’ll spend a little time to touch briefly on the more complicated queries that use JOIN to pull data from multiple tables. The goal is to learn about SQL and how to use it to SELECT, INSERT, UPDATE, and DELETE data from a database. Then if there’s time, we can learn how to make a simple web app using LAMP or MEAN: InfoWorld LAMP vs MEAN
We’ll also go over the SQL queries we use at the makerspace for Seltzer and the front door lock, ACON.

Notes

Here’s the SQL tutorials we’ll use to practice SQL statements on someone else’s database:
W3 Schools SQL Tutorial
SQLCourse.com

Install a LAMP stack on your computer:
AMMPS
XAMMP

Install a MEAN stack on your computer:
MEAN.io

Steve Brown’s SQL slides from Linux User Group talks: SQLite.pdf
Steve Brown’s SQL example slides from Linux User Group talks: SQLite2.pdf

Syllabus

SQL class notes:

Class 1: SQL basics

  1. What is SQL? Why it exists, History of SQL, and difference between Relational and Non-relational databases. Show https://www.mysql.com/ and that Facebook, Twitter, Youtube, etc. uses MySQL for example. Go over sqlcourse.com and possibly even W3Schools.com/sql. Database Management Systems: MySQL, SQLite, MongoDB, Oracle, MS SQL, many others! CRUD - Create, Read, Update, Delete
    INSERT, SELECT, UPDATE, DELETE

  2. Server - cloud - client diagram showing how servers serve pages and data to clients’ web browsers. Go over each of the layers and what they do.
    alt text
    Server layers diagram showing the RDBMS, Programming layer (PHP, Express, ASP, JSP, etc.), web server (Apache, Node.js, IIS, etc.).
    alt text

  3. What can I do with a database? Facebook! Seltzer! ACON! IoT!
    ACON Access Log Report
    ACON RFID Query

  4. Primary Key, Primary Key, etc. Normalization.

Class 2: Web App Programming with SQL

  1. LAMP or MEAN?

  2. Show Server layer and server-client diagrams again.

  3. Let’s make a hello world web app! Guestbook app.

  4. HTML and CSS and Javascript - oh my!