inflearn logo

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

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

(4.9) 133 reviews

3,933 learners

Level Basic

Course period Unlimited

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

Reviews from Early Learners

Reviews from Early Learners

4.9

5.0

Paul Kim

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.

5.0

정세권

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

5.0

J Han

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.

What you will gain after the course

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

82,374

Learners

3,952

Reviews

5,470

Answers

4.9

Rating

50

Courses

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.

More

Curriculum

All

38 lectures ∙ (11hr 27min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

133 reviews

4.9

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

    • 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

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

            Rookiss's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            $34.10