
데이터베이스 중급(Modeling)
이교준
본 강좌는 데이터베이스 설계 이론을 실습 위주로 쉽게 풀어냈습니다. 책 등을 통해서 경험하신 분들은 대부분 데이터베이스 이론이 어렵다고 느끼고 포기하신 경험들이 있을 겁니다. 저도 그랬습니다. 그러나 알고보면 쉬우면서도 매우 흥미로운 분야라는 것을 알게 됩니다. 본 강좌에서는 아주 쉽게 보고만 있어도 이해가 될 수 있도록 설계 내용을 구성하였습니다.
초급
DBMS/RDBMS, 데이터 엔지니어링
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.
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 👍
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.
📣 Please check before taking the class!
“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.
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
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 설계
All
21 lectures ∙ (12hr 51min)
Course Materials:
1. Interface - I
27:18
2. Interface - II
01:01:45
All
6 reviews
4.5
6 reviews
Reviews 7
∙
Average Rating 4.6
Reviews 2
∙
Average Rating 5.0
Reviews 5
∙
Average Rating 4.6
Reviews 2
∙
Average Rating 5.0
Reviews 39
∙
Average Rating 5.0
$42.90
Check out other courses by the instructor!
Explore other courses in the same field!