Month 27: Working with SQL Server Integration Services (SSIS)
Week 1: Introduction to SQL Server Integration Services (SSIS)
- Day 1: Understanding SQL Server Integration Services
- Day 2: Setting Up SQL Server Integration Services
- Day 3: Components of SSIS: Control Flow and Data Flow
- Day 4: Basic SSIS Tasks and Transformations
- Day 5: Running and Debugging SSIS Packages
Week 2: Advanced SSIS Tasks and Transformations
- Day 1: Conditional Split and Multicast Transformations
- Day 2: Lookup, Merge, and Merge Join Transformations
- Day 3: Data Conversion and Derived Column Transformations
- Day 4: Sorting and Aggregating Data in SSIS
- Day 5: Error Handling in SSIS
Week 3: SSIS Package Deployment and Management
- Day 1: Deploying SSIS Packages
- Day 2: Scheduling SSIS Packages with SQL Server Agent
- Day 3: SSIS Package Configuration
- Day 4: Securing SSIS Packages
- Day 5: Monitoring and Optimizing SSIS Packages
Week 4: ETL with SSIS
- Day 1: Understanding ETL (Extract, Transform, Load)
- Day 2: Using SSIS for Data Extraction
- Day 3: Using SSIS for Data Transformation
- Day 4: Using SSIS for Data Loading
- Day 5: Best Practices for ETL with SSIS
dowhatkennydoes.com 