From the course: Advanced SQL: Solving Interpolation Challenges
Join today to access over 24,900 courses taught by industry experts.
Linear interpolation - SQL Tutorial
From the course: Advanced SQL: Solving Interpolation Challenges
Linear interpolation
- [Instructor] You may be asking yourself, so, what's the big difference between solving proximal and linear interpolation in SQL? We can use the same method that we used in the previous chapter all the way up until the final query. And there, instead of the case statement, which interpolated the closest neighbor's value, we'll just evaluate the linear formula. We have all the data that we need. We have the previous and next known temperatures and their times, so what's the big deal? And if that's what you asked yourself, then pat yourself on the back, because you're absolutely right. We can use the exact same query techniques with minimal changes. However, doing so will be neither educational nor interesting. So this time, we're going to learn a different technique. What do you think, should we go for it? Don't answer, it's a rhetorical question. There's no need to go back all the way to the data preparation phase.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.