Skip to content

Contact sales

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

Advanced SQL Series: Relational Division

Course Summary

The Advanced SQL Series: Relational Division training course is designed to demonstrate how to systematically approach solving tough challenges in SQL.

The course begins with a look at Codd's table operations and the relational division operator. Next, it examines how to solve relational division using aggregations, set operators and nested NOT EXISTS. The course concludes with some advanced relational divisions.

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 Relational Division challenges
  • Explain how to systematically approach solving tough challenges in SQL
  • Discover the pros and cons of the various relational division solutions
  • Solve relational division and similar challenges using SQL
  • Approach other challenging SQL tasks with a proven methodology
  • Improve performance, readability, and scalability of your SQL queries

What You'll Learn:

In the Advanced SQL Series: Relational Division training course, you'll learn:
  • Course introduction
    • Speaker and course introduction
    • Agenda
    • Administrative
  • Description and background
    • Codd's table operations
      • Set operators and relationship operators
    • The relational division operator
      • Division with and without remainders
    • Introduction to the example and exercise database
    • Hands on exercise - downloading and installing the exercise database
  • Solving relational division using aggregations
    • Demo challenge and solution - using COUNT
    • Hands on exercise - using COUNT
  • Solving relational division using set operators
    • Demo challenge and solution - using set operators
    • Hands on exercise - using set operators
  • Solving relational division with nested NOT EXISTS
    • Demo challenge and solution
    • Hands on exercise - using NOT EXISTS
  • Advanced relational divisions
    • Division with multiple divisors
    • Fitment evaluation
    • Ordered division
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.