Discover advanced SQL techniques and modern features in this 46-minute Devoxx conference talk. Explore the evolution of SQL beyond SQL-92, learning powerful constructs like window functions, Common Table Expressions (CTEs), recursive queries, pivoting, lateral joins, JSON integration, upsert operations, queue job processing with SKIP LOCKED, and efficient pagination methods. Gain insights into the latest trends in database technology, including NewSQL systems that combine SQL flexibility with ACID guarantees. Master these cutting-edge SQL tricks to impress DBAs, optimize query performance, and enhance your application development skills. Dive into practical examples and real-world applications of these advanced SQL features, equipping yourself with the knowledge to leverage the full potential of modern relational database systems.
Awesome SQL – Tips and Tricks for Application Developers
Overview
Syllabus
Introduction
Trends in technology
Stack Overflow
SQL
History of SQL
History of Database
Why use SQL
Top database systems
What does SQL mean
SQL is a standard
SQL 92
Example
Pagination
Derived Tables
SQL Gadgets
SQL Standard
Common Table Expressions
Recursive Table Expressions
Recursive Common Tables
Calculate Total Cost
Aggregation
Recursive
Noncore members
Query structure
Root ID
Window Functions
How does it work
Streams
Ranking
Limit order
March
Dis constraint violation
Merge
SQL 2006
SQL 2011
MySQL
transform
virtual table
new SQL databases
cockroach GDB
volDB
BigQuery
Google Spanner
Questions
Taught by
Devoxx
