강의

멘토링

커뮤니티

BEST
Programming

/

Database

RDBMS Modeling Practice

This is the second lecture following the Database Design Fundamentals course. This is a practical course that focuses on real-world projects from start to finish. After understanding all the lecture content, you will be able to freely design databases.

(4.5) 21 reviews

548 learners

Level Intermediate

Course period Unlimited

  • kjlee
DBMS/RDBMS
DBMS/RDBMS
Oracle
Oracle
MSSQL
MSSQL
Data Engineering
Data Engineering
DBMS/RDBMS
DBMS/RDBMS
Oracle
Oracle
MSSQL
MSSQL
Data Engineering
Data Engineering

Reviews from Early Learners

Reviews from Early Learners

4.5

5.0

Jeong-ah Yoon

44% enrolled

Oh, professor, you're joking! I'm laughing so hard in class that I'm going crazy. I'm having so much fun in class.

5.0

jin4348

100% enrolled

This is an excellent lecture that contains the practical experience and know-how of a veteran senior.

5.0

김주미

33% enrolled

.

What you will gain after the course

  • Database Modeling in Practice

  • Database Design

100% practical ERD,
Make it from start to finish with your own hands!

Relational database design,
Confidently prepare for your practice! 💪

Customers, products, sales, inventory...
A database that takes care of all aspects of your business!

This lecture was created as a follow-up to the previous "RDBMS Modeling Fundamentals" lecture .

Anyone who learns about database design theory feels like they have a solid understanding of databases. However, when faced with practical applications, they often encounter numerous challenges. Therefore, it's tempting to seek insight by looking at a well-crafted ERD.

Most business programs often feature elements like the main entity (company), customers, products, and sales management. In this lecture, we'll design and implement a simple sales system from scratch using these core elements. Through this, I've strived to demonstrate how database design and development are implemented in practice. Join me as I cultivate the power to design databases with confidence!


Let's take on the challenge together! 👌

📣 Please check before taking the class!

  • This course uses Visual Studio Code 2019 and MSSQL Server 2019.

Created this course
Introducing the knowledge sharer 👨‍💻

Lee Kyo-jun

“I created this course to fully convey the know-how of practical database design and development.”

If you know everything, you might think that it's too easy to make things like this, but I made this lecture with the thought that it can be more helpful than you think for those who need even a little information, and that it can lead to a rapid improvement in skills in the field of database design practice.

Of course, I can't help but feel like I rushed it a bit, but after a while, I'd be completely immersed in the project for about a year, leaving me no time to prepare any more lectures, so I wrote this as quickly as possible. Please understand if there are any shortcomings, but I tried my best to include all the content.

Perhaps in about a year, I'll cover an intermediate OOP course using C#. At that time, I plan to engage in extensive discussion and review of how to best develop from a developer's perspective, using the ERD used in this course.

I hope this introduction will be helpful to many beginner developers who want to design their own databases.

Recommended for
these people

Who is this course right for?

  • People who understand the basics of database design and want to study more

  • People who want to learn databases at an intermediate level or higher

Need to know before starting?

  • Database Modeling Fundamentals Lecture

Hello
This is

5,148

Learners

366

Reviews

150

Answers

4.8

Rating

8

Courses

I will provide a brief overview of my educational background and professional experience.

Education

February 1987 Graduated from Inha University, Department of Computer Science and Engineering

February 1989, graduated from the Graduate School of Computer Science and Engineering at Inha University

August 2009 Completed Doctoral Coursework in Applied Software, Department of Computer Engineering, Korea Aerospace University

Key Experience

January 1989 – December 1992 Trigem Computer R&D Center

January 1993 ~ May 1995 Samsung Electronics Workstation Development Team

January 1998 – December 2005 CEO of ITA Co., Ltd. (Software development, database design and construction)

January 2006 – December 2017 National Archives Database Construction Project (PM)

May 2018 – March 2019 Korea IT Academy Instructor (C#, JAVA, Database)

March 2019 – Present: ERP and MES Database Design

Curriculum

All

18 lectures ∙ (11hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

21 reviews

4.5

21 reviews

  • kellyyoon823679님의 프로필 이미지
    kellyyoon823679

    Reviews 12

    Average Rating 4.8

    5

    44% enrolled

    Oh, professor, you're joking! I'm laughing so hard in class that I'm going crazy. I'm having so much fun in class.

    • jin1015님의 프로필 이미지
      jin1015

      Reviews 58

      Average Rating 4.8

      5

      100% enrolled

      This is an excellent lecture that contains the practical experience and know-how of a veteran senior.

      • sojin님의 프로필 이미지
        sojin

        Reviews 2

        Average Rating 5.0

        5

        33% enrolled

        • jykim86님의 프로필 이미지
          jykim86

          Reviews 4

          Average Rating 5.0

          5

          33% enrolled

          • nuclearbomb65185933님의 프로필 이미지
            nuclearbomb65185933

            Reviews 6

            Average Rating 5.0

            5

            33% enrolled

            $42.90

            kjlee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!