CS 350: Class Agenda for Day 23 of Web Development 1

Agenda main content

Agenda for Day 23 of CS 350

Announcements
- University Announcements
Quiz 3 on Friday
- Short Answer Questions - Comprehensive
  - 10 questions, 2 points each (20 points total)
  - Closed book, closed Web
- Programming Problem using PHP & Forms
  - One problem (30 points total)
  - Open book, open Web
  - Done on Computer, graded online
Lab Assignments
- Lab 10 due at the start of class today
- No Lab 11 assignment, work on group project
Project 1 Milestones
- Memorandum 5 explaining updated group norms and justifications for changes due Tuesday (one per team)
Reading for today
- SQLite
Today's topics and learning objectives
After today's class, you should be able to
- Explain the role of relational databases in Web applications
- Use Structured Query Language (SQL) to
  1. CREATE TABLE tableName(columnName1, ...)
  2. INSERT INTO tableName (columnName1, ...) VALUES ('value1', ...)
  3. SELECT columnName1, ... FROM tableName WHERE criteria ORDER BY columnName
  4. UPDATE tableName SET columnName1 = value1, ... WHERE criteria
  5. DELETE FROM tableName WHERE criteria
- Use SQLite, SQL, and PHP in your Web pages
References
- PHP 101 (part 9): SQLite My Fire!