MSBI-SSIS
-
01 SSIS Demo Part1 - May 11th, 2023 (46:03)
-
02 SSIS Demo Part2 - May 12th, 2023 (55:20)
-
03 SSIS - Installation (36:07)
-
04 SSIS - Control Flow Vs Data Flow (49:40)
-
05 SSIS - Control Flow Tasks (43:06)
-
06 SSIS - Demos on Exe SQL and Bulk Insert Task (45:02)
-
07 SSIS - Demos on FTP, Exec Process and Package, Zip, UnZip (30:18)
-
08 SSIS - Blocked vs Non Blocked Transformations (41:43)
-
09 SSIS - Audit, Conditional Split, Derived Col, Data Conversion and Multicast (26:06)
-
10 SSIS - Demos on Conditional Split, Derived Col, Multicast and Data Conv (46:26)
-
11 SSIS - Lookup (42:59)
-
12 SSIS - Partial Cache and Error Handling (45:00)
-
13 SSIS - Logging and Event Handlers (47:27)
-
14 SSIS - Fuzzy Lookup and Grouping , Row Count, OLEDB Command (50:35)
-
15 SSIS - Merge, Union All, Merge Join, Script Component (26:09)
-
16 SSIS - Incr Loading with LookUp (43:36)
-
17 SSIS - Incr Loading with LookUp Part2 (27:31)
-
18 SSIS - Incr Loading using SCD and Type 2 with Lookup (70:37)
-
20 SSIS - Incr Loading with CDC (63:19)
-
19 SSIS - Incr Loading using SQL Merge (37:10)
-
21 SSIS - Demo on Variable (34:37)
-
22 SSIS - Variables and Create Time Stamp Folder (54:57)
-
23 SSIS - Demo on File Existence Check (64:55)
-
24 SSIS - Containers (64:24)
-
25 SSIS - Debugging SSIS Packages (42:52)
-
26 SSIS - Deployment Dev Tasks (65:49)
-
27 SSIS - Deployment DBA Tasks (78:14)
-
28 SSIS - Check Point, Transactions, Security, Performance Improvement (35:50)
-
29 SSIS - Interview Preparation (23:47)
Data WareHouse
-
01 DWH - Intro (49:52)
-
02 DWH - Top Down vs Bottm Up Approach (44:53)
-
03 DWH - ODS Vs DWH (43:28)
-
04 DWH - Convert OLTP Data to OLAP Data (43:15)
-
05 DWH - Intro to Dim Modeling (56:13)
-
06 DWH - Designing Stage and DWH (49:54)
-
07 DWH - Normalization Vs De-Normalization and Designing DWH (57:03)
-
08 DWH - Schemas (52:28)
-
09 DWH - Load Data to DWH using SSIS (72:37)
-
10 DWH - Dims and Facts (17:18)
-
11 DWH - Types of Dimensions (61:25)
-
12 DWH - Types of Dimensions SCD and Inferred Dim (54:04)
-
13 DWH - Types of Facts (51:03)
-
ODS
-
Incr Loading Vs Full Loading
-
Amazon Project Scripts
