inflearn logo
inflearn logo

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

549 learners

Level Intermediate

Course period Unlimited

DBMS/RDBMS
DBMS/RDBMS
Oracle
Oracle
MSSQL
MSSQL
Data Engineering
Data Engineering
DBMS/RDBMS
DBMS/RDBMS
Oracle
Oracle
MSSQL
MSSQL
Data Engineering
Data Engineering
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

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 kjlee

5,154

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

More

Reviews

All

21 reviews

4.5

21 reviews

  • jykim86님의 프로필 이미지
    jykim86

    Reviews 4

    Average Rating 5.0

    5

    33% enrolled

    • nuclearbomb65185933님의 프로필 이미지
      nuclearbomb65185933

      Reviews 6

      Average Rating 5.0

      5

      33% enrolled

      • sojin님의 프로필 이미지
        sojin

        Reviews 2

        Average Rating 5.0

        5

        33% enrolled

        • 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.

            kjlee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $42.90