inflearn logo
강의

Course

inflearn logo
Programming

/

Database

Automatically generate CRUD SQL

Automatically generate executable SQL files using JDBC (DatabaseMetaData, ResultSetMetaData). Install the e-Government Standard Framework 3.10.0 development environment. Install local DB (mariadb-10.6.4-winx64.zip).

(5.0) 3 reviews

31 learners

Level Basic

Course period Unlimited

SQL
SQL
SQL
SQL
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

yh202.lee

100% enrolled

This is a useful lecture.

5.0

유은진

100% enrolled

This is a useful lecture that will help you easily set up a local development environment!

5.0

상무

100% enrolled

Thanks for the great tip

What you will gain after the course

  • Using JDBC (DatabaseMetaData, ResultSetMetaData)

  • Installing the e-Government Standard Framework 3.10.0 Development Environment

  • Install local DB (mariadb-10.6.4-winx64.zip)

The power of automatically generating SQL statements that will help you leave work on time!

Oh, are you talking about me ?

If you are having these concerns, please pay attention!

No more repetitive tasks,
Generate SQL statements quickly!

Establishing an e-government framework + MariaDB environment and
To improve productivity through automatic generation of SQL statements.

Don't worry about tons of tables or typos!
With just a few settings, you can automatically generate SQL statements very quickly.

This course teaches beginning developers how to automate the generation of error-free SQL statements very quickly, freeing them from repetitive tasks and allowing them to focus on logic and improve development productivity.

We will learn about these things .

  • ✅ You can install the e-Government Standard Framework (eGovFrame) version 3.10.0 development environment and local DB (MariaDB).
  • ✅ Learn how to automatically generate CRUD SQL statements very quickly using DatabaseMetaData.
  • ✅ You can retrieve table and column metadata with DatabaseMetaData.
Install local DB
Automatic generation of SELECT statements

Q&A
Check it out.

Q. Is this a course that non-majors can also take?

Yes. If you have a basic understanding of SQL statements, you can follow along while watching the lecture.

Q. Why should I learn automatic CRUD SQL generation?

You can improve your development productivity by generating SQL statements very quickly and without typos.

Q. What are the benefits of learning automatic CRUD SQL generation?

You can leave work on time because you can focus on logic rather than doing simple repetitive tasks.

Created this course
Introducing the knowledge sharer .

Lee Baek-haeng

  • GS ITM Sangipyeong RCMS project in progress
  • Performed multiple public SI AA and development PL
  • Performed numerous public SI projects, from e-government standard framework development environment to operational environment.
  • Participation in the 2021 e-Government Standard Framework Contribution
  • Posting development diary

Automatically generates standard SQL statements very quickly
I hope this helps you improve your project productivity 👨‍💻

Recommended for
these people

Who is this course right for?

  • Public SI Developer

  • Anyone who wants to automatically generate SQL

Need to know before starting?

  • SQL Basics

Hello
This is dlqorgod

31

Learners

3

Reviews

1

Answers

5.0

Rating

1

Course

Hello! This is 200Line.

I am a developer who enjoys using the eGovernment Standard Framework.

Curriculum

All

16 lectures ∙ (1hr 15min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

5.0

3 reviews

  • pradise2170667님의 프로필 이미지
    pradise2170667

    Reviews 7

    ∙

    Average Rating 5.0

    5

    100% enrolled

    This is a useful lecture that will help you easily set up a local development environment!

    • dlqorgod
      Instructor

      Thank you for easily setting up a local development environment~

  • yh202님의 프로필 이미지
    yh202

    Reviews 3

    ∙

    Average Rating 5.0

    5

    100% enrolled

    This is a useful lecture.

    • sangmoo님의 프로필 이미지
      sangmoo

      Reviews 3

      ∙

      Average Rating 5.0

      5

      100% enrolled

      Thanks for the great tip

      • dlqorgod
        Instructor

        Thank you, sir~

    Similar courses

    Explore other courses in the same field!

    Practical Oracle SQL UtilizationCourse Thumbnail

    Practical Oracle SQL Utilization

    y2kdba

    $84.70

    Basic / Oracle, SQL

    4.0

    (4)

    We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

    Basic

    Basic

    Oracle, SQL

    Practical Oracle SQL UtilizationCourse Thumbnail

    Practical Oracle SQL Utilization

    y2kdba

    $84.70

    Basic / Oracle, SQL

    4.0

    (4)

    [CS Technical Interview 4] Database That Opens Up Your Speaking

    yiyj10305235

    $29.70

    22%

    $23.10

    Beginner / SQL, DBMS/RDBMS, Tech Interview

    4.9

    (13)

    200+

    A course that helps you understand core database concepts and practice explaining them verbally in interviews

    Beginner

    Beginner

    SQL, DBMS/RDBMS, Tech Interview

    [CS Technical Interview 4] Database That Opens Up Your Speaking

    yiyj10305235

    $29.70

    22%

    $23.10

    Beginner / SQL, DBMS/RDBMS, Tech Interview

    4.9

    (13)

    200+
    Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

    Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

    youngcodikimssam

    $133.10

    24%

    $100.10

    Beginner / Java, JSP, Spring, SQL, oop

    From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

    Beginner

    Beginner

    Java, JSP, Spring

    Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

    Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

    youngcodikimssam

    $133.10

    24%

    $100.10

    Beginner / Java, JSP, Spring, SQL, oop

    FastAPI Complete GuideCourse Thumbnail

    FastAPI Complete Guide

    dooleyz3525

    $59.40

    Intermediate / Python, FastAPI, SQL, SQLAlchemy

    4.9

    (62)

    800+
    Active Replies
    Active Replies

    This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

    Intermediate

    Intermediate

    Python, FastAPI, SQL

    FastAPI Complete GuideCourse Thumbnail

    FastAPI Complete Guide

    dooleyz3525

    $59.40

    Intermediate / Python, FastAPI, SQL, SQLAlchemy

    4.9

    (62)

    800+
    Active Replies
    Active Replies
    SQL data analysis learned through various casesCourse Thumbnail

    SQL data analysis learned through various cases

    dooleyz3525

    $68.20

    Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

    4.9

    (49)

    1,500+
    Active Replies
    Active Replies

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

    Intermediate

    Intermediate

    SQL, PostgreSQL, DBMS/RDBMS

    SQL data analysis learned through various casesCourse Thumbnail

    SQL data analysis learned through various cases

    dooleyz3525

    $68.20

    Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

    4.9

    (49)

    1,500+
    Active Replies
    Active Replies
    High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

    High-Performance SQL for JPA (ORM) Developers

    Vlad Mihalcea

    $176.00

    Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

    4.9

    (31)

    600+

    Make the most of relational database systems!

    Intermediate

    Intermediate

    SQL, performance-tuning, sql-query

    High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

    High-Performance SQL for JPA (ORM) Developers

    Vlad Mihalcea

    $176.00

    Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

    4.9

    (31)

    600+
    DBT with a Silicon Valley EngineerCourse Thumbnail

    DBT with a Silicon Valley Engineer

    altoformula

    $34.10

    Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

    5.0

    (9)

    300+

    Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

    Basic

    Basic

    SQL, Data Engineering, data-analysis

    DBT with a Silicon Valley EngineerCourse Thumbnail

    DBT with a Silicon Valley Engineer

    altoformula

    $34.10

    Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

    5.0

    (9)

    300+
    [A hundred words are not as good as seeing once] Advanced SQL for data analysisCourse Thumbnail

    [A hundred words are not as good as seeing once] Advanced SQL for data analysis

    datarian

    $42.90

    Intermediate / SQL

    4.8

    (330)

    3,500+

    Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

    Intermediate

    Intermediate

    SQL

    [A hundred words are not as good as seeing once] Advanced SQL for data analysisCourse Thumbnail

    [A hundred words are not as good as seeing once] Advanced SQL for data analysis

    datarian

    $42.90

    Intermediate / SQL

    4.8

    (330)

    3,500+
    For those who haven't even started with SQL, come hereCourse Thumbnail

    For those who haven't even started with SQL, come here

    coddatg

    Free

    Beginner / SQL, bigquery

    4.8

    (137)

    2,200+

    Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

    Beginner

    Beginner

    SQL, bigquery

    For those who haven't even started with SQL, come hereCourse Thumbnail

    For those who haven't even started with SQL, come here

    coddatg

    Free

    Beginner / SQL, bigquery

    4.8

    (137)

    2,200+
    [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

    [Practice Makes Perfect] Intermediate SQL for Data Analysis

    datarian

    $29.70

    Basic / SQL

    4.9

    (959)

    5,400+

    Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

    Basic

    Basic

    SQL

    [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

    [Practice Makes Perfect] Intermediate SQL for Data Analysis

    datarian

    $29.70

    Basic / SQL

    4.9

    (959)

    5,400+
    SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

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

    Masocampus

    $69.30

    Beginner / SQL, SQLD

    4.4

    (18)

    100+
    Active Replies
    Active Replies

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

    Beginner

    Beginner

    SQL, SQLD

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

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

    Masocampus

    $69.30

    Beginner / SQL, SQLD

    4.4

    (18)

    100+
    Active Replies
    Active Replies
    [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

    [MMORPG Game Development Series with C# and Unity] Part 5: Database

    Rookiss

    $34.10

    Basic / SQL, DBMS/RDBMS

    5.0

    (132)

    3,900+
    Active Replies
    Active Replies

    This course teaches MS-SQL through baseball/company databases.

    Basic

    Basic

    SQL, DBMS/RDBMS

    [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

    [MMORPG Game Development Series with C# and Unity] Part 5: Database

    Rookiss

    $34.10

    Basic / SQL, DBMS/RDBMS

    5.0

    (132)

    3,900+
    Active Replies
    Active Replies

    $8.80