inflearn logo
inflearn logo

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

This course teaches MS-SQL through baseball/company databases.

(5.0) 수강평 132개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

SQL
SQL
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
DBMS/RDBMS
DBMS/RDBMS

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

5.0

5.0

Paul Kim

100% 수강 후 작성

I was in charge of the client for MMORPG, and this lecture made me fully understand why the server side had to harass me by saying 'No, no'. The examples were very appropriate, and the practical experience stories added here and there resolved my doubts about why the server manager was working overtime when he didn't seem to be doing anything. It was very helpful for starting a database for the first time. Thank you.

5.0

정세권

71% 수강 후 작성

I was looking for a cheaper course, so I looked at the curriculum, but it lacked information on indexes. So I skipped that course and chose this one... Wow~ It explains everything about DB from beginning to end in detail. The 'Index Analysis' part of the course is a rich content that is hard to find anywhere else. You can trace the data structure and see it with your own eyes at the end.. Awesome!! It even gives you a taste of Redis.. I'm just going to keep listening to this person's course series. I want to give it more than 5 stars. ^^

5.0

J Han

100% 수강 후 작성

Thank you. It was very helpful. I think you taught it in a way that was easier to understand than lectures 1, 2, 3, and 4.

강의상세_배울수있는것_타이틀

  • Database

  • SQL

All the skills needed to develop MMORPGs,
Step By Step with C# + Unity! 🕹️

Developing an MMORPG from Basic to Ultimate 🎮

This game development course is designed to be easy and step-by-step, assuming no prior knowledge. The ultimate goal is to launch an indie MMORPG game that can accommodate 500 to 1,000 users.

In this series, you'll learn the necessary skills to create a 2D roguelike game using C# and Unity, using free assets provided by Unity. Let's tackle it together!


You can make something like this ✨

▲ Implement essential RPG game features with simple assets.
(Sample portfolio clip: This is an actual portfolio that passed the document screening for new employee recruitment at Company N in 2015.)

▲ You will learn the core server linking technology needed to create online multiplayer games.


What you'll learn 📚

  • Part 1: Introduction to C# Programming
  • Part 2: Data Structures and Algorithms
  • Part 3: Unity Engine
  • Part 4: Game Server (Network, Multithreading, OS)
  • Part 5: Database (SQL Server) Current Lecture
  • Part6: Web server (ASP.NET Core Blazor, WebApi)
  • Part 7: MMORPG Content Implementation (Unity + C# Server Integration)
  • Part8: Entity Framework Core (.NET ORM)
  • Part 9: MMORPG Content Implementation (DB Integration + Large Structure Management + Live Preparation)
  • Bonus: Starting Server Operations with AWS
  • Bonus: ASP.NET Core Advanced
A database course that focuses on the fundamentals
In Part 5, we'll cover the fundamentals of databases essential for developing MMORPGs. It wouldn't be a proper MMORPG if every server down caused the level of the characters players had cherished and nurtured to reset. We'll distill the essential RDBMS knowledge developers need to master, using baseball and corporate data to provide an easy and accessible learning experience.
Learn in the following order!

Introduction to Database 👉 SQL Basics 👉 SQL Tuning 👉 Appendix

Part 5, recommended for these people!

About DB
People who don't understand

RDBMS (relational DB)
Those who want to learn

Required for MMORPG
Those who want to learn DB knowledge


Q&A 🙋‍♀️

Q. What is the lecture environment like?
A. All series are produced assuming a Windows environment, and there is no additional explanation for macOS.

Q. Can non-majors also take the course?
A. There is no problem in proceeding assuming that there is no player knowledge at all.

Q. Please tell us what prompted you to start this course.
A. Personally, I remember having a hard time when I first started studying servers because there was no reference material.
After getting a job, I compared the code of a live MMORPG with my own, and realized many flaws in my own code, which I had created through headlining. I thought it would have been a good idea to have a course that covered MMORPG development from the basics up to the end, as it would have saved me time and effort.
I hope this class will serve as a guide for you as you get started with MMORPG games.

Q. You don't use C++ or Unreal Engine?
A. We plan to produce it in two versions: [C#/Unity version for indie games (this series)] and [C++/UE4 version for employment].
MMORPGs require extensive coverage, including networking, operating systems, multithreading, web development, client engines, and more. Developing with C++ can be challenging, making it unsuitable for beginners. If you lack game development experience, we recommend first exploring the C# version.

Q. If I purchase one part, will the other part be free?
A. Each part is manufactured independently and sold separately.


강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • People interested in MMORPG technology

  • People who don't understand DB

강의소개.지공자소개

81,857

수강생

3,916

수강평

5,463

답변

4.9

강의 평점

49

강의_other

Education

- Completed Condorcet Prépa MPSI (France)
- Bachelor of Software Engineering, Tsinghua University (China)
- Master of Information Security, Korea University Graduate School (Korea)

Experience

- Former Krafton (TERA Server Team)
- Former NCSOFT (Blade & Soul 2 Content Programming Team)

Areas of Interest

- Reversing and Vulnerability Analysis
- MMORPG Game Development (C++, C#)
- Foreign Languages (English, French, Chinese, Japanese)

Introduction

I started game development purely out of curiosity to study hacking...
but as time passed, I somehow became a game developer in my 10th year.
"When will I ever be able to make a game at this rate?"
Starting from basic grammar that makes you sigh,
to gradually building my own game world.
And the sense of pride when seeing many players connect to that world.
The more I study, the more I can't escape the charm of MMORPGs.
I hope you can feel the same inspiration that I felt.

The sense of pride when seeing a large number of players. The more I study it, the more I find myself unable to escape the charm of MMORPGs. I hope you can feel the same inspiration that I felt.

더보기

커리큘럼

전체

38개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

132개

5.0

132개의 수강평

  • b2님의 프로필 이미지
    b2

    수강평 14

    평균 평점 4.6

    5

    100% 수강 후 작성

    I enjoyed the lecture. Thank you.

    • canghwan1788님의 프로필 이미지
      canghwan1788

      수강평 1

      평균 평점 5.0

      5

      100% 수강 후 작성

      I was in charge of the client for MMORPG, and this lecture made me fully understand why the server side had to harass me by saying 'No, no'. The examples were very appropriate, and the practical experience stories added here and there resolved my doubts about why the server manager was working overtime when he didn't seem to be doing anything. It was very helpful for starting a database for the first time. Thank you.

      • 1122님의 프로필 이미지
        1122

        수강평 10

        평균 평점 5.0

        5

        100% 수강 후 작성

        I gained general knowledge about DB haha thank you

        • goo3book0144님의 프로필 이미지
          goo3book0144

          수강평 5

          평균 평점 5.0

          5

          71% 수강 후 작성

          I was looking for a cheaper course, so I looked at the curriculum, but it lacked information on indexes. So I skipped that course and chose this one... Wow~ It explains everything about DB from beginning to end in detail. The 'Index Analysis' part of the course is a rich content that is hard to find anywhere else. You can trace the data structure and see it with your own eyes at the end.. Awesome!! It even gives you a taste of Redis.. I'm just going to keep listening to this person's course series. I want to give it more than 5 stars. ^^

          • jinheehan님의 프로필 이미지
            jinheehan

            수강평 6

            평균 평점 5.0

            5

            100% 수강 후 작성

            Thank you. It was very helpful. I think you taught it in a way that was easier to understand than lectures 1, 2, 3, and 4.

            Rookiss님의 다른 강의

            지식공유자님의 다른 강의를 만나보세요!

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            강의상세.할인문구

            $24.20

            29%

            $34.10