3.9.1 Automate Data Movement - Checklist of Activities
Lesson 9: Write SQL Automation Tasks - Checklist of Activities [5 minutes]
Learning Activities
Review the lesson lecture
-
Lesson 9: Automate Data Movement Lecture Notes 60:00 minutes
Read the textbooks
Microsoft SQL Server 2012 Step by Step Chapter 27 pages 345-364 38:00 minutes
Knight's Microsoft SQL Server 2012 Integration Services 24-hour Trainer 134:00 minutes
- Chapter 44-48 pages 347-386
- Chapter 50-53 pages 393-414
- Chapter 59 pages 443-450
Review the lesson videos
- Create SQL Agent Job - Stored Procedure 7:09 minutes
- Script Tasks using Visual Basic 15:43 minutes
- Event-handling and logging 16:57 minutes
Review websites as referred to in lesson content 15:00 minutes
Assessment Activities
- Complete the Lesson 9: Lab 120:00 minutes
- Complete the Lesson 9: Assignment 120:00 minutes
- Complete the Lesson 9: Assessment 240:00 minutes