High-Performance SQL Video Course

High-Performance SQL


Get the most out of your relational database system

SQL has come a long way since SQL:92

  • 1
    SQL
    SQL is the most successful data access querying language. It's been constantly evolving over the past 40 years, and, nowadays, even NoSQL database systems have started employing SQL engines.
  • 2
    MULTIPLE DATABASE SUPPORT
    All SQL examples are inspired by real-life scenarios. All code is on GitHub®, and you will have exclusive access to the source repository and benefit from future updates.
  • 3
    MULTIPLE DATABASE SUPPORT
    The High-Performance SQL video course is designed for Oracle®, SQL Server®, PostgreSQL® and MySQL®.

Video Course

12 Video Course Modules (67 videos – 7 hours and 36 minutes)

Joins

Duration: 70m

  • Introduction and CROSS JOIN (8:06)
  • INNER JOIN (7:22)
  • NATURAL JOIN (6:15)
  • LEFT JOIN and RIGHT JOIN (5:49)
  • FULL JOIN (5:34)
  • LATERAL JOIN and CROSS APPLY (11:40)
  • JOIN vs. Subquery (8:01)
  • Nested Loops (5:03)
  • Hash Join (5:05)
  • Merge Join (4:15)
  • Join and Group By (4:14) 

Subqueries

Duration: 34m

  • JOIN vs. Subquery (7:35)
  • EXISTS and NOT EXISTS (6:00)
  • IN and NOT IN (8:34)
  • ANY and ALL (5:07)
  • Column Expression (7:36)

Derived Tables and CTE

Duration: 52m

  • Derived Table (8:01)
  • CTE (6:14)
  • Derived Table and Group By (6:35)
  • Recursive CTE (7:57)
  • Hierarchical Models (24:01)

Pagination

Duration: 27m

  • SQL Standard Pagination (5:44)
  • Legacy Pagination (6:03)
  • Streaming vs. Pagination (5:42)
  • Keyset Pagination (5:20)
  • Better Pagination (4:26)

SQL Operation Order

Duration: 26m

  • FROM and JOIN (8:11)
  • WHERE, GROUP BY, and HAVING (8:02)
  • Window Functions, SELECT, and DISTINCT (6:39)
  • UNION, ORDER BY, OFFSET, and LIMIT (3:49)

Pivot and Upsert

Duration: 25m

  • Pivot (4:53)
  • Unpivot (6:16)
  • Upsert using Merge (6:45)
  • Upsert using ON DUPLICATE (7:06)

JSON

Duration: 86m

  • When to use JSON columns (10:53)
  • Oracle JSON Functions (21:43)
  • Oracle JSON Indexing (4:50)
  • Oracle JSON Assignment (4:50)
  • SQL Server JSON Functions (10:01)
  • SQL Server JSON Indexing (1:42)
  • SQL Server JSON Assignment (2:48)
  • PostgreSQL JSON Functions (13:07)
  • PostgreSQL JSON Indexing (4:54)
  • MySQL JSON Functions (6:02)
  • PostgreSQL JSON Indexing (0:59)
  • JSON Conclusion (4:17)

Window Functions

Duration: 55m

  • Group By vs. Window Functions (5:41)
  • Default Frame (6:43)
  • Specific Frame (7:25)
  • Running Total (4:09)
  • ROW_NUMBER (2:36)
  • RANK and DENSE_RANK (3:27)
  • FIRST_VALUE and LAST_VALUE (1:58)
  • PERCENTILE_CONT and PERCENTILE_DISC (7:50)
  • CUME_DIST and PERCENT_RANK (4:00)
  • NTILE (4:06)

Transactions

Duration: 79m

  • Race Conditions (17:00)
  • ACID (9:47)
  • Isolation Levels (11:32)
  • Pessimistic Locking (11:50)
  • Skip Locked (6:45)
  • 2PL and MVCC (12:06)
  • Optimistic Locking (10:00)

Start Today! Choose Your Plan Below

Online Edition - $199

  • 67 Lessons, 456 minutes
  • 100% satisfaction guarantee               
  • Lifetime online access 
BUY NOW

Downloadable Edition - $249

  • 67 Lessons, 456 minutes
  • 100% satisfaction guarantee               
  • Lifetime online access
  • On-demand download
BUY NOW

🇰🇷

JPA (ORM) 개발자를 위한 고성능 SQL (High-Performance SQL)

  • Hibernate 및 JPA 분야의 세계적인 전문가가 알려주는 SQL 성능 튜닝과 최적화 노하우를 배웁니다.
  • 백엔드 애플리케이션과 데이터베이스 간의 효율적인 상호작용을 고려한 SQL 작성법을 익힙니다.
  • JOIN, 서브쿼리, CTE, 윈도우 함수 등 다양한 SQL 전략 중 어떤 것이 ORM 환경에서 성능을 극대화할 수 있는지 판단하는 기준을 제시합니다.
  • Oracle, SQL Server, MySQL, PostgreSQL 등 대표적인 RDBMS에서의 성능 개선 쿼리 전략을 비교하고, 각 데이터베이스에서 잘 작동하거나 작동하지 않는 상황을 명확히 알려줍니다.
  • Upsert, Merge와 같은 고급 쿼리 기법을 다양한 RDBMS 환경에서 어떻게 활용하는지 실무 사례 중심으로 배울 수 있습니다.
  • 트랜잭션 격리 수준 이슈, 락킹 전략, JSON 데이터 처리, 고급 인덱싱 전략 등 최신 SQL 주제를 다뤄 애플리케이션 성능을 극대화할 수 있는 역량을 키웁니다.
수강신청 하기

🇯🇵

JPA (ORM) 開発者向け 高性能 SQL (High-Performance SQL)

  • HibernateおよびJPA分野における世界的な専門家が教える、SQLパフォーマンスチューニングと最適化のノウハウを学びます。
  • バックエンドアプリケーションとデータベース間の効率的な相互作用を考慮したSQL作成法を習得します。
  • ORM環境でパフォーマンスを最大化するために、JOIN、サブクエリ、CTE、ウィンドウ関数などのさまざまなSQL戦略のうち、どれが最適かを判断する基準を提示します。
  • Oracle, SQL Server, MySQL, PostgreSQL 등 대표적인 RDBMS에서의 성능 개선 쿼리 전략을 비교하고, 각 데이터베이스에서 효과적인 전략과 그렇지 않은 전략을 명확히 설명합니다.
  • Upsert、Mergeのような高度なクエリ技法を、多様なRDBMS環境でどのように活用するのか、実務事例を中心に学ぶことができます。
  • トランザクション分離レベルの問題、ロッキング戦略、JSONデータ処理、高度なインデックス戦略など、最新のSQLトピックを取り上げ、アプリケーションのパフォーマンスを最大限に引き出すことができる能力を養います。
続きから学習する

🇻🇳

SQL hiệu năng cao (High-Performance SQL) dành cho nhà phát triển JPA (ORM)

  • Tìm hiểu các mẹo và thủ thuật tối ưu hóa và điều chỉnh hiệu suất SQL từ một chuyên gia đẳng cấp thế giới trong lĩnh vực Hibernate và JPA.
  • Tìm hiểu cách viết SQL hiệu quả, có tính đến sự tương tác hiệu quả giữa ứng dụng backend và cơ sở dữ liệu.
  • Tiêu chí đánh giá chiến lược SQL nào (JOIN, Subquery, CTE, Window Function...) có thể tối ưu hóa hiệu suất trong môi trường ORM.
  • Bạn có thể học cách sử dụng các kỹ thuật truy vấn nâng cao như Upsert, Merge trong nhiều môi trường RDBMS khác nhau, tập trung vào các trường hợp thực tế.
  • Nắm vững các chủ đề SQL mới nhất như các vấn đề về mức độ cô lập giao dịch, chiến lược khóa, xử lý dữ liệu JSON, chiến lược lập chỉ mục nâng cao, v.v. để nâng cao khả năng tối đa hóa hiệu suất ứng dụng.
Tiếp tục học tập

14 Days Money Back Guarantee

I firmly believe you will get a lot of value out of this video course, and that it can help you optimize a data access layer that barely crawls so that it can ultimately run both effectively and efficiently.

However, if you are unsatisfied with your purchase, you can contact us in the first 14 days, and we will give you a full refund.

What People Are Saying...

Andrei Rosu-Cojocaru

Andrei Roșu-Cojocaru

Software Developer - ABS Laundry Business Solutions

Our company has been delivering an ERP solution for laundries for more than 25 years. Our application uses Oracle, Java, Spring, and JDBC as its backbone.

Most of the performance problems reported by our customers find their root cause in the persistence layer. During his course, Vlad showed us how we should tackle these kinds of issues, breaking up the execution time of a statement into atomic bits and improving the performance for each of them. We found that optimizing the persistence layer is much more than just writing an SQL query as efficiently as possible. The framework allows for a lot of configuration we were not aware of, even in our case, where we are using plain JDBC. There are also some other architectural decisions that might have an amazing impact on the speed, such as caching, batching, or fetching options.

I enjoyed the fact that Vlad successfully managed to deliver custom training tailored to our needs. He had no problem adjusting the content, as he immediately understood our application’s architecture. Although his course contains a lot of information on various DBMSs, such as SQL Server, PostgreSQL, and MySQL (also comparing their performances) and on frameworks such as Hibernate, he focused on the technologies we are currently using and provided a lot of tips and tricks to help us tune our data access layer. The information was delivered at a pace that could be followed by all participants, and he promptly answered all our questions.

The course was delivered online - given the pandemic situation – and we had a very good interaction, with our colleagues being involved in the discussion through periodical Q&A or hands-on exercises.

Vlad offers a repository with an impressive library of integration tests that illustrate each concept presented throughout the course. Given the level of abstraction they provide and the way they were written, using the latest version of Java, taking gain of the latest additions in the JDK, and abiding by the clean code standards, it would not be an exaggeration to say they provide state of the art in this domain. Every developer writing tests should take a look at them to make sure the application is checked for most hidden vulnerabilities.

I highly recommend the High-Performance SQL and Java Persistence Trainings delivered by Vlad for all companies that want to make sure the data management solution in their application is put to proper use!

Daniel Manolescu

Java Developer - Societe Generale European Business Services

As a Java developer, I often find myself interacting with databases and writing SQL queries. After attending Vlad's High-Performance SQL, I found answers to many problems that I faced over the years.

Vlad has a dynamic approach to teaching that motivates and engages everybody in the room. The presentation covered a lot of fascinating topics, and the content was well structured.

Every section had real-life code examples helping solidify the information presented.

This was a great training course that covered a lot of advanced SQL concepts.

Unlimited access to course material

The videos quality is high definition (e.g. 1080p) with an audio bitrate of 320, offering an exquisite learning experience.

All video episodes are recorded in English, and the slides used during the video recordings are available as well.

All source code is provided so that you can run any example any time you want.


FAQ

Here are answers to some frequently asked questions:

When does the course start and finish?

What if I am unhappy with the course?

How long do I have access to the course?

Why should I buy this course instead of any other?

Copyright notice

Oracle®, Java®, MySQL® are registered trademarks of Oracle and/or its affiliates.

Microsoft® SQL Server® – Microsoft and Microsoft SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

PostgreSQL is a trademark or registered trademark of PostgreSQL Global Development Group.

Hibernate® is a trademark of Red Hat, Inc.

Spring® is a trademark of Broadcom Inc. and/or its subsidiaries.

jOOQ™ is a trademark by Data Geekery™ GmbH.

GitHub is a trademark of GitHub, Inc.

Vlad Mihalcea

Powered by WordPress.com.