1. Looking through the Window 2. Discovering Ranking Functions 3. Summarizing with Window Aggregates 4. Calculating Running and Moving Aggregates 5. Adding Frames to the Window 6. Taking a Peek at Another Row 7. Understanding Statistical Functions 8. Tuning for Better Performance 9. Hitting a Home Run with Gaps, Islands, and Streaks 10. Time Range Calculations 11. Time Trend Calculations