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

554 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

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,187

Learners

370

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

  • hhpark9031님의 프로필 이미지
    hhpark9031

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    I've heard good things!

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

      • luckyctj4427님의 프로필 이미지
        luckyctj4427

        Reviews 7

        Average Rating 4.6

        5

        33% enrolled

        Thank you for the great lecture.

        • kjumi8634님의 프로필 이미지
          kjumi8634

          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.

            kjlee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            25% off for new members

            $32.90

            25%

            $42.90