인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
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.

(4.9) 114 reviews

3,640 students

SQL
DBMS/RDBMS
Thumbnail

This course is prepared for Basic 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 is a game development course designed so that anyone can take it step by step without any burden, assuming no prior knowledge. The ultimate goal is to release an MMORPG indie game that can accommodate 500 to 1,000 users.

In this series, we'll learn the necessary skills to create a 2D roguelike game using C# and Unity, using free assets provided by Unity, step by step. Let's take on the challenge together!


You can make something like this ✨

▲ Implement essential features of RPG games with simple assets.
(Sample portfolio clip: This is an actual portfolio that passed the document screening for new recruits 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
  • Part3: Unity Engine
  • Part 4: Game Server (Network, Multi-Thread, OS)
  • Part 5: Database (SQL Server) Current Lecture
  • Part6: Web server (ASP.NET Core Blazor, WebApi)
  • Part7: MMORPG content implementation (Unity + C# server linkage)
  • Part8: Entity Framework Core (.NET ORM)
  • Part 9: MMORPG content implementation (DB linkage + large structure management + live preparation)
  • Bonus: Server Operations Starting with AWS
  • Bonus: ASP.NET Core Advanced
<Database> lecture faithful to the basics
In Part 5, you will learn the basics of databases that you must know to create an MMORPG. If the level of the characters that players have raised with great care is reset every time the server goes down, it cannot be considered a normal MMORPG. You will learn the RDBMS knowledge that developers need to know easily and familiarly through baseball/company data.
Please 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?
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 actual live MMORPG code and realized many of the errors in my code that I had created through headings. I thought that if there had been a class that briefly covered the entire content of MMORPG development from the basics to the end, I would have saved time and suffered less.
I hope this class will serve as a guide for you to get started with MMORPG games.

Q. You don't use C++ or Unreal Engine?
A. We plan to produce it separately as [a version using C#/Unity for indie games (this series)] and [a version using C++/UE4 for employment].
MMORPGs have a lot to deal with, such as networks, OS, multi-threads, web, client engines, etc. If you proceed based on C++, the difficulty level is high, so it is not suitable for beginners. In particular, if you do not have knowledge of game development, I recommend that you first look through the entire forest with the C# version.

Q. If I buy one part, do I get the other part for 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

71,130

Students

2,918

Reviews

5,245

Answers

4.9

Rating

37

Courses

학력

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

경력

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

관심 분야

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

소개

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

 

Curriculum

All

38 lectures ∙ (11hr 27min)

Lecture resources

are provided.

Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!