3.2.1 Advanced Queries - Checklist of Activities

Learning Activities

Review the lesson lecture

• Lesson 2: Write Advanced SQL Queries Lecture Notes 60:00 minutes

Read the textbooks

• Microsoft SQL Server 2016 A Beginner's Guide Chapter 15 pages 399-419 40:00 minutes
• Microsoft SQL Server 2012 Step by Step Chapter 8 pages 105-115 20:00 minutes

Review the lesson videos

• Partition large data tables 9:03 minutes

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

Assessment Activities

• Complete the Lesson 2: Lab 120:00 minutes
• Complete the Lesson 2: Assignment 180:00 minutes