Advanced SQL: Solving Interpolation Challenges

Advanced SQL: Solving Interpolation Challenges

1h 22mAdvanced2021-10-12

Authors

Ami Levin

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.

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
40,000 Toman