
Database MSSQL
vmproductor0202
This is a class on MSSQL, one of the three major databases. Even if you are learning databases for the first time, you can learn it easily.
Beginner
DBMS/RDBMS, MSSQL, dba
In this lecture, you will learn how to create an ERD. You will learn database design. (The only big data design lecture in Korea)
63 learners
Level Basic
Course period Unlimited

Database design
ERD
Table design for big data
Database
DataBase Design
Learn ERD through database design!
Study with a focus on practical knowledge 🤓
What happens if you use a program or website without a database? Any data that needs to be shared within that program or website will be reset when the server restarts. To prevent this, you need to store data to be managed or stored, as well as data to be shared between systems, in a database.
💡 Why is database design necessary?
If you studied system design in the previous lecture, " 1. Management Course [Design] (UML+ClassDiagram) ," this lecture will cover practical aspects of data storage and management, including how to use the program . This lecture covers database design theory and practice, using MSSQL. Through this lecture, you'll learn how to understand and create ERDs and explore the relationships between tables!
We'll also help you understand and create practical terminology and tables. Table design methodology , a fundamental tool for big data, is widely used globally, but it's not widely known among Koreans, so we've created this course to share it with you. We hope you'll also gain knowledge of DBA terminology used overseas.
How to design a database
The worried deputy manager~manager
Databases in Practice
For those curious about the design process
Thinking about how to process big data
Architecture, Consultants
Selected from Korean practice
Database design methodology
When designing a practical database
Terms and techniques you can use
Foreign design methodologies and
Improved data retrieval performance
In practice
Understanding table structure
For big data
Table design work method
Through practice
Make the knowledge yours!
Q. Is the lecture difficult?
You can learn sufficiently by following the practical method and also explaining the necessary theory.
Q. I don't know much about databases, but can I still take the course?
This course assumes a basic understanding of databases. Therefore, it will not be helpful without at least one year of practical experience as a backend developer or the equivalent of a fourth-year undergraduate degree. To supplement this, prior knowledge of the databases listed below is required.
Who is this course right for?
Agent~Manager
consultant
Architecture
DBA
23,379
Learners
847
Reviews
288
Answers
4.4
Rating
24
Courses
I am a technology leader among IT professionals in Korea.
The only lecture in Korea:
eGovFrame, LAYERED Architecture
,WPF_MVVM pattern. OLAP, SSIS, SSAS, etc.
The only lecture in the world:
Springframework + Enterprise Architecture[EA],
Query refactoring, SignalR + JWT
MAUI + MVVM + AZURE, etc.
If you have any questions during the lecture,
Questions and answers regarding this lecture, or
Please leave a message at vmproductor@gmail.com.
I also offer consultations for non-lecture related matters, general inquiries, and career counseling.
Experience-
Bachelor's degree in Computer Science. Certified Engineer Information Processing.
ExtremeNetworks (Korea), former intern at the world's 2nd largest network company
Web, Android, AI development and maintenance (former)
ERP Web Development (Former)
Database, Server Administrator (Former)
MES, FA (Former)
E-Commerce Web Development (Former)
Remote control and monitoring of national facilities (current)
Web, Android, AI development and maintenance (Former) ERP web development (Former) Database, Server Administrator (Former) MES, FA (Former) E-Commerce web development (Former) Remote control and monitoring of national facilities (Current)
Part-
Designer, Web, Android, Remote Automation Systems, Translation Programs, Server, Network, White Hat Hacker, Angular
Project Manager, DBA (MSSQL, ORACLE, MYSQL), DE, OS programming, Application Software, Astrophysics
I specialize in these and other related fields.
All
9 lectures ∙ (1hr 26min)
Course Materials:
2. Preview
00:20
4. 2. Design theory.
02:19
All
10 reviews
3.8
10 reviews
Reviews 1
∙
Average Rating 4.0
Reviews 1
∙
Average Rating 5.0
Reviews 4
∙
Average Rating 5.0
Reviews 6
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 5.0
$26.40
Check out other courses by the instructor!
Explore other courses in the same field!