⇽ Bruce Momjian ⇽

Postgres SQL Language Presentations


Data Processing Inside PostgreSQL

This talk is best for those who are are familiar with databases and SQL, but want to learn how to move processing from their applications into the database to improve consistency, administration, and performance.  Topics covered  include advanced SQL features like referential integrity constraints, ANSI joins, views, rules, and triggers.  The presentation also explains how to create server-side functions, operators, and custom data types in PostgreSQL.
Duration: 3 hours, 4 hours with questions

Programming the SQL Way with Common Table Expressions

SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages. This talk will help developers use CTE queries in their applications and allow operations that normally could only be done in application code to be done via SQL queries.
Duration: 30 minutes, 45 minutes with questions

Postgres Window Magic

Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.
Duration: 60 minutes, 75 minutes with questions

Nulls Make Things Easier?

Nulls are a very useful but also very error-prone relational database feature. This talk is designed to help applications developers better manage their use of nulls. It covers the use of nulls in relational databases, with a focus on Postgres behavior. It covers three-value logic, comparing nulls, mapping nulls to strings, indexing nulls, and aggregates.
Duration: 30 minutes, 45 minutes with questions