This demonstrates (using the Music Database) the execution plan and SQL Profiler to help you determine performance bottlenecks in a database and perform optimization.
Use the Music Database
Should be relatively proficient with SQL and queries
http://online1.daytonastate.edu/player2.php?id=6dfe08eda761bd321f8a9b239f6f4ec3
Support for this lecture is at Case Study - Music Database
All Materials Copyright 2012 Dr. Ron Eaglin