BEST

Database

jOOQ in action! Type Safe SQL with Java

Name: jOOQ in action! Type Safe SQL with Java
Price: 38500 KRW
Rating: 4.9 (19 reviews)

Experience the power of Type Safe SQL with jOOQ!

(4.9) 19 reviews

371 learners

sdm32851630

실습 중심

db설계

쿼리

Java

jooq

SQL

Spring Boot

dsl

Reviews from Early Learners

What you will gain after the course

You can learn jOOQ from the basics to practical use all at once.
You can write SQL only with Java code, no XML configuration, no strings.
All SQL functions that cannot be done with ORM can be used in Java code.

Practical jOOQ! Type-Safe SQL with Java

Mastering databases and SQL is essential for every backend developer. However, traditional string-based SQL writing is repetitive and error-prone.

jOOQ is a powerful tool that solves these problems, allowing you to write SQL in an intuitive way while ensuring type safety. This course will teach you step-by-step how to use jOOQ , from basic concepts to advanced applications. (jOOQ is pronounced "juke.")

This course covers only the open source version of jOOQ.

Recommended for
these people

Who is this course right for?

People who were worried about not being able to avoid native SQL while using JPA
For those who want to write SQL in a TypeSafe manner like QueryDSL
Anyone who wants to improve MyBatis' XML configuration and string-based query writing method

Need to know before starting?

Java
Spring Boot
Docker
RDBMS (MySQL)

Hello
This is

371

Learners

Reviews

Answers

4.9

Rating

Course

안녕하세요. 지식공유자 설동민입니다.

현재 대기업 백엔드 개발자로 근무하고 있으며, 복잡한 문제를 명쾌하게 풀어내는걸 좋아합니다.

경영학부 비전공자 출신으로, 다양한 OpenSource들에 대한 분석과 여러 기술적인 경험들을 통해
웹의 전반적인 기술을 학습하였습니다. OOP와 SQL, 이 어울리지 않는 두가지를 제일 좋아합니다.

Github: https://github.com/SightStudio

LinkedIn: https://www.linkedin.com/in/dong-min-seol-243b6119a

이력

2021. 12 ~ 2025.11: 전) 카카오 백엔드 개발
2020.12 ~ 2021.12 : 전) 이스트소프트 백엔드 개발

Curriculum

All

30 lectures ∙ (4hr 53min)

Course Materials:

Lecture resources

Section 1. About jOOQ

3 lectures ∙ (26min)

Section 2. Project Preferences

6 lectures ∙ (45min)

4. Introducing Sakila Database
03:35
5. (Practice) Configuring DB based on Sakila DB
05:38
6. Creating a jOOQ Project
01:23
7. (Practice) Creating a jOOQ Project
11:47
8. Examining the Generated DSL Structure
05:48
9. Customizing jOOQ DSL
16:49

Section 3. jOOQ Basics - Retrieving Data

6 lectures ∙ (1hr 37min)

10. jOOQ-Basic Grammar - SELECT clause (1)
10:40
11. jOOQ-Basic Grammar - SELECT clause (2)
19:20
12. Using Generated Dao
12:52
13. Creating simple search conditions using Condition
24:51
14. Writing a subquery
24:20
15. Mapping Enums using EnumConverter
05:33

Section 4. jOOQ Intermediate - Manipulating Data

5 lectures ∙ (55min)

Section 5. jOOQ Advanced - Creating a jOOQ DSL in various ways

5 lectures ∙ (34min)

Section 6. Other convenient features, etc.

5 lectures ∙ (34min)

Published:

Last updated:

Reviews

All

19 reviews

4.9

19 reviews

kwj1270
Reviews 6
∙
Average Rating 5.0
5
10% enrolled
My experience using Jooq at my previous company was very good. JPA is very convenient and powerful, but on the other hand, I was disappointed when I encountered functions that were not supported. In the case of Jooq, it was very good that it supported all SQL functions, and that it could be made type-safe through J classes. I was very disappointed that there was no reference, but I personally really like that you made such a detailed lecture.
harpuria870722
Reviews 7
∙
Average Rating 4.9
5
90% enrolled
I am a 6-year SI developer who mainly uses MyBatis when dealing with SQL. I studied JPA at first because I wanted to avoid the inevitable human errors that occur after using MyBatis for a long time. I felt the charm of JPA when managing tables with entities without directly writing DDL and when writing C, U, D. However, I was losing my motivation to learn due to the disadvantages of writing SELECT statements and the strangely unfamiliar JPQL (if you use it, you risk having to carry human errors as they are...) and then I found out about this lecture. (I also tried QueryDSL, but I wondered if it was okay because it had not been maintained for a long time... ㅠㅠ) The introduction was long when writing a jOOQ course review, but in conclusion, I really liked this course. As someone who likes writing SQL, I thought that JOOQ, which reduces human errors and creates queries in a similar way to SQL, was the perfect technology for me. Thank you for the great lecture.
choiyoungkwon
Reviews 5
∙
Average Rating 5.0
5
100% enrolled
I was surprised that it seemed to be a technology stack worth considering introducing, even though it was a technology I was not familiar with. I also found it personally interesting because it compared it to licenses, queryDsl, and JPA.
inkang05084175
Reviews 1
∙
Average Rating 5.0
5
100% enrolled
This is a really good lecture. I thought jooq was a new technology, but it's been over 10 years. This great technology almost got buried, so thank you for introducing it to Korea. The other features are also really good.
tussle
Reviews 7
∙
Average Rating 5.0
5
100% enrolled
I was lucky to find this great lecture while looking for ways to reflect jOOQ in an environment using R2DBC. It was very helpful for understanding because there were a lot of great contents that covered the basic knowledge of jOOQ. I am still trying to set it up to suit the environment and looking for ways to write codes for R2DBC, but I am moving forward step by step more easily than I thought by supporting what I learned in the lecture. Thank you for creating such a great lecture.

Limited time deal ends in 8 days

$30.80

28%

$42.90

Similar courses

Explore other courses in the same field!

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Make the most of relational database systems!

중급이상

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Solid Foundation, SQL Overview (Introductory Course)

skmns

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

입문

SQL, DBMS/RDBMS, Data Engineering

Solid Foundation, SQL Overview (Introductory Course)

skmns

MySQL Performance Optimization Guide for Non-Specialists: Beginner to Advanced (SQL Tuning Edition)

jscode

I've created the 'MySQL Performance Optimization Intro/Practical (SQL Tuning Edition)' course, easy for non-majors to understand and immediately applicable in practice!

초급

MySQL, DBMS/RDBMS, query-tuning

MySQL Performance Optimization Guide for Non-Specialists: Beginner to Advanced (SQL Tuning Edition)

jscode

From Introduction to Utilization of MSSQL Server 2016-based Database Part 1

usefulit

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

입문

SQL, MSSQL, DBMS/RDBMS

From Introduction to Utilization of MSSQL Server 2016-based Database Part 1

usefulit

[SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

WHIZ

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

초급

SQL, sql-query, bigquery

[SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

WHIZ

Java TPC Practical Project (Using Java API)

bitcocom

You can improve your Java programming skills by working on your own projects using various Java APIs and Open APIs.

초급

Java, oop

Java TPC Practical Project (Using Java API)

bitcocom

This one completes it all - 32 hours of high-quality Spring full-stack web development

greencoding1234

Just listen. The lecturing skill, captivating power, and lecture quality are different.

입문

HTML/CSS, JavaScript, JSP

This one completes it all - 32 hours of high-quality Spring full-stack web development

greencoding1234

Do it! SQL Introduction

easyspub

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

입문

SQL

Do it! SQL Introduction

easyspub

Starting with SQL written like code: Kotlin and jOOQ

kotlinjava

You can try using jOOQ, a data access technology, and experience Spring development with Kotlin.

초급

Kotlin, jooq, flyway

Starting with SQL written like code: Kotlin and jOOQ

kotlinjava

Practical Elasticsearch Introduction for Immediate Use (Search Optimization Edition)

jscode

I've created a beginner-friendly and practical 'Introduction to Elasticsearch' course!

초급

Spring Boot, Elasticsearch, devops

Practical Elasticsearch Introduction for Immediate Use (Search Optimization Edition)

jscode

Accidentally, Spring Boot

oopsmomo

This is designed to help you understand the core concepts of Spring in just one hour. 🌱

초급

Spring, Spring Boot, Java

Accidentally, Spring Boot

oopsmomo

Media Handling on the Web - Learning MediaStream API by Building Video Chat

sir24is

Handling media (video, audio) on the web is now easier than ever! Learn the MediaStream API and WebRTC by following along step by step.

초급

React, Java, Web API

Media Handling on the Web - Learning MediaStream API by Building Video Chat

sir24is

Create Your Own Visual Novel Game in Just One Day

Neo

Create your own visual novel game using React, Javascript, SpringAI, and Springboot. Learn how to create a web-based visual novel game using SpringAI and React!

초급

React, Spring Boot, AI

Create Your Own Visual Novel Game in Just One Day

Neo

Solid Foundation! Starting Java Intensively Part 3 (Part 2): Sockets and File I/O

nullnull8537

Starting with java.io, you can learn how to develop high-performance input/output systems based on NIO and NIO.2. Most importantly, the moment you master file I/O, we'll enable you to master high-performance server development as a bonus!

중급이상

Java, Network, tcpsocket

Solid Foundation! Starting Java Intensively Part 3 (Part 2): Sockets and File I/O

nullnull8537

SQL data analysis learned through various cases

dooleyz3525

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

중급이상

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

Solid Foundation! Starting Java with Determination - Part 1: Procedural Programming

nullnull8537

For those aspiring to be Java-based Spring backend developers, to easily secure a job, we learn Java properly! Rigorously!

입문

Java

Solid Foundation! Starting Java with Determination - Part 1: Procedural Programming

nullnull8537

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

입문

SQL, SQLD

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

More Java, Java 8

whiteship

The features added to Java 8 are widely used in APIs provided by Java as well as third-party libraries and frameworks such as Spring. If you are a Java developer in this era, you must know them. Make them your own technology easily and quickly through this lecture.

초급

Java

More Java, Java 8

whiteship

Deploy a server that learns chicken combo value in 1 hour

Neo

Learn the deployment process in the following order: Manually deploy Spring Boot with Chicken Combo value -> Deploy with Docker -> Github Action CI/CD.

초급

Spring Boot, github-actions, Docker

Deploy a server that learns chicken combo value in 1 hour

Neo

Infrastructure Workshop - Creating a plausible service

brainbackdoor

This course proceeds in stages, similar to the actual work, by learning and applying the necessary knowledge while configuring the infrastructure.

초급

Network, Linux, Spring Boot

Infrastructure Workshop - Creating a plausible service

brainbackdoor

jOOQ in action! Type Safe SQL with Java

Reviews from Early Learners

What you will gain after the course

Practical jOOQ! Type-Safe SQL with Java

Writing SQL in Java code, not strings

Learn about these things

1⃣ Writing SQL using only Java, without XML or strings

2⃣ SQL Builder and more convenient features

3⃣ Using jOOQ in a Spring Boot Environment

Things to note before taking the course

Practice environment

Learning Materials

Player Knowledge and Precautions

Recommended for
these people

Hello
This is

Curriculum

Reviews

Similar courses

jOOQ in action! Type Safe SQL with Java

Reviews from Early Learners

What you will gain after the course

Practical jOOQ! Type-Safe SQL with Java

Writing SQL in Java code, not strings

Learn about these things

1⃣ Writing SQL using only Java, without XML or strings

2⃣ SQL Builder and more convenient features

3⃣ Using jOOQ in a Spring Boot Environment

Things to note before taking the course

Practice environment

Learning Materials

Player Knowledge and Precautions

Recommended for these people

HelloThis is .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}

Curriculum

Reviews

Similar courses

Recommended for
these people

Hello
This is