inflearn logo

Course

Instructor
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

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

  • sangmoo님의 프로필 이미지
    sangmoo

    Reviews 4

    ∙

    Average Rating 5.0

    5

    100% enrolled

    Thanks for the great tip

    • dlqorgod
      Instructor

      Thank you, sir~

  • yh202님의 프로필 이미지
    yh202

    Reviews 3

    ∙

    Average Rating 5.0

    5

    100% enrolled

    This is a useful lecture.

    • pradise2170667님의 프로필 이미지
      pradise2170667

      Reviews 8

      ∙

      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~

    Similar courses

    Explore other courses in the same field!

    MySQL Performance Optimization Intro/Practice for Non-Majors (SQL Tuning Edition)Course Thumbnail

    MySQL Performance Optimization Intro/Practice for Non-Majors (SQL Tuning Edition)

    jscode

    $68.20

    Basic / MySQL, DBMS/RDBMS, query-tuning, SQL

    5.0

    (153)

    1,300+

    I have created a course titled 'Introduction to MySQL Performance Optimization & Practice (SQL Tuning Edition)' that is easy for non-majors to understand and can be applied immediately in practice!

    Basic

    Basic

    MySQL, DBMS/RDBMS, query-tuning

    MySQL Performance Optimization Intro/Practice for Non-Majors (SQL Tuning Edition)Course Thumbnail

    MySQL Performance Optimization Intro/Practice for Non-Majors (SQL Tuning Edition)

    jscode

    $68.20

    Basic / MySQL, DBMS/RDBMS, query-tuning, SQL

    5.0

    (153)

    1,300+
    Database - SQLCourse Thumbnail

    Database - SQL

    kjlee

    $42.90

    Basic / SQL, Data Engineering

    4.8

    (62)

    700+

    This course is for those who are learning database programming for the first time or those who have some knowledge but want to learn systematically. From concepts to practical exercises, you will master the database query language by organizing examples of types that frequently occur in real life.

    Basic

    Basic

    SQL, Data Engineering

    Database - SQLCourse Thumbnail

    Database - SQL

    kjlee

    $42.90

    Basic / SQL, Data Engineering

    4.8

    (62)

    700+
    MySQL Master Course for Data Analysts and IT Engineers!Course Thumbnail

    MySQL Master Course for Data Analysts and IT Engineers!

    moduai

    $15.40

    Basic / MySQL, SQL, Big Data, NoSQL, Tableau

    2.0

    (1)

    A must-have subject for aspiring developers and those looking to get a job in big data!!

    Basic

    Basic

    MySQL, SQL, Big Data

    MySQL Master Course for Data Analysts and IT Engineers!Course Thumbnail

    MySQL Master Course for Data Analysts and IT Engineers!

    moduai

    $15.40

    Basic / MySQL, SQL, Big Data, NoSQL, Tableau

    2.0

    (1)

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

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

    hongpark

    $27.50

    Basic / SQL, PostgreSQL, DBMS/RDBMS

    4.8

    (26)

    500+

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

    Basic

    Basic

    SQL, PostgreSQL, DBMS/RDBMS

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

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

    hongpark

    $27.50

    Basic / SQL, PostgreSQL, DBMS/RDBMS

    4.8

    (26)

    500+
    Do it! SQL IntroductionCourse Thumbnail

    Do it! SQL Introduction

    easyspub

    Free

    Beginner / SQL

    4.6

    (80)

    3,200+

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

    Beginner

    Beginner

    SQL

    Do it! SQL IntroductionCourse Thumbnail

    Do it! SQL Introduction

    easyspub

    Free

    Beginner / SQL

    4.6

    (80)

    3,200+
    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

    (57)

    1,600+

    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

    (57)

    1,600+
    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

    (33)

    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

    (33)

    600+
    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

    Masocampus

    $69.30

    Beginner / SQL, SQLD

    4.5

    (23)

    200+
    Active Replies
    Active Replies

    Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

    Beginner

    Beginner

    SQL, SQLD

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

    Masocampus

    $69.30

    Beginner / SQL, SQLD

    4.5

    (23)

    200+
    Active Replies
    Active Replies
    Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

    Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

    youngcodikimssam

    $133.10

    Beginner / Java, JSP, Spring, SQL, oop

    From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

    Beginner

    Beginner

    Java, JSP, Spring

    Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

    Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

    youngcodikimssam

    $133.10

    Beginner / Java, JSP, Spring, SQL, oop

    MariaDB Database Practical Completion - From Installation to OperationCourse Thumbnail

    MariaDB Database Practical Completion - From Installation to Operation

    wendy34647345

    $68.20

    Basic / SQL, MariaDB, database, cron, optimizing

    Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

    Basic

    Basic

    SQL, MariaDB, database

    MariaDB Database Practical Completion - From Installation to OperationCourse Thumbnail

    MariaDB Database Practical Completion - From Installation to Operation

    wendy34647345

    $68.20

    Basic / SQL, MariaDB, database, cron, optimizing

    DBT with a Silicon Valley EngineerCourse Thumbnail

    DBT with a Silicon Valley Engineer

    altoformula

    $34.10

    22%

    $26.40

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

    4.8

    (19)

    400+

    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

    22%

    $26.40

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

    4.8

    (19)

    400+
    [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

    4.9

    (142)

    4,000+

    This is a course for learning MS-SQL through baseball and corporate 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

    4.9

    (142)

    4,000+

    25% off for new members

    $8.80

    25%

    $8.80