๊ฐ•์˜

N
์ฑŒ๋ฆฐ์ง€

๋ฉ˜ํ† ๋ง

N
ํด๋ฆฝ

๋กœ๋“œ๋งต

Programming

/

Database

Easy to Learn Data Modeling: From Basics to Practical Table Design (DASP/DAP)

Have you ever felt frustrated with table design? This course is for those who have had concerns like, "Is this table right?", "Which column should be the PK?", "Is it okay to connect relationships this way?", or "Will I have to rebuild the table when adding new features?"

(4.8) 9 reviews

59 learners

Level Basic

Course period Unlimited

SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
ERD
ERD
database-modeling
database-modeling
Data Architecture Semi-Professional
Data Architecture Semi-Professional
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
ERD
ERD
database-modeling
database-modeling
Data Architecture Semi-Professional
Data Architecture Semi-Professional

Reviews from Early Learners

4.8

5.0

์ค€์˜

32% enrolled

It is great for building a foundation in an easy-to-understand way.

5.0

Rootree

100% enrolled

I am a developer, but I took this course because I have a great interest in DB modeling. It was great to be able to organize concepts that were difficult and hard to understand during my job search with easy examples. Thanks to the explanations that followed theory with step-by-step examples, I was able to clearly understand parts that could have been difficult to grasp :) I think this is a course that experienced professionals can listen to comfortably, with the feeling of reviewing the basics. The tone of the lecture itself was great because it felt like a friendly senior colleague explaining things calmly. If the instructor releases more courses in the future, I will look forward to taking them :) Oh, and the fact that I can ask the instructor about career concerns after completing the course was a huge motivation for me to finish it haha. I will be sending an email inquiry soon~!! Thank you for creating such a great lecture!

5.0

yooonuu

100% enrolled

There are times when I design tables during development, and after listening to the lecture, many of my uncertainties seem to have been resolved. Above all, I struggled with writing queries due to poor table design, so itโ€™s comforting to hear that it wasn't because of my lack of query-writing skills ใ… ใ… 

What you will gain after the course

  • How to analyze requirements and design tables

  • Essential concepts of 'Logical Data Modeling' regarding entities, attributes, identifiers, and relationships

  • Knowledge for obtaining DASP and DAP certifications

  • Table design methods considering performance

  • Notations for drawing ERDs (IE, Barker)

๊ฐ•์˜์†Œ๊ฐœ_๋ฉ”์ธ์ด๋ฏธ์ง€2

Is your table design okay?

  • The anxiety of not feeling confident every time you design

  • A complex structure that is already tangled when you try to modify it

  • Adding features = Redesigning tables repetition

  • Data modeling that you've never learned systematically


In this course, you will learn how to design tables that are not just 'functional,'
but scalable and easy to maintain.

Concerns everyone faces in practice

Creating a table that properly captures customer requirements is not easy.
It is difficult to judge on your own which structure is appropriate, whether the design is easy to modify, or if the structure is scalable.

Even when searching for answers, every situation is different, and in the end, the anxiety of wondering, 'Is this the right way?' only grows.

๊ถ๊ธˆ์ฆ_์ด๋ฏธ์ง€3

Design problems grow larger as time passes.

It seemed fine at first...

Many developers have similar experiences.
In the early stages of a project, the focus is on quickly creating tables and implementing development features.
Since there is little data and the requirements aren't extensive, everything feels like it's going smoothly.

However, as time passes and the project grows and becomes more complex,
the table structure that was built "only for speed" in the beginning gradually becomes a major obstacle.

Even simple feature additions require modifying multiple tables, bugs recur due to data consistency issues, and
eventually, you end up regretting it, thinking, "If only I had designed it properly back then..."


Initial stage

๐Ÿ˜Š

  • "As long as it can hold the data, it's fine!"

  • Designing without deep consideration

    Cramming all necessary attributes into a single table for the sake of rapid development

  • When the data volume is small, it seems to have no issues


6 months later

๐Ÿ“‰

  • Every time a feature is added, table structure modification is required

  • The same data is duplicated across multiple tables, causing consistency issues

  • Queries become increasingly complex and performance starts to slow down

After 1โ€“2 years

๐Ÿšจ

  • Adding a single feature requires modifying too many places

  • Always struggling to decide which table to get the necessary data from

  • Data inconsistencies occur frequently, and it takes a lot of time to fix them


Solution: Proper Data Modeling (Table Design)

Same requirements, different designs

Even when implementing the same functionality, the results vary completely depending on how it is designed.
A table designed with scalability in mind can easily adapt to changing requirements.

On the other hand, tables created without deep consideration require numerous modifications for even small changes and lead to continuous unexpected issues.

In the beginning, these differences are not easily visible. Both seem to work just fine.
However, as time passes, the difference manifests in development speed and the difficulty of maintenance.

โญ This course covers how to design scalable tables.
You will learn how to do it "right from the start," rather than saying "I"ll fix it later."
By the end of the course, you will be able to look at requirements and design them into a scalable structure.


๐Ÿ“ŒCustomer Requirements๐Ÿ“Œ

  1. You can check the weekly menu at the cafeteria.

  2. Lunch and dinner are provided from Monday to Friday, and for each meal plan,

    Information about the nutritionist who provided the meal plan can be checked.

  3. The meal menu must include rice and soup, and can include multiple side dishes.

    Calories must also be managed.

  4. In some cases, side dishes such as yogurt, ice cream, and fruit are also served.

์‹๋‹จ1

๐Ÿ‘ŽA model designed without much thought

์‹๋‹จ2

๐Ÿ‘A model designed with sufficient consideration

Features of this course

1. Practical-focused learning

Composed of content that can be applied directly in practice, rather than just simple theory

  • Presents common real-world challenges and their solutions

  • Use of practical examples such as book rental systems and shopping malls.

  • Learn by following the data modeling steps directly.

1.4
1.5
1.6

2. Systematic Lecture Materials

Perfect review with 700 pages of PPT materials

  • Easy to grasp concepts with content summarized to the essentials

  • A reference you can look up anytime

2.1
2.2
2.3

3. Easy Practice for Everyone

Start immediately without any special preparation

  • Paper and pen are enough; tools are optional.

  • Practice using the web-based ERD Cloud without any separate installation.

  • Explaining both Barker notation and IE notation

3.1
3.2
3.3

Course Composition (Detailed Table of Contents: Check out what content is covered in the course.)

1. Starting the Data Modeling Basics Lecture

Course Introduction: Have you ever felt frustrated during the table design process?

  • What the course covers

  • Who is this course for? (Feat. Developers and novice modelers who need DB design)

  • Lecture Composition

  • Prerequisite knowledge for taking the course


How to Improve Work Efficiency and Development Productivity

  • What is data modeling?

  • We are not maintaining ERDs.

  • If you design it this way, you will suffer later.

Checking My Understanding of Data Modeling

  • Quiz 1: True/False Questions

  • Quiz 2: Matching the Number of Tables

2. The first step for data modeling

Steps from requirements analysis to table creation

  • Data modeling steps explained through a toy project

  • Requirements Analysis/Definition

  • Setting Subject Areas

  • Conceptual Data Modeling

  • Logical Data Modeling

  • Physical Data Modeling

  • Can the data modeling stages be simplified?

Data Modeling Notations (Barker, IE)

  • Barker/IE Notation for Data Modeling

  • Entity Notation

  • Attribute Notation

  • Identifier Notation

  • Relationship Notation

  • Subtype notation

Data Modeling Tools (ERwin DA# ERDCloud)

  • ERwin DA# ERDCloud

  • ERDCloud Practice

3. Entity [Table]: What information should be derived as a table?

What is an Entity

  • Concept of Entity

  • Table? Entity? What's the difference?

How to derive entities from requirements

  • How should entities be derived?

  • The core of data modeling: 'Entity Extraction'

  • [Practice] Step-by-step Entity Derivation

Checking if entities have been 'well' derived

  • Whether a clear meaning has been assigned to the entity

  • Whether it is a target that requires management

  • Whether it forms a set

  • Whether it is dependent on the business process

  • Whether it possesses independence

  • Whether entities were derived based on each individual screen.

By classifying entities, you can understand what kind of data is being stored

  • Entities also have personalities.

  • The secret to excellent table design: Classifying entities by their characteristics

  • Benefits of Entity Classification

4. Attributes [Columns]: Not all columns in the requirements are added.

What is an attribute

  • Concept of Attributes

  • Components of an attribute

Attribute classification that makes query development easier

  • Reasons for classifying attributes

  • Basic attributes

  • Relationship Attributes

  • Derived Attributes/Redundant Attributes

  • System Attributes

Special attribute design that many developers miss

  • Special Attributes

  • Multi-valued attribute

  • Composite Attribute

  • Exclusive Attribute

  • Code Attribute

Attribute Derivation Method

  • The secret to finding the attributes you truly need

  • [Practice] Following the Attribute Derivation Process

5. Identifiers [PK]: Select these types of columns as the PK.

What is an Identifier

  • Concept of Identifiers

  • Characteristics of Identifiers

  • Classification of Identifiers

Artificial identifiers commonly used as 'OO Number'

  • Natural Identifiers and Surrogate Identifiers (feat. Real Subjects and Dummy Subjects)

  • Identifiers commonly used by entity type

  • Should we use a natural identifier? Or should we use a surrogate identifier?

Identifier Selection Method

  • [Practice] Following the Identifier Selection Process

  • Precautions when selecting identifiers

Various stories related to identifiers

  • What if we unconditionally use artificial identifiers?

  • Product Number Attribute Format (000000121 vs GOD000121 vs 121)

  • The habit of thinking about sample data

6. Relationship [FK]: Connection between tables - Join

What is a Relationship?

  • Concept of Relationships

  • Relationships and Joins

Components of a Relationship (Relationship Cardinality, Relationship Optionality, Relationship Name)

  • Components of a relationship

  • Relationship Cardinality (1:1 / 1:M / M:N)

  • Relationship Optionality (Optional / Mandatory)

  • Relationship Name

The secret to connecting relationships easily

  • The hidden meaning behind relationship lines

  • Dependent relationship

  • Reference Relationship

  • Identifying and Non-identifying Relationships

  • Summary of Dependent/Reference and Identifying/Non-identifying Relationships

Tricky relationships encountered in practice (Multiple, Recursive, Exclusive, BOM)

  • Various Relationships

  • Multiple Relationships

  • Recursive Relationship (= Circular Relationship)

  • Exclusive Relationship (= Arc Relationship)

  • BOM Relationship

Relationship Derivation Method

  • [Practice] Following Along with Relationship Derivation 1

  • [Practice] Following Along with Relationship Derivation 2

Various stories related to relationships

  • Are Foreign Key (FK) constraints necessary? (feat. My company doesn't create FKs)

  • Cases where you don't need to connect relationship lines

  • Connecting relationships for performance improvement

7. Subtypes: How to Strategically Manage Similar Entities

Subtype and Supertype

  • Subtype/Supertype Concepts

  • Subtype/Supertype Characteristics

In what situations should subtypes be used?

  • Reasons for using subtypes

  • Situations where subtypes should be derived

How to derive subtypes

  • [Practice] Following the Subtype Derivation Process

  • Precautions when deriving subtypes

Creating tables for entities that include subtypes

  • 3 types of table creation for entities including subtypes

  • Type 1. Subtype structure

  • Type 2. Integrated Table Structure

  • Type 3. Individual table structure

  • Criteria for selecting table creation types

8. Normalization and Denormalization: Perfect Structure vs. Fast Performance

What is Normalization

  • Concept of Normalization

  • Normalization: Why should we do it?

  • Advantages and Disadvantages of Normalization

1st Normalization - Let's separate duplicates!

  • Definition of 1st Normal Form (1NF)

  • Problems when 1st Normal Form is not applied

  • [Practice] Shall we improve it?

2nd Normalization - Ensure full dependency on all identifier attributes!

  • Definition of 2nd Normal Form (2NF)

  • Problems when 2nd Normalization is not performed

  • [Practice] Shall we improve it?

3rd Normalization - Are there dependencies between non-identifier attributes?

  • Definition of 3rd Normal Form (3NF)

  • Problems that occur when 3rd Normal Form (3NF) is not applied

  • [Practice] Shall we improve it?

What is De-normalization?

  • Concept of Denormalization

  • Essential! Checklist before performing denormalization

  • Advantages and disadvantages of denormalization

3 Denormalization Methods for Performance Improvement

  • Creating duplicate columns

  • Creating Duplicate Tables

  • Table Partitioning

9. Common Code and History Management

Common Code

  • What is a common code?

  • Reasons for using codes

  • Precautions when designing common codes

How to design common codes

  • [Practice] Common Code Design Method 1

  • [Practice] Common Code Design Method 2

  • Common Code VS Individual Code

History Management

  • What is history?

  • History management is essential in OO situations.

  • [Practice] History Design Method 1

  • [Practice] History Design Method 2

Recommended for
these people

Who is this course right for?

  • 'Developers' who need DB table designs for each business domain

  • A 'novice modeler' who needs to perform data modeling while considering the overall structure

  • For those aiming to obtain DASP or DAP certifications!

Need to know before starting?

  • The concept of Joins in SQL

  • Basic understanding of Select ~ From ~ Where queries

Hello
This is Archix

Career Verified

59

Learners

9

Reviews

4.8

Rating

1

Course

Hello ๐Ÿ‘‹

I am Archix, working as a Data Architect at a foreign company.

Starting as a back-end developer, I earned SQLP ๐ŸŽ– and DAP ๐ŸŽ– certifications to pursue a career as a data expert. Currently, I work to improve data management by supporting developers with data model optimization and query tuning.

Through my experience with various projects and operations, I have come to realize one thing clearly: a system with a solid design does not falter. On the other hand, a poorly designed system suffers from recurring minor issues, which ultimately leads to a waste of unnecessary resources.

Having worked as a developer, I have experienced these situations firsthand, and I aim to incorporate those experiences into this lecture to provide content that can be applied immediately in practice.

I plan to continue my activities to promote the importance of data modeling in various fields.

If you have any questions about the DA role or your career after completing the course, please feel free to contact me at the email address below along with your "Course Completion" certification. I will do my best to help you as much as I can.

๐Ÿ“ฉcherish1058@naver.com

Thank you.

More

Curriculum

All

37 lectures โˆ™ (9hr 42min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

9 reviews

4.8

9 reviews

  • parkjun6115559๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    parkjun6115559

    Reviews 6

    โˆ™

    Average Rating 5.0

    5

    32% enrolled

    It is great for building a foundation in an easy-to-understand way.

    • cherish10588578
      Instructor

      Thank you for your review, Junyoung. I hope this helps you solidify your understanding of basic modeling concepts. If you have any questions, please feel free to ask. Thank you!

  • bbyyydd๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    bbyyydd

    Reviews 5

    โˆ™

    Average Rating 4.6

    5

    100% enrolled

    There are times when I design tables during development, and after listening to the lecture, many of my uncertainties seem to have been resolved. Above all, I struggled with writing queries due to poor table design, so itโ€™s comforting to hear that it wasn't because of my lack of query-writing skills ใ… ใ… 

    • cherish10588578
      Instructor

      I'm glad the ambiguous parts have been resolved. Queries for poorly designed tables tend to use many inline views, and with so much similar data, it becomes a struggle to figure out where to pull the information from. I'm sure you'll be able to create well-thought-out and well-designed structures in the future! Thank you.

  • devrootree๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    devrootree

    Reviews 4

    โˆ™

    Average Rating 5.0

    5

    100% enrolled

    I am a developer, but I took this course because I have a great interest in DB modeling. It was great to be able to organize concepts that were difficult and hard to understand during my job search with easy examples. Thanks to the explanations that followed theory with step-by-step examples, I was able to clearly understand parts that could have been difficult to grasp :) I think this is a course that experienced professionals can listen to comfortably, with the feeling of reviewing the basics. The tone of the lecture itself was great because it felt like a friendly senior colleague explaining things calmly. If the instructor releases more courses in the future, I will look forward to taking them :) Oh, and the fact that I can ask the instructor about career concerns after completing the course was a huge motivation for me to finish it haha. I will be sending an email inquiry soon~!! Thank you for creating such a great lecture!

    • cherish10588578
      Instructor

      Thank you for the course review, Rootree. As you mentioned, concepts that were once complex and difficult to understand often become unexpected variables in practice. I believe that having a clear understanding of these fundamental concepts will allow you to make more accurate judgments in various situations. Thank you very much for the detailed review. Additionally, if you have any career-related inquiries, please send them via email and I will get back to you. Thank you.

  • tough๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    tough

    Reviews 1

    โˆ™

    Average Rating 5.0

    5

    32% enrolled

    • cherish10588578
      Instructor

      Thank you for your review, tough. Please let me know if you have any further questions. ๐Ÿ˜€

  • hslee307381๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    hslee307381

    Reviews 4

    โˆ™

    Average Rating 5.0

    5

    32% enrolled

    Similar courses

    Explore other courses in the same field!

    Surviving the AI Era: Build Your Backend in a Flash with Supabase!Course Thumbnail

    Surviving the AI Era: Build Your Backend in a Flash with Supabase!

    zerocho

    With the arrival of the AI era, the skills required of developers are becoming increasingly complex. You might have thought, "I just need to be good at frontend," but when you try to create your own service or integrate AI features, you eventually hit a massive wall called the backend. However, as you try to start backend development, are you overwhelmed by how much there is to learnโ€”from database design and authentication (Auth) to storage management and complex infrastructure setup? Now, you can lay down that heavy burden. In this course, we use Supabase, which solves all these backend functions at once. We will guide you through the fastest shortcut to becoming a full-stack developer who can "instantly" complete a backend without complex server knowledge and bring ideas to life immediately.

    Basic

    Basic

    Node.js, DBMS/RDBMS, OAuth

    Surviving the AI Era: Build Your Backend in a Flash with Supabase!Course Thumbnail

    Surviving the AI Era: Build Your Backend in a Flash with Supabase!

    zerocho

    Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in PracticeCourse Thumbnail

    Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in Practice

    yh

    Solve the challenges you inevitably face in real-world designโ€”such as common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, and JSON utilizationโ€”with 9 core patterns. This is not just simple theory; it contains practical know-how and selection criteria for various scenarios, proven across numerous projects. Now, become a true design expert who can confidently handle any requirement that comes your way.

    Basic

    Basic

    SQL, MySQL, DBMS/RDBMS

    Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in PracticeCourse Thumbnail

    Young-han Kim's Practical Database - Design Part 2, 9 Design Patterns You Must Encounter in Practice

    yh

    Backend Design Basics for AI - SpringBoot SNS EditionCourse Thumbnail

    Backend Design Basics for AI - SpringBoot SNS Edition

    apiece

    This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

    Basic

    Basic

    PostgreSQL, Spring Boot, DBMS/RDBMS

    Backend Design Basics for AI - SpringBoot SNS EditionCourse Thumbnail

    Backend Design Basics for AI - SpringBoot SNS Edition

    apiece

    High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

    High-Performance SQL for JPA (ORM) Developers

    Vlad Mihalcea

    Make the most of relational database systems!

    Intermediate

    Intermediate

    SQL, performance-tuning, sql-query

    High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

    High-Performance SQL for JPA (ORM) Developers

    Vlad Mihalcea

    RDBMS Modeling Programming Practice (C#)Course Thumbnail

    RDBMS Modeling Programming Practice (C#)

    kjlee

    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.

    Intermediate

    Intermediate

    DBMS/RDBMS, MSSQL, Data Engineering

    RDBMS Modeling Programming Practice (C#)Course Thumbnail

    RDBMS Modeling Programming Practice (C#)

    kjlee

    Easy to understand, SQL secret recipe for everyoneCourse Thumbnail

    Easy to understand, SQL secret recipe for everyone

    mktcrmer8678

    A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

    Basic

    Basic

    SQL, Big Data, Data Engineering

    Easy to understand, SQL secret recipe for everyoneCourse Thumbnail

    Easy to understand, SQL secret recipe for everyone

    mktcrmer8678

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

    Masocampus

    Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

    Beginner

    Beginner

    SQL, SQLD

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

    Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

    Masocampus

    Hands-on SQLD Practice (Subject 2)Course Thumbnail

    Hands-on SQLD Practice (Subject 2)

    coddatg

    For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

    Basic

    Basic

    SQL, Oracle, MSSQL

    Hands-on SQLD Practice (Subject 2)Course Thumbnail

    Hands-on SQLD Practice (Subject 2)

    coddatg

    Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by SolvingCourse Thumbnail

    Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving

    Neo

    Learning by Doing: ์ •๋ณด์ฒ˜๋ฆฌ์‚ฐ์—…๊ธฐ์‚ฌ I have prepared everything for passing the ์ •๋ณด์ฒ˜๋ฆฌ์‚ฐ์—…๊ธฐ์‚ฌ course-evaluation practical exam.

    Beginner

    Beginner

    HTML/CSS, Java, SQL

    Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by SolvingCourse Thumbnail

    Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving

    Neo

    [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

    [MMORPG Game Development Series with C# and Unity] Part 5: Database

    Rookiss

    This is a course for learning MS-SQL through baseball and corporate databases.

    Basic

    Basic

    SQL, DBMS/RDBMS

    [MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

    [MMORPG Game Development Series with C# and Unity] Part 5: Database

    Rookiss

    Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQLCourse Thumbnail

    Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQL

    may9noy

    Learn how to analyze 5 million Korean apartment transaction data using PostgreSQL. Covers the process of data cleaning, transformation, and deriving meaningful insights through various SQL queries.

    Basic

    Basic

    PostgreSQL, DBMS/RDBMS, data-analysis

    Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQLCourse Thumbnail

    Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQL

    may9noy

    The Essence of SQLD: Mastering the Yellow Book Problem SetCourse Thumbnail

    The Essence of SQLD: Mastering the Yellow Book Problem Set

    jungmina

    Doing it carelessly is worse than not doing it at all. You'll just waste time! From now on, let's solve it thoroughly and perfectly together!

    Basic

    Basic

    SQLD, SQL, Oracle

    The Essence of SQLD: Mastering the Yellow Book Problem SetCourse Thumbnail

    The Essence of SQLD: Mastering the Yellow Book Problem Set

    jungmina

    MySQL from a Kakao Interviewer Handling 1 Trillion++ Data PointsCourse Thumbnail

    MySQL from a Kakao Interviewer Handling 1 Trillion++ Data Points

    Hong

    This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

    Beginner

    Beginner

    MySQL, DBMS/RDBMS, Data Engineering

    MySQL from a Kakao Interviewer Handling 1 Trillion++ Data PointsCourse Thumbnail

    MySQL from a Kakao Interviewer Handling 1 Trillion++ Data Points

    Hong

    PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data RecordsCourse Thumbnail

    PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

    Hong

    This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

    Beginner

    Beginner

    MySQL, PostgreSQL, Oracle

    PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data RecordsCourse Thumbnail

    PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

    Hong

    Yoonpago's Information Processing Engineer DB/Programming All-In-OneCourse Thumbnail

    Yoonpago's Information Processing Engineer DB/Programming All-In-One

    yoonpago93

    If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

    Beginner

    Beginner

    Engineer Information Processing, DBMS/RDBMS, C

    Yoonpago's Information Processing Engineer DB/Programming All-In-OneCourse Thumbnail

    Yoonpago's Information Processing Engineer DB/Programming All-In-One

    yoonpago93

    DBT with a Silicon Valley EngineerCourse Thumbnail

    DBT with a Silicon Valley Engineer

    altoformula

    Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level ๐Ÿš€

    Basic

    Basic

    SQL, Data Engineering, data-analysis

    DBT with a Silicon Valley EngineerCourse Thumbnail

    DBT with a Silicon Valley Engineer

    altoformula

    Large-Scale Systems Design Part 1Course Thumbnail

    Large-Scale Systems Design Part 1

    Jayce

    Learn common components of global-scale services through popular papers, books, and articles.

    Basic

    Basic

    software-design, DBMS/RDBMS

    Large-Scale Systems Design Part 1Course Thumbnail

    Large-Scale Systems Design Part 1

    Jayce

    CS Interview Preparation - Database Edition: Insights Directly from Channel Talk InterviewersCourse Thumbnail

    CS Interview Preparation - Database Edition: Insights Directly from Channel Talk Interviewers

    jayon0927

    Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up questions.

    Basic

    Basic

    DBMS/RDBMS, NoSQL, computer-science

    CS Interview Preparation - Database Edition: Insights Directly from Channel Talk InterviewersCourse Thumbnail

    CS Interview Preparation - Database Edition: Insights Directly from Channel Talk Interviewers

    jayon0927

    Making a Practical Unity Game with Database IntegrationCourse Thumbnail

    Making a Practical Unity Game with Database Integration

    JEngineer

    This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

    Basic

    Basic

    C#, Unity, Firebase

    Making a Practical Unity Game with Database IntegrationCourse Thumbnail

    Making a Practical Unity Game with Database Integration

    JEngineer

    SQL data analysis learned through various casesCourse Thumbnail

    SQL data analysis learned through various cases

    dooleyz3525

    By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

    Intermediate

    Intermediate

    SQL, PostgreSQL, DBMS/RDBMS

    SQL data analysis learned through various casesCourse Thumbnail

    SQL data analysis learned through various cases

    dooleyz3525