강의

멘토링

로드맵

BEST
Game Dev

/

Game Programming

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

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

(5.0) 125 reviews

3,844 learners

  • Rookiss
SQL
DBMS/RDBMS

Reviews from Early Learners

What you will learn!

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


Recommended for
these people

Who is this course right for?

  • People interested in MMORPG technology

  • People who don't understand DB

Hello
This is

77,508

Learners

3,493

Reviews

5,389

Answers

4.9

Rating

43

Courses

학력

- Condorcet Prépa MPSI 수료 (프랑스)
- 칭화대학교 소프트웨어공학 학사 (중국)
- 고려대학교 정보보호대학원 석사 (한국)

경력

- 前 크래프톤 (테라 서버팀)
- 前 엔씨소프트 (Blade&Soul2 컨텐츠 프로그래밍팀)

관심 분야

- 리버싱 및 취약점 분석
- MMORPG 게임 개발 (C++, C#)
- 외국어 (영어, 프랑스어, 중국어, 일본어)

소개

해킹 공부를 위해 순전히 호기심으로 시작한 게임 개발인데...
시간이 흘러 어느덧 10년차 게임 개발자가 되었습니다.
"이래서 언제 게임을 만들지~?"
한숨 나오는 기초 문법부터 시작해서,
차츰 만들어가는 나만의 게임 세상.
그리고 그 세상에 접속한 다수의 플레이어를 볼 때의 뿌듯함.
공부를 할 수록, MMORPG의 매력에는 헤어나올 수가 없습니다.
제가 느낀 감동을 여러분도 느낄 수 있으면 좋겠네요.

 

Curriculum

All

38 lectures ∙ (11hr 27min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

125 reviews

5.0

125 reviews

  • canghwan1788님의 프로필 이미지
    canghwan1788

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    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.

    • goo3book0144님의 프로필 이미지
      goo3book0144

      Reviews 5

      Average Rating 5.0

      5

      71% enrolled

      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

        Reviews 6

        Average Rating 5.0

        5

        100% enrolled

        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.

        • b2님의 프로필 이미지
          b2

          Reviews 14

          Average Rating 4.6

          5

          100% enrolled

          I enjoyed the lecture. Thank you.

          • 1122님의 프로필 이미지
            1122

            Reviews 10

            Average Rating 5.0

            5

            100% enrolled

            I gained general knowledge about DB haha thank you

            Limited time deal

            $26.40

            22%

            $34.10

            Rookiss's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!