Session

How to Change SQL from Procedural to Set-Based

Most relational databases (like SQL Server, Postgres, etc.) are designed around processing data in sets. This is evident with the declarative nature of Structured Query Language(SQL). Yet, many developers need help transitioning from the procedural programming methodologies they learned in school or while working in procedural languages. Therefore, how can we turn database stored procedures and functions that were written procedurally into more efficient set-based processing? This session will review those issues and help identify helpful tips while working through a real-life example in Postgres.

Aaron Cutshall, DHA, MSHI

Honest Health, Director, Data Services

Cedar City, Utah, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top