Awesome SQL – tips and tricks for application developers

by | Sep 4, 2019 | Voxxed Days Cluj-Napoca 2019

Vlad Mihalcea is a Java Champion, CEO of Hypersistence, working currently working on Hypersistence Optimzier. He is passionate about enterprise systems, data access frameworks, and distributed systems. He wrote hundreds of articles about Hibernate on his blog , and he has a gold badge for the Hibernate, Java, and JPA tags on StackOverflow. He’s also the author of the High-Performance Java Persistence book  and video courses.

For way too many application developers, SQL equates that SQL-92 they learned in college. Fortunately, SQL has seen many additions over the past 25 years. In this presentation, we are going to see what present-day SQL looks like and learn new SQL tricks that even the DBAs will be impressed.

Although NoSQL movement stormed onto the development scene 10 years ago, it never got to overthrown relational database systems. In fact, the latest trend is called NewSQL, and it embraces both SQL and ACID guarantees. Unfortunately, for way too many developers, their SQL knowledge is stuck in the ’90s Just like we don’t use Windows 3.1 nowadays, it’s time to get to know what present-day SQL is like. In this presentation, we are going to go through various SQL constructs that will help you build better and faster queries like:

– Window functions

– Common Table Expressions (CTE) and Recursive CTE

– Pivot

– Lateral Joins

– JSON

– Upsert and Merge

– Queue job processing and SKIP LOCKED

– Pagination: Offset vs Keyset