Published Sep 3, 2019

Episode 137: SQL with Jim Melton

Delve into the world of SQL with expert Jim Melton as he unpacks the nuances of query optimization, the processes of SQL standardization, and the evolutionary path of this pivotal language in database management.

Episode Highlights

Topics covered

Episode Highlights

Related Episodes

Episode 116: The Semantic Web with Jim Hendler
Answers 383 questions
Episode 143: API Design with Jim des Rivieres
Answers 383 questions
Episode 38: Interview James Noble
Answers 383 questions
Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework
Answers 383 questions
SE Radio 560: Sugu Sougoumarane on Distributed SQL Databases
Answers 383 questions
Episode 454: Thomas Richter Postgres as an OLAP database
Answers 383 questions
Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework
Answers 383 questions
Episode 511: Ant Wilson on Supabase (Postgres as a Service)
Answers 383 questions
Episode 129: F# with Luke Hoban
Answers 383 questions
Episode 465: Kevlin Henney and Trisha Gee on 97 Things Every Java Programmer Should Know
Answers 383 questions
Episode 55: Refactoring Pt. 2
Answers 383 questions
Episode 121: OR Mappers with Michael Plöd
Answers 383 questions
Episode 186: Martin Fowler and Pramod Sadalage on Agile Database Development
Answers 383 questions
Episode 413: Spencer Kimball on CockroachDB
Answers 383 questions
Episode 433: Jay Kreps on ksqlDB
Answers 383 questions

Dexa/Software Engineering Radio - the podcast for professional software developers

Episode 137: SQL with Jim Melton

Topics covered

Popular Clips

Subqueries and Logic

Object Relational Mapping

Podcast Introduction

Data Management Insights

SQL Standards Participation

Final Thoughts

Virtual Table Insights

Object References Explained

Evolving ORM Tools

Beer for Feedback

Query Optimization Strategies

Understanding SQL Joins

Evolution of SQL

Origins of SQL

Query Optimization Insights

Episode Highlights

Query Optimization

SQL Standardization

Understanding SQL

Related Episodes

Episode 116: The Semantic Web with Jim Hendler

Episode 143: API Design with Jim des Rivieres

Episode 38: Interview James Noble

Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework

SE Radio 560: Sugu Sougoumarane on Distributed SQL Databases

Episode 454: Thomas Richter Postgres as an OLAP database

Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework

Episode 511: Ant Wilson on Supabase (Postgres as a Service)

Episode 129: F# with Luke Hoban

Episode 465: Kevlin Henney and Trisha Gee on 97 Things Every Java Programmer Should Know

Episode 55: Refactoring Pt. 2

Episode 121: OR Mappers with Michael Plöd

Episode 186: Martin Fowler and Pramod Sadalage on Agile Database Development

Episode 413: Spencer Kimball on CockroachDB

Episode 433: Jay Kreps on ksqlDB

Episode 137: SQL with Jim Melton

Topics covered

Popular Clips

Episode Highlights

Query OptimizationJim Melton discusses the intricacies of SQL query optimization, emphasizing the techniques and strategies employed by optimizers to enhance query performance. He shares insights on how developers can aid optimizers by crafting efficient queries and understanding query plans.

Query Optimization

SQL Standardization

Understanding SQLJim Melton, SQL specification lead, discusses the declarative nature of SQL and its evolution over the years. He shares insights into SQL's functions, optimization techniques, and the language's historical development.

Understanding SQL

Related Episodes