CS 374: Database Systems
James Madison University, Spring 2022

Mar 08: SQL Functions by Example

Lesson Outline

15 min Exam Debrief
* Solutions posted in Canvas Files
25 min SQL Functions
* Basic Syntax
* Dollar Quoting
* Volatility
* Examples
20 min Web Development
* HTML Eamples
* CSS Eamples
* JS Eamples
* Google Charts
15 min Group Time
* Brainstorm queries
* Discuss chart types

Before Thursday

  1. Reading: Skim PostgreSQL docs (~15 pages):
    * 38.5 Query Language (SQL) Functions
    * 38.6 Function Overloading
    * 38.7 Function Volatility Categories

  2. Project: Finish draft of GP3 (present Thursday in class).