3.1.1 Advanced Queries - Checklist of Activities

Learning Activities

Review the lesson lecture

• Lesson 1: Advanced Queries 45:00 minutes

Read the textbooks

• Knight's Microsoft SQL Server 2012 Integration Services 24-hour Trainer Chapter 1-3 pages 9-24 30:00 minutes
• Microsoft SQL Server 2016 A Beginner's Guide Chapter 9 pages 257-268 22:00 minutes
• Microsoft SQL Server 2012 Step by Step Chapter 30 pages 387-398 48:00 minutes

Review the lesson videos

• Excel 2016: Cleaning Up Your Data 2:26:00 minutes
• Pain Points - Student Perspective 5:17 minutes

Review websites as referred to in lesson content [15:00 minutes]

Assessment Activities

• Complete the Lesson 1: Lab 120:00 minutes
• Complete the Lesson 1: Assignment 60:00 minutes
• Complete the Lesson 1: Discussion Board 30:00 minutes