Скачать или смотреть Vlad Mihalcea - Awesome SQL – tips and tricks for application developers

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