
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
SSIS, SSAS, MachineLearning, BI, ETL. You can learn important technologies that cannot be found in domestic books, YouTube, lectures, blogs, and academies. I also recommend it to those who are interested in employment at domestic large companies, American large companies, and American state funding agencies.
34 learners
Level Basic
Course period Unlimited

SSIS
SSAS
MSSQL
BI
ETL
DataMining
Data Analysis with SSIS and SSAS 🤓
Learn credible skills abroad!
If you're interested in pursuing a career as a DBA, data engineer, architect, or consultant, take note! This course teaches you how to process and retrieve data from SSIS and SSAS in Visual Studio. You'll learn the fundamentals of data integration, prediction, and analysis, as well as the most trusted technologies from around the world. Get hands-on experience with Microsoft's leading data analysis, prediction, and integration.
The picture below shows just a few things we learned in class.
Data integration (collection)
Data synchronization
prediction
When analyzing data, you won't learn how to use functions like SUM and AVG. Instead, you'll learn SSAS skills and how to use it to obtain analytical data.
When integrating data, don't simply use C# or the web. You won't learn methods that can't be applied in practice.
You'll learn data collection and processing methods that aren't well-known domestically but are renowned internationally. You spent tens of millions or even hundreds of millions of won at university on bachelor's and doctoral programs in data analysis, but did you only learn math? This course doesn't teach math. You'll learn how to analyze and integrate data.
This course requires prior knowledge. Please take the following courses before taking this course.
Who is this course right for?
DE(Data Engineer)
DA(Data Analyst)
Data Engineer
Data Analyst
DBA
Architecture
Consultant
Those who want to work abroad or increase their value
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
14 lectures ∙ (3hr 40min)
Course Materials:
2. Preview
01:14
5. 2. Theory lecture
06:10
6. 3.SSIS Basics
26:49
7. 4.SSIS Basics_2
18:16
8. 5.SSIS Basics_3
21:26
9. 6.CDC
13:23
11. 8.SSAS
30:46
All
3 reviews
5.0
3 reviews
Reviews 40
∙
Average Rating 4.9
Reviews 3
∙
Average Rating 4.7
Reviews 2
∙
Average Rating 5.0
$42.90
Check out other courses by the instructor!
Explore other courses in the same field!