강의

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

[Management Course #2] DBA (ERD, Database Design)

In this lecture, you will learn how to create an ERD. You will learn database design. (The only big data design lecture in Korea)

(3.8) 9 reviews

60 learners

  • vmproductor0202
데이터베이스설계
db설계
dba
mssql
DB_테이블_설계
3시간 만에 완강할 수 있는 강의 ⏰
Big Data
ERD
olap
oltp
DBMS/RDBMS

What you will learn!

  • Database design

  • ERD

  • Table design for big data

  • Database

  • DataBase Design

Learn ERD through database design!
Study with a focus on practical knowledge 🤓

After system design, it's time for the database! 📈

What happens if you use a program or website without a database? Any data that needs to be shared within that program or website will be reset when the server restarts. To prevent this, you need to store data to be managed or stored, as well as data to be shared between systems, in a database.

💡 Why is database design necessary?

  • It allows us to derive the correct way to store data .
  • You can derive both performance and analysis advantages .
  • You can prevent errors that may occur when saving, retrieving, or inserting data.


If you studied system design in the previous lecture, " 1. Management Course [Design] (UML+ClassDiagram) ," this lecture will cover practical aspects of data storage and management, including how to use the program . This lecture covers database design theory and practice, using MSSQL. Through this lecture, you'll learn how to understand and create ERDs and explore the relationships between tables!

We'll also help you understand and create practical terminology and tables. Table design methodology , a fundamental tool for big data, is widely used globally, but it's not widely known among Koreans, so we've created this course to share it with you. We hope you'll also gain knowledge of DBA terminology used overseas.

Example of a practical demonstration


I recommend this to these people 🙋‍♀️

How to design a database
The worried deputy manager~manager

Databases in Practice
For those curious about the design process

Thinking about how to process big data
Architecture, Consultants


Learn things like this ✨

Selected from Korean practice
Database design methodology

When designing a practical database
Terms and techniques you can use

Foreign design methodologies and
Improved data retrieval performance

In practice
Understanding table structure

For big data
Table design work method

Through practice
Make the knowledge yours!


Expected Questions Q&A 💬

Q. Is the lecture difficult?

You can learn sufficiently by following the practical method and also explaining the necessary theory.

Q. I don't know much about databases, but can I still take the course?

This course assumes a basic understanding of databases. Therefore, it will not be helpful without at least one year of practical experience as a backend developer or the equivalent of a fourth-year undergraduate degree. To supplement this, prior knowledge of the databases listed below is required.


Recommended for
these people

Who is this course right for?

  • Agent~Manager

  • consultant

  • Architecture

  • DBA

Hello
This is

22,642

Learners

778

Reviews

283

Answers

4.4

Rating

23

Courses

국내IT실무진 기술선도자입니다.

국내유일강의:

전자정부프레임워크,LAYERED 아키텍처

,WPF_MVVM패턴.OLAP,SSIS.SSAS 등

The only lecture in the world:

Springframework + Enterprise Architecture[EA],

Query refactoring ,SignalR + JWT

MAUI + MVVM + AZURE, etc.

 

강의 중 궁금한 사항은

해당 강의의 질문&답변 또는

이메일 vmproductor@gmail.com로 남겨주세요.

강의 외적인 상담, 궁금한 사항,취업상담등도 받고 있습니다.

 

경력-

컴퓨터공학과 학사학위. 정보처리기사 취득

ExtremeNetworks(한국) 네트워크세계2위업체 인턴(전)

번역 웹,안드로이드,AI 개발 및 유지보수(전)

ERP 웹개발(전)

데이터베이스,서버 관리자(전)

MES,FA (전)

E-Commerce웹개발(전)

국가시설 원격제어 및 모니터링(현)

 

파트-

디자이너,웹,안드로이드,원격자동화시스템,번역프로그램,서버,네트워크,화이트해커,Angular

프로젝트관리자,DBA(MSSQL,ORACLE,MYSQL),DE,OS programming,응용 소프트웨어,천체물리학

등등을전문으로 다루고있습니다.

Curriculum

All

9 lectures ∙ (1hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

9 reviews

3.8

9 reviews

  • ckim1215님의 프로필 이미지
    ckim1215

    Reviews 1

    Average Rating 5.0

    5

    67% enrolled

    • soohyunkim9644님의 프로필 이미지
      soohyunkim9644

      Reviews 4

      Average Rating 5.0

      5

      33% enrolled

      • evergreen9781님의 프로필 이미지
        evergreen9781

        Reviews 4

        Average Rating 5.0

        5

        33% enrolled

        • jskim25075님의 프로필 이미지
          jskim25075

          Reviews 1

          Average Rating 5.0

          5

          89% enrolled

          • jsh4258님의 프로필 이미지
            jsh4258

            Reviews 3

            Average Rating 4.7

            4

            67% enrolled

            $26.40

            vmproductor0202's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!