← Back to Submind

Topic

query optimization

Subqueries in PostrgreSQL

Alex The Analyst

The video introduces subqueries in PostgreSQL as a powerful tool often misunderstood due to their syntax, explaining that they consist of an outer query and an inner query where the latter acts as a complete statement nested within the former. The primary use case demonstrated is comparing individua …

Introduction to Floe (Kurt Westerfeld)

CMU Database Group

Kurt Westerfeld introduces Floe as a startup venture fully funded by Yellowbrick that operates in the data warehouse and query service market with a distinct focus on lakehouse architectures. Drawing from his background at Yellowbrick, where they built petabyte-scale MPP databases known for predicta …