Advanced SQL: Solving Interpolation Challenges
1h 22mAdvanced2021-10-12
Authors

Ami Levin
Data Educator, Speaker, and Practitioner, SQL and RDM enthusiast
Course details
Interpolation challenges are quite common, especially for time series and sequence analyses. In this course, data educator Ami Levin offers several techniques to solve these types of challenges seamlessly and efficiently. Ami explains what interpolation is and shows you how interpolation challenges and solutions work, using the database for Formula 1 race car telemetry. He goes over streamlining your solution with auxiliary data and explores the solution methodology for SQL challenges in general. Ami dives into definitions and challenges for proximal interpolations and linear interpolations, then concludes with a review of what you’ve learned.
Note: This course was created by Ami Levin. We are pleased to host this training in our library.
Note: This course was created by Ami Levin. We are pleased to host this training in our library.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Course introduction
- 02 - Agenda
- 03 - Setting expectations
1. What Is Interpolation
- 04 - Curve fitting
- 05 - Interpolations
- 06 - The Formula 1 demo database
2. Methodology
- 07 - Auxiliary data
- 08 - Solution methodology
3. Proximal Interpolations
- 09 - Definition
- 10 - Proximal interpolation
- 11 - Challenge - Multiple sensors
- 12 - Solution - Multiple sensors
4. Linear Interpolations
- 13 - Definition
- 14 - Linear interpolation
- 15 - Challenge - Linear interpolation
- 16 - Solution - Linear interpolation
Conclusion
- 17 - Course review and conclusion
Related courses
- Advanced SQL Practice: INSERT Operations
- Solve Real-World Data Problems with SQL
- Advanced SQL for Query Tuning and Performance Optimization (2019)
- Advanced SQL for Data Science: Time Series
- Advanced SQL for Query Tuning and Performance Optimization
- Advanced SQL Project: Design and Manage a Database
- Advanced SQL Practice: Schema Changes
- Advanced SQL Practice: UPDATE Database Records