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