SQL Utility Belt
summary
PostgreSQL-focused toolbox of concrete techniques for building large reporting queries for NSF STEM enrollment exports: use INSERT ... SELECT for bulk inserts, generate SQL by concatenating strings and using quote_nullable, clean text with replace/translate, format timestamps with to_char, handle nulls with coalesce and case, convert subselect results into arrays then use array_to_string to pack multiple rows into one spreadsheet cell, union mentor buckets and use group by/having for counts, parse GPA change text to produce ordered progressions — solution works and clients are happy.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 2:38Insert Multiple Records
- 9:34General Tools
- 11:48Database
- 15:33coalesce
- 18:24Arrays
- 20:37Examples
- 28:34GPA
- 35:03Community Theater
related talks
46mSQL for Nerds
21mA Hands-on Experience with Complex SQL
46mUse PostgreSQL to Step Up Your Game
30mLesser known features of PostgreSQL
49mSELECT 'amazing features' FROM "postgresql"
52mBulk data processing and PostgreSQL thingy
29mSELECT 'amazing_features' FROM "postgresql"
34mSimple and Awesome Database Tricks