Held: Thursday, 1 May 2014

Back to Outline 12 - Relational Databases. On to Outline 14 - Wrapup.

Summary

We consider a bit of the basics of SQL.

Related Pages

• W3Schools SQL Tutorial
• EBoard 13 (Source 13) (HTML 13) (PDF 13)

Overview

• Our database design project, continued.
• Key relational operators.
• SQL - Structured/Standard Query Language.

Administrivia

• There is no homework for week 14. You do need to show up for the last class.
• The W3 Schools SQL Tutorial at http://www.w3schools.com/sql/default.asp has a nice interactive SQL interpreter.
• CS Extra Today: Snowden.
• CS Table Tomorrow: Snowden.

Reminder: Basic Database Operations

Queries

• Join tables (implicitly or explicitly)
• Select from tables or joined tables

Updates

• Insert entries
• Remove

Design Project, Revisited

• What are your use cases?
• What are your tables?
• What general queries

SQL Queries

Selection

    SELECT _fields_ 
    FROM _tables_ 
    WHERE _criteria_ 
    ORDER BY _field_;

Insertion

    INSERT INTO table_name (column1,column2,column3,...)
    VALUES (value1,value2,value3,...);

Deletion

    DELETE FROM table_name
    WHERE _crieria_;