Buy Percona ServicesBuy Now!
  Mar 22, 2013
  Percona Live University - Toronto
   Bill Karwin

SQL Query Patterns, Optimized

Let's get into several common types of queries that developers struggle with, showing SQL solutions, and then analyze them for optimal efficiency. I'll cover Exclusion Join, Relational Division, Greatest-Per-Group, Dynamic Pivot, and Random Selection.

Bill Karwin
Senior Knowledge Manager
Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems. Bill authored the book "SQL Antipatterns", collecting frequent blunders and showing better solutions.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.