Futuristic SQL: Making the impossible possible
summary
Shows a working Game Capture app on Oracle Cloud using Application Express and demos SQL that produces quarter subtotals and grand totals with GROUP BY ROLLUP/GROUPING SETS plus ROWNUM ordering; uses partitioned outer join to inflate sparse player/quarter rows; uses hypothetical analytics for ranking, WITH (CTE) for stepwise queries and JSON output, MATCH_RECOGNIZE for pattern-matching (shopping-bag bin-packing and lap-consistency detection), recursive WITH for fuel impurity accumulation, and notes SQL macros (newer feature) to parameterize complex SQL. All examples run and produce the claimed results.
AI-written summary · about
chapters (29)
- 0:00Intro
- 0:55Futuristic SQL is not about me
- 1:18Examples
- 4:16Rollup
- 4:40Data sources
- 5:06Single query
- 5:41Group by cube
- 6:12Group sets operator
- 7:51Player results by quarter
- 8:35Data is sparse
- 9:07Partition data joins
- 10:48Ranking function
- 11:22Group by
- 12:36With clause
- 13:06Width clause
- 14:11Procedural approach
- 14:28Stepbystep approach
- 14:59Average totals
- 15:32Programmer approach
- 15:51Code reuse
- 16:02JSON
- 17:16Shopping bags
- 17:41Pattern matching
- 20:46SQL Macros
- 21:21Pack and Carry
- 23:58Patterns
- 27:25Recursive with
- 29:13Summary
- 29:34Resources
related talks
26mLess Code, Faster Apps- Rediscovering SQL for Modern ORM Developers
01h 00mComplex Queries with Modern SQL
39mMore Than a Query Language: SQL in the 21st Century
41mModern SQL: Evolution of a dinosaur
21mA Hands-on Experience with Complex SQL
46mAwesome SQL – tips and tricks for application developers
40mLet's SQL Like It's 1992!
18mHow to write powerful SQL that's easy to maintain