[MMORPG Game Development Series with C# and Unity] Part 3: Unity Engine

hello,
This is Rookiss, currently writing a series on [MMORPG game development using C# and Unity].

Today [Part 5: Database] is open and shared.
Part 5 is about saving and loading data in MMO.
This course covers relational database management systems (RDBMS).
Basically, you learn MS-SQL by querying the baseball database.
This course will teach you SQL principles and tuning while analyzing a company database.

Looking back, when I first joined the company, the part I was most lazy about and hated was DB.
That's why I remember making a lot of little mistakes like this.
If you are preparing for a programmer interview, even if it is not necessarily a server part,
It would be good to be familiar with the principles of Index (Clustered, NonClustered) and Join (NL, Merge, Hash).
Anyway, the difficulty level is not that high compared to Parts 3 and 4.
You can think of it as a part where you can take a short break.

The next lecture was then decided to be Part 6: Web Server (ASP.NET Core).
As I mentioned in the last announcement, I had some concerns about the curriculum.
Surprisingly, there were many people interested in ASP.NET, so we decided to go with .NET without any changes.

There are many uses for web technology in MMOs,
First, you can think of an account server (login server) that processes your account when you first log in.
Also, most live operation tools (GM tools) will be implemented on the web.
For example, GM tasks such as searching logs and mailing items to specific users.
You can think of it as doing it on a web homepage.
If you think of it as an indie game, like a typical puzzle game, rather than an MMO,
Rankings and SNS friend lists will be implemented on the web.

Anyway, web servers are not very important or widely used in MMOs.
I tried to proceed lightly like Part 5, but
The plans changed with the official release of ASP.NET Blazor on May 22nd.
To summarize briefly, if you wanted to make a website responsive using web technology,
You should have used Javascript (or Typescript) on the frontend side.
But with the introduction of this new technology, we can now do everything in C# on both the client and server (!)
Since it is a new technology, it seems that proper documentation or professional books will not be available until June.
I think it's a technology that will be very welcomed in the gaming industry.
Even if we delay the release of the course a bit, we plan to focus on Blazor to some extent.

There is also additional content like this,
Also, these days, it's a time when all the parallel tasks are busy at the same time.
The next lecture is scheduled to open around the end of July.

Part 6: The contents to be covered in web server and ASP.NET Core will be roughly structured as follows.

- 1) Web basics (introduction to HTML, CSS, web principles, etc.)
- 2) Advanced C# grammar (learning grammar frequently used on the web, such as Nullable, LINQ, etc.)
- 3) ASP.NET Overview (ASP.NET 5-piece set: MVC, Razor Pages, WebAPI, Blazor Server, Blazor Client)
- 4) WebAPI and Blazor in-depth course and simple ranking project implementation

That's all.

- Until the day I release my MMO indie game -