3.4.1 Advanced Queries - Checklist of Activities

Learning Activities

Review the lesson lecture

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

Read the textbooks

• Microsoft SQL Server 2016 A Beginner's Guide Chapter 17 pages 459-476 34:00 minutes
• Microsoft SQL Server 2012 Step by Step Chapter 24 pages 303-312 18:00 minutes

Review the lesson videos

• Aggregate data 6:29 minutes
• Server health and extended events 7:10 minutes

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

Assessment Activities

• Complete the Lesson 4: Lab 120:00 minutes
• Complete the Lesson 4: Assignment 120:00 minutes
• Complete the Lesson 4: Quiz 40:00 minutes
• Complete the Lesson 4: Assessment 240:00 minutes