Autoplay
Autocomplete
Previous Lesson
Complete and Continue
BB MSBI-SSIS May 2023
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
Teach online with
27 SSIS - Deployment DBA Tasks
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock