Curriculum
- 16 Sections
- 101 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- Introduction to SQL Server Integration Services4
- Introduction to Data Flow5
- Data Sources4
- Data Flow Transformations15
- 4.1· Aggregate Transformation
- 4.2· Audit Transformation
- 4.3· Character Map Transformation
- 4.4· Conditional Split Transformation
- 4.5· Copy Column Transformation
- 4.6· Derived Column Transformation
- 4.7· Data Conversion Transformation
- 4.8· Multicast Transformation
- 4.9· OLE DB Command Transformation
- 4.10· Percentage Sampling Transformation
- 4.11· Sort Transformation
- 4.12· Union All Transformation
- 4.13· Audit Transformation
- 4.14· Character Map Transformation
- 4.15· Copy Column Transformation
- Advanced Data Flow12
- 5.1· Lookup Transformation
- 5.2· Merge Transformation
- 5.3· Merge Join Transformation
- 5.4· Slowly Changing Dimension Transformation
- 5.5· Pivot Transformation
- 5.6· Export Transformation
- 5.7· Import Transformation
- 5.8· Unpivot Transformation
- 5.9· Term Extraction Transformation
- 5.10· Term Lookup Transformation
- 5.11· Fuzzy Lookup Transformation
- 5.12· Fuzzy Grouping Transformation
- Data Flow Destinations4
- Introduction to Control Flow14
- 7.1· Control Flow Overview
- 7.2· Precedence Constraints
- 7.3· The Execute SQL Task
- 7.4· The Bulk Insert Task
- 7.5· The File System Task
- 7.6· The FTP Task
- 7.7· The Send Mail Task
- 7.8· Bulk Insert Task
- 7.9· Data Flow Task
- 7.10· Execute Package Task
- 7.11· Execute Process Task
- 7.12· Web Service Task
- 7.13· Backup database Task
- 7.14· Analysis Services Processing Task
- Advanced Control Flow3
- Variables and Configurations9
- Error Handling and Logging3
- SSIS Package Deployment2
- SSIS Package Management3
- SSAS 100 % Practical Classes0
- What Is Microsoft Business Intelligence?8
- Intermediate SSAS7
- SSRS : Creating basic reports8