Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Programming

/

Database

RDBMS Modeling Programming Practice (C#)

This course does not teach the grammar of C#. It simply uses C# as a tool for designing object-oriented programs. This course covers in depth the essential content that intermediate and higher level programmers need to know, as well as the content that is essential to developing programs that are linked to databases.

(4.5) 6 reviews

116 learners

  • kjlee
DBMS/RDBMS
MSSQL
Data Engineering

Reviews from Early Learners

What you will learn!

  • How to develop applications

  • How to reduce call depth

  • Designing model classes that map to database tables

  • Clear understanding of classes and functions

Easy to understand with a simple structure
The Secret to Database Programming Practice 👍

Reduce errors and increase scalability
The ultimate programming technique ! 💥

This lecture is the final course following the previous lecture , “RDBMS Modeling Basics, Practice.”

Programs work no matter how they're developed. However, there are clearly good and bad programs. What do you consider a good program? Answers to this question may vary slightly, but ultimately, a good program is one that's easy to understand and maintain .

One of the essential requirements for a good program is a structure that facilitates easy error correction. Simple handling of every aspect facilitates extension and error correction. Why does call depth increase? And how can we reduce it? This lecture focuses on these aspects.

This lecture aims to enable those who have learned the theory and practice of database modeling in the previous two lectures to apply database modeling to real-world programming . From a programmer's perspective, how can we create "good" programs that interact with databases? No matter how much you want to write a good program, if the database design is flawed, it will be impossible to create well-defined model classes from the program's perspective. A poorly designed model class can effectively shake the foundation of the entire program. Therefore, this lecture assumes the presence of a well-designed database. Therefore, I recommend taking the database design lecture first, and for those who have completed that course, this lecture will serve as a crucial final guide.


Let's take on the challenge together ! 📚

📣 Please check before taking the class!

  • This course uses C# 4.8 and WinForms.

Created this course
Introducing the knowledge sharer 👨‍💻

Lee Kyo-jun

“I’ll teach you the 70% formula that’s essential when developing database programs.”

A program is 70% formula and 30% creativity. Surprisingly, most of the 70% formulas contain development principles. And if you follow those principles, your program will never become complex or difficult. The most difficult and complex part of a program is probably receiving and modifying data from the user. However, even this part can be made very clear and reliable through formulas, and there are methods that make it so simple that you can develop it blindly through perfect formulas.

Therefore, programmers who know how to create good programs focus on the 30% of creativity: handling business logic. There's no formula for this 30% of creativity. Because implementing logic isn't a formula, it's crucial to design first and then develop the program.

Another important issue is how to implement model classes to represent database table relationships. This guide provides clear solutions for designing model classes when there are parent-child tables and they need to be displayed as a master/detail relationship on the screen. The effectiveness of this guide can be further enhanced by using paid components like DevExpress Tools.

The technical content in this lecture is unlike anything I've ever seen in any book or lecture. This is because I've personally experienced and discovered important aspects while developing programs. I can confidently say that those who understand all three parts of my relational database modeling series will grow ten times faster than other programmers.

After attending this course, I believe you'll be able to develop a small project on your own. If you have any questions during development after attending the course, please apply for mentoring. I'll be happy to help you with any questions and discuss them with you.

Recommended for
these people

Who is this course right for?

  • People without much experience in application development

  • For those of you who are thinking about how to develop a program

  • For those who want to learn database programs systematically

  • People working on a one-man project

  • People who are worried about not being able to learn programming techniques from senior developers

Need to know before starting?

  • C# Programming Fundamentals

  • Database Modeling Theory

  • Database Modeling Practice

Hello
This is

5,043

Learners

349

Reviews

147

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

21 lectures ∙ (12hr 51min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

6 reviews

4.5

6 reviews

  • luckyctj님의 프로필 이미지
    luckyctj

    Reviews 7

    Average Rating 4.6

    5

    100% enrolled

    c# 갓 입문자를 벗어난 실력인데 실력향상에 많은 도움이 되엇읍니다. 반복학습 및 실제로 강의 내용을 코딩해 가면서 코드를 다 외울때까지 반복학습 해야 할것 같습니다. 좋은 강의 만들어 주신 선생님께 감사드립니다

    • 김종철 (JCKim)님의 프로필 이미지
      김종철 (JCKim)

      Reviews 2

      Average Rating 5.0

      5

      100% enrolled

      좋은 Knowhow 공유해 주셔서 감사합니다. 추후 완성된 프로그램의 배포 및 Update 관련하여 강의해주시는것 고려 부탁드립니다.

      • besthjp님의 프로필 이미지
        besthjp

        Reviews 5

        Average Rating 4.6

        5

        100% enrolled

        VB에서 C#으로 전환하는 과정에서 수강하게 되었는데, 교과서적인 내용을 떠나 실제 개발환경에서 적용되는 과정... 큰 경험이 되고 있습니다.

        • 천사돌님의 프로필 이미지
          천사돌

          Reviews 2

          Average Rating 5.0

          5

          43% enrolled

          감사합니다. (_ _)

          • 박정식님의 프로필 이미지
            박정식

            Reviews 39

            Average Rating 5.0

            5

            100% enrolled

            많은것을 배운강의였습니다. 이번강의가 첫강의였는데, 나머지 강의들도 시간을 내서 들어봐야겠네요. 수고하셨습니다.

            $42.90

            kjlee's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!