Andrew Hooker

Camp Counselor

SELECT MAX(value) FROM database.advanced_features;

Event Logo

Thursday, July 29, 2021 - 3:30 PM UTC, for 1 hour.

Regular, 60 minute presentation

Room: A & H

Database
SQL
Reporting

Join me for a tour of the most powerful features of PostgreSQL, MySQL, MS SQL Server, and other database engines that you might not have used. We'll touch on the following: * Views and Materialized Views * Window Functions * Advanced Indexes * Stored Procedures and much much more... As I cover each feature, I'll also give you examples of why you'd use it, and the alternatives (if they exist)

Prerequisites

No previous experience necessary, however an understanding of standard SQL will provide a lot of context to make the content more valuable.

Supporting Resources

favorited by:
Matthew Groves Michael Fazio Andy Lester Colton Goza David Wanta Justin Weyenberg Timothy Tyson Jacob Galloway Daniel Laughland Elizabeth Groom Rolando Lopez Matthew Ives Mary Lou Essert Joe Forsythe Dan Wasmer Brandon Belman Rob Linxweiler Bob Dankert