Get best performance from database used by Hibernate app

Get best performance from database used by Hibernate app, available at $49.99, has an average rating of 4.4, with 35 lectures, 3 quizzes, based on 15 reviews, and has 154 subscribers.

You will learn about Know how to approach optimization Use Query Execution Plan Know which data types and why are preferred in a database for better performance Avoid unnecessary type conversions in SQL queries Efficiently use dictionary tables Configure Hibernate to see executed database queries Avoid reading data which is not needed Eliminate n+1 problem in Hibernate Understand a trade off when implementing flexible solutions Properly implement data paging in Hibernate Efficiently count rows and aggregating data Update and delete multiple rows with a single request Learn index structure and its impact on query performance Choose the right index for a query Use of multi column indexes Learn the process of executing queries by a database Take advantage of query parameters binding in Hibernate Avoid long transactions Restructure queries for better performance Use indexes to support sorting rows and joining Know when it is better to avoid Hibernate entities and how to use alternatives This course is ideal for individuals who are Java developers using Hibernate that want to understand and improve efficiency of the database operations. or Software programmers that would like to understand database queries performance and tricks to improve them. or Developers that would like to use Hibernate in a more efficient manner. It is particularly useful for Java developers using Hibernate that want to understand and improve efficiency of the database operations. or Software programmers that would like to understand database queries performance and tricks to improve them. or Developers that would like to use Hibernate in a more efficient manner.

Enroll now: Get best performance from database used by Hibernate app

Summary

Title: Get best performance from database used by Hibernate app

Price: $49.99

Average Rating: 4.4

Number of Lectures: 35

Number of Quizzes: 3

Number of Published Lectures: 35

Number of Published Quizzes: 3

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Know how to approach optimization

Use Query Execution Plan

Know which data types and why are preferred in a database for better performance

Avoid unnecessary type conversions in SQL queries

Efficiently use dictionary tables

Configure Hibernate to see executed database queries

Avoid reading data which is not needed

Eliminate n+1 problem in Hibernate

Understand a trade off when implementing flexible solutions

Properly implement data paging in Hibernate

Efficiently count rows and aggregating data

Update and delete multiple rows with a single request

Learn index structure and its impact on query performance

Choose the right index for a query

Use of multi column indexes

Learn the process of executing queries by a database

Take advantage of query parameters binding in Hibernate

Avoid long transactions

Restructure queries for better performance

Use indexes to support sorting rows and joining

Know when it is better to avoid Hibernate entities and how to use alternatives

Who Should Attend

Java developers using Hibernate that want to understand and improve efficiency of the database operations.

Software programmers that would like to understand database queries performance and tricks to improve them.

Developers that would like to use Hibernate in a more efficient manner.

Target Audiences

Java developers using Hibernate that want to understand and improve efficiency of the database operations.

Software programmers that would like to understand database queries performance and tricks to improve them.

Developers that would like to use Hibernate in a more efficient manner.

Have you ever wondered why database operations in your application are slow? Is it because of the database or Hibernate or both? Is there anything that can be done to improve that? What are those mysterious database indexes? Does using Hibernate leave me no field for performance optimization?

During this course I will teach you performance optimization techniques that will give you a huge advantage in the Java programmers world.

No, you will not have to give up on Hibernate. It is a great tool. I like it too! Most performance issues with it are caused by inefficient usage, not by Hibernate itself. You can still let it do the dirty job for you and have a highly performant application at the same time.

Java developers too often avoid database topics. But some database knowledge can make your life incredibly easier. In this course, I focus on the aspects that will let you make a significant impact on a database performance with the lowest effort.

Let me show you how to take the best from Hibernate using some database knowledge to achieve high speed of database operations.

After this course, you will know how to combine database tricks with Hibernate best practices to build lightning speed software.

Course Curriculum

Chapter 1: Performance optimization intro

Lecture 1: Premature optimization

Lecture 2: Order of actions

Lecture 3: Who is responsible

Lecture 4: Course plan

Chapter 2: Database design

Lecture 1: Introduction

Lecture 2: Query execution plan

Lecture 3: Numeric columns for joins

Lecture 4: Dictionary tables

Lecture 5: Too flexible design

Chapter 3: Unnecessary queries

Lecture 1: Introduction

Lecture 2: Show queries in Hibernate

Lecture 3: Early fetch

Lecture 4: N+1 query problem

Lecture 5: Paging

Lecture 6: Counting

Lecture 7: Deleting and updating rows

Chapter 4: Indexes

Lecture 1: What is an index

Lecture 2: Queries improved

Lecture 3: Multi-column indexes

Lecture 4: Foreign keys

Lecture 5: Index maintenance

Chapter 5: Basic Hibernate tuning

Lecture 1: Introduction

Lecture 2: Query execution process

Lecture 3: Parameters binding

Lecture 4: Long transaction

Chapter 6: Basic query tuning

Lecture 1: Introduction

Lecture 2: Expressions in WHERE clause

Lecture 3: Implicit conversion

Lecture 4: Order by clause

Lecture 5: Table joins

Chapter 7: Overused entities

Lecture 1: Introduction

Lecture 2: DTOs for read only objects

Lecture 3: Aggregates

Chapter 8: Summary

Lecture 1: What you have learned

Lecture 2: Not covered topics

Instructors

Arkadiusz Fronc
Fullstack developer, architect

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 3 votes

5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!