강의

멘토링

커뮤니티

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) 10 reviews

63 learners

Level Basic

Course period Unlimited

  • vmproductor0202
Big Data
Big Data
ERD
ERD
olap
olap
oltp
oltp
DBMS/RDBMS
DBMS/RDBMS
Big Data
Big Data
ERD
ERD
olap
olap
oltp
oltp
DBMS/RDBMS
DBMS/RDBMS

What you will gain after the course

  • 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

23,379

Learners

847

Reviews

288

Answers

4.4

Rating

24

Courses

I am a technology leader among IT professionals in Korea.

The only lecture in Korea:

eGovFrame, LAYERED Architecture

,WPF_MVVM pattern. OLAP, SSIS, SSAS, etc.

The only lecture in the world:

Springframework + Enterprise Architecture[EA],

Query refactoring, SignalR + JWT

MAUI + MVVM + AZURE, etc.

If you have any questions during the lecture,

Questions and answers regarding this lecture, or

Please leave a message at vmproductor@gmail.com.

I also offer consultations for non-lecture related matters, general inquiries, and career counseling.

Experience-

Bachelor's degree in Computer Science. Certified Engineer Information Processing.

ExtremeNetworks (Korea), former intern at the world's 2nd largest network company

Web, Android, AI development and maintenance (former)

ERP Web Development (Former)

Database, Server Administrator (Former)

MES, FA (Former)

E-Commerce Web Development (Former)

Remote control and monitoring of national facilities (current)

Web, Android, AI development and maintenance (Former) ERP web development (Former) Database, Server Administrator (Former) MES, FA (Former) E-Commerce web development (Former) Remote control and monitoring of national facilities (Current)

Part-

Designer, Web, Android, Remote Automation Systems, Translation Programs, Server, Network, White Hat Hacker, Angular

Project Manager, DBA (MSSQL, ORACLE, MYSQL), DE, OS programming, Application Software, Astrophysics

I specialize in these and other related fields.

Curriculum

All

9 lectures ∙ (1hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

3.8

10 reviews

  • yhcho9658님의 프로필 이미지
    yhcho9658

    Reviews 1

    Average Rating 4.0

    4

    100% enrolled

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

          Average Rating 5.0

          5

          33% enrolled

          • jskim25075님의 프로필 이미지
            jskim25075

            Reviews 2

            Average Rating 5.0

            5

            89% enrolled

            $26.40

            vmproductor0202's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!