SELECT MAX(value) FROM database.advanced_features;
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.