High Performance SQL

06.10.2020 • 14:00 - 18:00 CET by Hypersistence, Workshop in English

Throughout four years of teaching my High-Performance Java Persistence course, I came to realize that there is so much Java developers can learn about the latest SQL features introduced by Oracle, SQL Server, PostgreSQL, or MySQL.

From execution plans to the best way to paginate data, this training explains lesser-known techniques such as LATERAL JOIN, CROSS APPLY, as well as Derived Tables, Common Table Expressions, recursive queries, and the amazing Window Functions.

The High-Performance SQL training is aimed to level up your SQL skills with techniques such as Window Functions, recursive queries, Pivoting, JSON processing, and many other database querying features supported by Oracle, SQL Server, MySQL, or PostgreSQL.

Agenda

  • Beyond SQL:92
  • How SQL works 
    • SQL Parsing and Execution Plans
    • SQL Operation Order
  • Pagination
    • TOP-N queries
    • OFFSET pagination
    • Keyset Pagination
  • Joins
    • CROSS JOIN
    • INNER and LEFT/RIGHT OUTER JOIN
    • FULL OUTER JOIN
    • NATURAL JOIN
    • LATERAL JOIN and CROSS APPLY
  • Window Functions
    • Analytics queries and window frame processing
    • ROW_NUMBER, RANK, and DENSE_RANK
    • FIRST_VALUE, LAST_VALUE, LEAD and LAG
    • CUME_DIST and PERCENT_RANK
    • PERCENTILE_DISC and PERCENTILE_CONT
  • Derived Tables and CTE
    • Derived Tables
    • CTE (Common Table Expressions)
    • Recursive CTE
    • Hierarchic queries

THE COMPANY

HYPERSISTENCE

Hypersistence helps you get the most out of your data access layer

YOUR TEACHER FOR THE DAY

Vlad Mihalcea

Vlad is the CEO of Hypersistence, author, trainer, and open-source developer. He is passionate about enterprise systems, data access frameworks, and distributed systems. He wrote hundreds of articles about Hibernate on vladmihalcea.com, and he has a gold badge for the Hibernate, Java, and JPA tags on StackOverflow. He’s also the author of High-Performance Java Persistence.

JOIN US ON THE 6TH OF OCTOBER AT 2 PM CET