Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Advanced SQL Series: Proximal and Linear Interpolations

Course Summary

The Advanced SQL Series: Proximal and Linear Interpolations training course is designed to demonstrate how to systematically approach solving tough challenges in SQL.

The course begins with a look at Curve Fittings and Interpolations, and why they are necessary. Next, it examines how to approach tough SQL challenges using auxiliary data tables. The course concludes by exploring Proximal Interpolations and Linear Interpolations.

Purpose
 Empower students with the knowledge and skills for how to systematically approach solving tough challenges in SQL.
Audience
 Experienced SQL developers who want to take their skills to a new level. Data analysts and data scientists who are often stumped with challenges that seem too hard to solve in SQL.
Role
Business Analyst - Data Engineer - Data Scientist - Software Developer - Web Developer
Skill Level
Advanced
Style
Workshops
Duration
2 Days
Related Technologies
SQL

 

Productivity Objectives
  • Describe how query processing works for Windowed Functions
  • Explain linear interpolations, how and when to use them
  • Solve Linear interpolation and similar challenges using SQL
  • Approach other challenging SQL tasks with a proven, easy methodology
  • Improve performance, readability, and scalability of your SQL queries

What You'll Learn:

In the Advanced SQL Series: Proximal and Linear Interpolations training course, you'll learn:
  • Course introduction
    • Speaker and course introduction
    • Agenda
    • Administrative
  • Challenge description and background
    • What are Curve Fittings and Interpolations, and why we should use them
    • The various types of interpolations
    • The schema and data we will use for this training
    • The interpolations schema and data exercises
  • Solution Methodology
    • Approaching tough SQL challenges
    • Using auxiliary data tables
    • Writing down expected result sets
    • Constructing our initial row set
    • Figuring out the missing data columns
    • Using views and WITH clauses to simplify solutions
    • Preparing to solve the proximal interpolation challenge
  • Proximal Interpolations
    • Solution walkthrough
      • Using window functions efficiently
      • Finding the last or next non-null value
      • Realizing our grouping expressions
      • Putting it all together
      • Testing and performance considerations
  • Linear Interpolations
    • Challenge description
    • Prepare to solve the linear interpolation challenge
    • Solution walkthrough
      • Understanding an alternative approach for finding the last or next non-null value
      • Realizing our grouping expressions
      • Generating counts and sequence positions
      • Putting it all together
      • Testing and performance considerations
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.