Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Programming

/

Web Development

Starting with SQL written like code: Kotlin and jOOQ

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

11 learners are taking this course

  • kotlinjava
코틀린
Kotlin
jooq
flyway

What you will learn!

  • You can learn Spring development with Kotlin.

  • You can try using jOOQ as a data access technology.

  • Try using a MySQL database.

Write SQL safely

Experience Spring with Kotlin and use jOOQ as a data access technology

When using JPA, there are times when you need to use complex queries, and in such cases, you need to use jdbc template or respond with native query. In doing so, there is a risk of using an incorrect query, and you may accidentally write code that causes errors at runtime. That is why I pursued type safety and became interested in a data access technology called jOOQ.

Key features of jOOQ

  • Type safety


    1. Detect SQL query errors at compile time

    2. Avoid referencing non-existent tables/columns

    3. Preventing incorrect type mappings

  • Generate database schema code


  • Powerful query builder DSL

  • Database independence

  • Automatic query optimization

This is not a conceptual lecture on jOOQ.

This is a lecture that practices basic CRUD using jOOQ.

Therefore, it is not suitable for those who want to study the concept.

Learn about these things

(1) Writing SQL with code (jooq)

jOOQ lets you write SQL in code rather than strings.

You can write type-safe SQL queries.

SQL written in code

(2) Practice Spring with Kotlin

Practice requesting data from a client and sending data.

You can use convenient features such as Kotlin's extension functions.

Some of GlobalExceptionHanlder

(3) Try using flyway once

Flyway is a database schema version management tool.

  • Manage database changes by version

  • Track and manage change history like Git

flyway schema history

Things to note before taking the class

Practice environment

  • Operating System and Version (OS): Windows, macOS,

  • Tools used: The lecture uses the paid version of IntelliJ IDEA, so you may not be able to participate when using some functions. DB connection and HTTP API requests are made using IntelliJ IDEA functions. Those who can use terminal or POSTMAN instead are fine.

  • The database uses MySQL. MySQL runs on Docker, and if you have MySQL in your local environment, you can follow the lecture with that DB.

  • PC specifications: Any normal computer should be able to keep up.

Learning Materials

  • The required learning materials, such as the docker-compose script, are listed at the bottom of the lecture, and we will consider making them into lecture materials upon request and provide them.

Player Knowledge and Notes

  • jOOQ makes you write code similar to SQL queries, so it is recommended to know SQL. Basic SELECT, INSERT, UPDATE, DELETE SQL is enough.

  • Please take into consideration that the video and audio quality of the lecture is not very good.


Recommended for
these people

Who is this course right for?

  • Someone curious about how to use Spring with Kotlin

  • Anyone who wants to quickly try out jOOQ

  • Anyone who wants to write type-safe SQL

Need to know before starting?

  • Java

  • Kotlin

  • MySQL

  • sql

Hello
This is

안녕하세요

풀스택 개발자 코틀린자바입니다

메인언어는 코틀린이고

요즘은 다양한 언어로 개발하고 있습니다

Curriculum

All

36 lectures ∙ (5hr 33min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$34.10

Similar courses

Explore other courses in the same field!