Advanced SQL: Solving Interpolation Challenges

Learn about the mathematical foundations of interpolation, some common challenges that involve interpolations, and several elegant ways to solve them.

Introduction

• Course introduction
• Agenda
• Setting expectations

1. What Is Interpolation?

• Curve fitting
• Interpolations
• The Formula 1 demo database

2. Methodology

• Auxiliary data
• Solution methodology

3. Proximal Interpolations

• Definition
• Proximal interpolation
• Challenge: Multiple sensors
• Solution: Multiple sensors

4. Linear Interpolations

• Definition
• Linear interpolation
• Challenge: Linear interpolation
• Solution: Linear interpolation

Conclusion

• Course review and conclusion