BEST

Programming

Database

本当のjOOQ！ Type Safe SQL with Java

Name: 本当のjOOQ！ Type Safe SQL with Java
Price: 55000 KRW

jOOQでType SafeしたSQLの強力さを体験してください！

（4.9）受講レビュー 17件

受講生 345名

sdm32851630

실습 중심

db설계

쿼리

Java

jooq

SQL

Spring Boot

dsl

学習した受講者のレビュー

こんなことが学べます

jOOQの基礎から実務活用まで一度に学ぶことができます。
XML設定、文字列のないJavaコードでのみSQLを作成できます。
ORMではできないSQL機能をすべてJavaコードとして使用できます。

本当のjOOQ！ Type Safe SQL with Java

データベースとSQLをうまく扱うことは、すべてのバックエンド開発者にとって不可欠な技術です。しかし、伝統的な文字列ベースのSQLを書く方法は反復的でエラーが発生しやすいです。

jOOQはこれらの問題を解決する強力なツールで、タイプセーフティを保証しながらも直感的な方法でSQLを作成できるようにします。このレッスンでは、 jOOQの基本概念から深刻な活用方法まで段階的に学習できます。（jOOQはジュークと読みます。）

このレッスンはjOOQオープンソースバージョンについてのみ説明します。

こんな方に
おすすめです

学習対象は
誰でしょう？

JPAを使ってネイティブSQLを避けられなくて悩んだ方
QueryDSLのようにTypeSafeにSQLを作成したい方
MyBatisのXML設定と、文字列ベースのクエリ作成方法を改善したい方

前提知識、
必要でしょうか？

Java
Spring Boot
Docker
RDBMS(MySQL)

こんにちは
です。

345

受講生

受講レビュー

回答

4.9

講座評価

講座

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

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

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

Github: https://github.com/SightStudio

이력

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

カリキュラム

全体

30件 ∙ (4時間 53分)

講座資料（こうぎしりょう）:

授業資料

セクション 1．jOOQについて

3件 ∙ (26分)

セクション 2．プロジェクト環境設定

6件 ∙ (45分)

4. Sakila Databaseについて
03:35
5. （実践）Sakila DBに基づいてDBを構成する
05:38
6. jOOQプロジェクトを作成する
01:23
7. （実践）jOOQプロジェクトを作成する
11:47
8. 生成されたDSL構造を調べる
05:48
9. jOOQ DSLをカスタマイズする
16:49

セクション 3．jOOQ 基本 - データの照会

6件 ∙ (1時間 37分)

10. jOOQ - 基本文法 - SELECT句（1）
10:40
11. jOOQ - 基本文法 - SELECT句（2）
19:20
12. Generated Daoを使う
12:52
13. Conditionを活用した簡潔な検索条件の作成
24:51
14. サブクエリを作成する
24:20
15. EnumConverterを使用したEnumのマッピング
05:33

セクション 4．jOOQ中級 - データ操作

5件 ∙ (55分)

セクション 5．jOOQ Advanced - さまざまな方法でjOOQ DSLを作成する

5件 ∙ (34分)

セクション 6．その他その他の便宜機能等

5件 ∙ (34分)

講座掲載日:

最終更新日:

受講レビュー

全体

17件

4.9

17件の受講レビュー

kwj1270
受講レビュー 6
∙
平均評価 5.0
5
10% 受講後に作成
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
受講レビュー 7
∙
平均評価 4.9
5
90% 受講後に作成
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
受講レビュー 5
∙
平均評価 5.0
5
100% 受講後に作成
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
受講レビュー 1
∙
平均評価 5.0
5
100% 受講後に作成
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
受講レビュー 7
∙
平均評価 5.0
5
100% 受講後に作成
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.

￥6,526

似ている講座

同じ分野の他の講座を見てみましょう！

An easy and fun SQL story with Teacher Jangrae

jangrae

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

Beginner

SQL, DBMS/RDBMS, MySQL

An easy and fun SQL story with Teacher Jangrae

jangrae

Practice! Querydsl

Solve everything from the basics of querydsl to practical use all at once!

Intermediate

Java, JPA

Practice! Querydsl

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

Beginner

Java, SQL, MySQL

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

Solid Foundation! Java Starting Strongly - Part 2: OOP and JVM

nullnull8537

It covers just two things properly: object-oriented programming and the JVM! Plus, it throws in linked-list-based linear data structures.

Basic

Java, oop, jvm

Solid Foundation! Java Starting Strongly - Part 2: OOP and JVM

nullnull8537

Core Banking Server Features Implementation with Multi-Module Architecture [ Kotlin & Spring ]

Hong

This course covers how to set up multi-module projects from scratch using Kotlin and Spring Boot. It proceeds with a hands-on approach, covering everything from the basic concepts of modularization to Gradle configuration, managing dependencies between modules, and actual application development. If you are a beginner or intermediate developer looking to learn the fundamentals and practical application of multi-modules, please refer to this course.

Basic

Java, Spring, Kotlin

Core Banking Server Features Implementation with Multi-Module Architecture [ Kotlin & Spring ]

Hong

[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!

Basic

SQL, sql-query, bigquery

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

WHIZ

Learning React 19 with Code and Spring Boot API Server

zk202308a5410

API server built with Spring Boot (Spring Boot ver3.4.x) and React 19 (with TypeScript) Completing the integration project! Producing the entire portfolio writing bootcamp as lectures.

Intermediate

React, TypeScript, Spring Boot

Learning React 19 with Code and Spring Boot API Server

zk202308a5410

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

Basic

SQL, PostgreSQL, DBMS/RDBMS

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

Solid Foundations! Intensively Starting Java Part 4: Towards Spring

nullnull8537

Based on an understanding of Reflection and Annotations, it helps you clearly understand how the Spring framework operates!

Basic

Java, annotation, reflection

Solid Foundations! Intensively Starting Java Part 4: Towards Spring

nullnull8537

[Concept Class] Learn and Use SQL Queries Right Away

breachers

You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

Beginner

SQL

[Concept Class] Learn and Use SQL Queries Right Away

breachers

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!

Intermediate

Java, Network, tcpsocket

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

nullnull8537

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.

Basic

Spring Boot, github-actions, Docker

Deploy a server that learns chicken combo value in 1 hour

Neo

Faster Than Anyone: ChatGPT Clone Coding

Neo

This is a full-stack hands-on course where you'll clone ChatGPT and implement everything from scratch. From Spring Boot server to React frontend! This isn't just a course where you follow along with code, but one that guides you to build a high-quality AI chatbot service through actual service deployment.

Basic

JavaScript, React, Java

Faster Than Anyone: ChatGPT Clone Coding

Neo

Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

Not only developers, but also planners and data analysts learn databases step-by-step, starting from SQL basics.

Beginner

SQL, MySQL, DBMS/RDBMS

Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

Learn Springboot + Android RestAPI Board Creation Faster Than Anyone

Neo

Learn Springboot + Android(Compose) RestAPI Board Creation Faster Than Anyone Develop a CRUD server with Springboot and create your own board with Android!

Beginner

Android, Kotlin, Spring Boot

Learn Springboot + Android RestAPI Board Creation Faster Than Anyone

Neo

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!

Beginner

SQL, SQLD

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

Masocampus

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.

Intermediate

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

Practical Elasticsearch Introduction for Immediate Use (Search Optimization Edition)

jscode

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

Basic

Spring Boot, Elasticsearch, devops

Practical Elasticsearch Introduction for Immediate Use (Search Optimization Edition)

jscode

Learn Springboot + iOS RestAPI Bulletin Board Building Faster Than Anyone

Neo

Build a Springboot + iOS RestAPI Bulletin Board: Learn Faster than Anyone Develop a CRUD server with Springboot and create your own bulletin board with iOS!

Beginner

iOS, Kotlin, Spring Boot

Learn Springboot + iOS RestAPI Bulletin Board Building Faster Than Anyone

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.

Basic

Network, Linux, Spring Boot

Infrastructure Workshop - Creating a plausible service

brainbackdoor

本当のjOOQ！ Type Safe SQL with Java

学習した受講者のレビュー

こんなことが学べます

本当のjOOQ！ Type Safe SQL with Java

文字列ではなくJavaコードでSQLを書く

このようなことを学びます。

1⃣XMLと文字列なしでJavaでSQLを作成する

2⃣ SQL Builder、それ以上の様々な便利機能

3⃣ Spring Boot環境でのjOOQの使い方

受講前の注意

練習環境

学習資料

選手の知識と注意事項

こんな方に
おすすめです

こんにちは
です。

カリキュラム

受講レビュー

似ている講座

本当のjOOQ！ Type Safe SQL with Java

学習した受講者のレビュー

こんなことが学べます

本当のjOOQ！ Type Safe SQL with Java

文字列ではなくJavaコードでSQLを書く

このようなことを学びます。

1⃣XMLと文字列なしでJavaでSQLを作成する

2⃣ SQL Builder、それ以上の様々な便利機能

3⃣ Spring Boot環境でのjOOQの使い方

受講前の注意

練習環境

学習資料

選手の知識と注意事項

こんな方に おすすめです

こんにちは .css-1q3zd4q{text-decoration-line:underline;text-underline-position:under;text-underline-offset:1px;}です。

カリキュラム

受講レビュー

似ている講座

こんな方に
おすすめです

こんにちは
です。