3.5.1 Extract, Transform & Load - Checklist of Activities
Learning Activities
Review the lesson lecture
-
Lesson 5: Write Data Integration Scripts Lecture Notes 45:00 minutes
Read the textbooks
Knight's Microsoft SQL Server 2012 Integration Services 24-hour Trainer 136:00 minutes
- Chapter 4-9 pages 25-62
- Chapter 12 pages 79-86
- Chapter 17-19 pages 113-150
- Chapter 41 pages 327-330
- Chapter 49 pages 387-391
Review the lesson videos
- SSIS Getting Started 24:16 minutes
- Expression and Other Constraints 8:33 minutes
- SSIS - Data Flow and Exec SQL Tasks 5:26 minutes
- SSIS Basic Tasks 18:12 minutes
- SSIS Data Types & Data Conversion 8:29 minutes
- SSIS Debugging 12:00 minutes
- Error handling 6:11 minutes
Assessment Activities
- Complete the Lesson 5: Lab 120:00 minutes
- Complete the Lesson 5: Assignment 120:00 minutes
- Complete the Lesson 5: Discussion Board 30:00 minutes