Program Title: Intermediate SQL for Sierra and Polaris
ILS: General
Program Description: Write Better SQL
- Concepts of Recordsets and Cardinality
- Understanding the different types and applications of JOINs
- Common uses of UNIONs
- Common table expressions (CTEs)
- Correlated subqueries
- Style considerations for readability
- Producing Python- and Excel-friendly output
Audience members are encouraged to chime in at any time to round out the presentation with input from multiple perspectives. Likewise, questions will be encouraged throughout.
Speaker/ Information: Bob Gaydos - ILS Administrator @ Stark County District Library @bgaydos
Pardon the wait! We’re still retrieving the presentation and will post it ASAP.