Explore >> Select a destination

You are here

 data36.com
Learn SQL for Data Analysis from Scratch (10+1 articles)
| | curatedsql.com
Dynamic Search in SQL Server Stored Procedures - Curated SQL
4.7 parsecs away

Travel
| |
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
4.5 parsecs away

Travel
| | Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without.
| | antonz.org
SQL join flavors
4.3 parsecs away

Travel
| | The many faces of JOIN in SQL.
| | www.onehouse.ai
S3 Managed Tables, Unmanaged Costs: The 20x Surprise with AWS S3 Tables
24.5 parsecs away

Travel
| AWS S3 Tables aims to simplify Apache Iceberg table maintenance, but we found long compaction delays, limited observability, and costs 20-30x higher than alternatives. Delays of 2.5-3 hours hurt performance, and S3 Tables lack controls over compaction frequency or performance profiles.