This is a task for Project Based Internship by Rakamin x ID/X Partners.
Here's the summarized steps: [ Ссылка ]

00:00 Introduction
00:25 Problem Statement
00:41 Steps
1:34 Import/Restrore Source Database in SSMS
2:53 Create New Database in SSMS: Prep
04:12 Create New Database in SSMS: QUERYING
15:47 Troubleshooting Query Error
17:26 Fixing Query Mistake
20:47 Create ETL Job in Talend: Database Connection
20:47 Create ETL Job in Talend: Create Job
26:10 Transforming Data
29:12 Create ETL Job in Talend: Other Tables
31:42 Checking ETL Job Result
32:01 Create Stored Procedure in SSMS
37:16 Using Stored Procedure

свернуть