강의

멘토링

로드맵

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.6) 20 reviews

541 learners

  • kjlee
DBMS/RDBMS
Oracle
MSSQL
Data Engineering

Reviews from Early Learners

What you will learn!

  • 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,062

Learners

352

Reviews

148

Answers

4.8

Rating

7

Courses

대략적인 학력  경력을 소개드리겠습니다.

학력

1987년 2월 인하대학교 전자계산학과 졸업

1989년 2월 인하대학교 전자계산학과 대학원 졸업

2009년 8월 한국항공대학교 컴퓨터공학과 응용소프트웨어 박사과정 수료

주요 경력

1989년 1월 ~ 1992년 12월 삼보컴퓨터 기술연구소 

1993년 1월 ~ 1995년 5월 삼성전자 워크스테이션 개발팀

1998년 1월 ~ 2005년 12월 주식회사 아이티에이 대표이사 (소프트웨어 개발, 데이터베이스 설계 및 구축)

2006년 1월 ~ 2017년 12월 국가 기록물 데이터베이스 구축사업 (PM)

2018년 5월 ~ 2019년 3월 코리아IT 컴퓨터 학원 강사 (C#, JAVA, Database)

2019년3월 ~ 현재 ERP, MES Database 설계 

Curriculum

All

18 lectures ∙ (11hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

20 reviews

4.6

20 reviews

  • kellyyoon823679님의 프로필 이미지
    kellyyoon823679

    Reviews 5

    Average Rating 4.6

    5

    44% enrolled

    アナ教授ジョーク!授業を聞いてとても面白くて完全に推測してしまいます とても楽しく授業を聴いています

    • jin1015님의 프로필 이미지
      jin1015

      Reviews 57

      Average Rating 4.8

      5

      100% enrolled

      ベテラン先輩の実務経験ノウハウが溶けた素晴らしい講義です。

      • sojin님의 프로필 이미지
        sojin

        Reviews 2

        Average Rating 5.0

        5

        33% enrolled

        • jykim86님의 프로필 이미지
          jykim86

          Reviews 3

          Average Rating 5.0

          5

          33% enrolled

          • nuclearbomb65185933님의 프로필 이미지
            nuclearbomb65185933

            Reviews 6

            Average Rating 5.0

            5

            33% enrolled

            Limited time deal ends in 7 days

            $5,077.00

            23%

            $42.90

            kjlee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!