3.3.1 Advanced Queries - Checklist of Activities

Learning Activities

Review the lesson lecture

• Lesson 3: Write Advanced SQL Queries Lecture Notes 30:00 minutes

Read the textbooks

• Microsoft SQL Server 2016 A Beginner's Guide Chapter 19 pages 497-529 68:00 minutes
• Microsoft SQL Server 2012 Step by Step 58:00 minutes
  • Chapter 7 pages 95-104
  • Chapter 21 pages 271-282
  • Chapter 30 pages 387-396
• Introduction to Database Management Chapter 8 pages 275-280 10:00 minutes

Review the lesson videos

• Analyze execution plans and tune queries 4:27 minutes
• Improve queries with covering indexes 5:06 minutes
• Understanding extract, transform and load (ETL) 1:52 minutes

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

Assessment Activities

• Complete the Lesson 3: Lab 120:00 minutes
• Complete the Lesson 3: Assignment 90:00 minutes
• Complete the Lesson 3: Discussion Board 30:00 minutes