Automatically generate CRUD SQL

Name: Automatically generate CRUD SQL
Price: 11000 KRW
Rating: 5 (3 reviews)

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

dlqorgod

SQL

Reviews from Early Learners

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

Learners

Reviews

Answers

5.0

Rating

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

Section 1. introduction

1 lectures ∙ (2min)

1. Introduction and lecture materials
02:50

Section 2. Installing the development environment

2 lectures ∙ (12min)

Section 3. Create a project

1 lectures ∙ (10min)

4. Create a web project and install the minimum common components
10:26

Section 4. Installing local DB

2 lectures ∙ (10min)

Section 5. pom.xml

1 lectures ∙ (1min)

Section 6. DriverManager

1 lectures ∙ (3min)

Section 7. DatabaseMetaData

2 lectures ∙ (8min)

Section 8. ResultSetMetaData

1 lectures ∙ (4min)

Section 9. Automatically generate CRUD SQL

4 lectures ∙ (15min)

Section 10. organize

1 lectures ∙ (5min)

Published:

Last updated:

Reviews

All

3 reviews

5.0

3 reviews

yh202
Reviews 3
∙
Average Rating 5.0
5
100% enrolled
This is a useful lecture.
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~
sangmoo
Reviews 3
∙
Average Rating 5.0
5
100% enrolled
Thanks for the great tip
- dlqorgod
  Instructor
  Thank you, sir~

$8.80

Similar courses

Explore other courses in the same field!

Database - SQL

kjlee

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

SQL, Data Engineering

Database - SQL

kjlee

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

softcampus

Easy explanations and examples are provided so that you can apply them directly to your work.

Basic

SQL, Oracle, PL/SQL

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

softcampus

[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

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

coddatg

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

SQL, bigquery

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

coddatg

[Practice Makes Perfect] Intermediate SQL for Data Analysis

datarian

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

SQL

[Practice Makes Perfect] Intermediate SQL for Data Analysis

datarian

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

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

DBT with a Silicon Valley Engineer

altoformula

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

SQL, Data Engineering, data-analysis

DBT with a Silicon Valley Engineer

altoformula

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

youngcodikimssam

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

Java, JSP, Spring

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

youngcodikimssam

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

Make the most of relational database systems!

Intermediate

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

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

Rookiss

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

Basic

SQL, DBMS/RDBMS

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

Rookiss

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

Automatically generate CRUD SQL

Reviews from Early Learners

5.0

What you will gain after the course

Oh, are you talking about me ?

No more repetitive tasks, Generate SQL statements quickly!

We will learn about these things .

Q&A Check it out.

Created this course Introducing the knowledge sharer .

Lee Baek-haeng

Recommended for these people

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

Curriculum

Reviews

Similar courses

No more repetitive tasks,
Generate SQL statements quickly!

Q&A
Check it out.

Created this course
Introducing the knowledge sharer .

Recommended for
these people

Hello
This is