Advanced SQL Series: Proximal and Linear Interpolations Course

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

Download

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

Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.

about our training

Real-World Content

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

Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

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