← All presentations

The Lost Science of Set Theory

Download

Abstract

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory, and relational algebra and how they apply to database development to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

Presented at:

  • Greater Lansing SQL Server (GLASS) & SQL PASS in Detroit (SPID), Michigan (Detroit & Lansing) on Jun 16, 2020 (Virtual)
  • SQL Saturday #887, Salt Lake City, UT on Aug 2, 2019
  • The Church of Jesus Christ of Latter-day Saints, Riverton, UT on Jun 14, 2019
  • Utah County SQL Server Users Group, American Fork, UT on Feb 21, 2019
  • SQL Saturday #600, Chicago, IL on Mar 11, 2017
  • SQL Saturday #572, Portland, OR on Oct 22, 2016
  • SQL Saturday #557, Minneapolis, MN on Oct 1, 2016
  • SQL Saturday #531, Louisville, KY on Aug 6, 2016
  • SQL Saturday #527, Columbus, OH on Jul 16, 2016
  • SQL Saturday #521, Atlanta, GA on May 21, 2016
  • SQL Saturday #473, Cleveland, OH on Feb 6, 2016
  • SQL Saturday #436, Las Vegas, NV on Sep 12, 2015
  • SQL Saturday #349, Salt Lake City, UT on Oct 25, 2014
  • SQL Saturday #331, Denver, CO on Sep 20, 2014
  • IndyPASS, Indianapolis, IN on Sep 16, 2014
  • SQL Saturday #304, Indianapolis, IN on Aug 9, 2014
  • SQL Saturday #308, Houston, TX on May 10, 2014