This course teaches MS-SQL through baseball/company databases.
What you will learn!
Database
SQL
All the skills needed to develop MMORPGs,
Step By Step with C# + Unity! 🕹️
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!
▲ 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.
Introduction to Database 👉 SQL Basics 👉 SQL Tuning 👉 Appendix
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. 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.
Who is this course right for?
People interested in MMORPG technology
People who don't understand DB
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의 매력에는 헤어나올 수가 없습니다.
제가 느낀 감동을 여러분도 느낄 수 있으면 좋겠네요.
All
38 lectures ∙ (11hr 27min)
are provided.
OT
04:49
Preferences
06:55
Introduction to SSMS
20:59
SELECT FROM WHERE
20:52
ORDER BY
10:20
Numbers and strings
15:18
DATETIME
22:03
CASE
09:09
Aggregate function
14:34
Practice Problems
11:16
GROUP BY
20:44
INSERT DELETE UPDATE
15:47
SUBQUERY
24:22
Create a database
26:00
Normalization
10:07
INDEX
21:45
UNION
12:32
JOIN
19:40
TRANSACTION
19:15
Windows Function
19:34
Index Analysis
18:59
Composite index
25:56
Bookmark Lookup
28:44
Index column order
29:09
Nested Loop Join
25:22
Merge Join
34:41
Hash join
26:13
Sorting
17:05