Release date: 2026-07-26
This release expands the handbook with advanced SQL modules, improves repository infrastructure, and cleans up obsolete content. It's a feature and documentation release that prepares the project for broader adoption and continued module development.
- Advanced Aggregations module with business-case examples and expanded Aggregations content. (Jul 20, 2026)
- Views module. (Jul 15, 2026)
- Set Operators module. (Jul 14, 2026)
- String Functions module and status updated to "Complete". (Jul 10, 2026)
- NULL Handling and Data Cleaning module. (Jul 11, 2026)
- Complete Date Functions module and module README. (Jul 08, 2026)
- Window Functions materials and business cases:
- Comprehensive Window Functions README and learning objectives. (Jul 03, 2026)
- ROW_NUMBER, RANK, and DENSE_RANK examples and SQL files. (Jul 03–07, 2026)
- PARTITION BY documentation and advanced window-function lessons. (Jul 04, 2026)
- Banking & finance business-case studies for window functions. (Jul 06–07, 2026)
- GitHub Actions workflows and repository infrastructure files (linting, templates). (Jul 08, 2026)
- Revised README across multiple commits for improved presentation, banners, images, badges, and navigation. (Jun 30 – Jul 23, 2026)
- Reorganized repository structure and module numbering for clarity; renamed files where necessary. (Jul 10–13, 2026)
- DATABASE_SCHEMA.md revised for clarity and improved table descriptions. (Jul 05, 2026)
- ROADMAP.md refined with clearer examples and release planning. (Jul 03, 2026)
- Deleted obsolete directories and files: Resources (multiple files like Resources/x.md), X-Schema directory, and 09_Business_Case_Studies. (Jul 10–26, 2026)
- Cleaned up branding/assets: removed .DS_Store files and adjusted assets as needed. (Jun 30 – Jul 12, 2026)
- Fixed typos and link references (e.g., PARTITON → PARTITION; Module 05 link fix). (Jul 04, Jul 20, 2026)
- Added ARCHITECTURE.md and STYLE_GUIDE.md to document repo architecture and standards. (Jul 08, 2026)
- Created SUPPORT.md and FAQ.md to help contributors and users. (Jul 03, 2026)
- Added CODEOWNERS, markdownlint config, PR/issue templates, and contributor guidance. (Jul 08, 2026)
Notes:
- This release is non-breaking and focuses on additions and documentation improvements.
- If you want a different version number (e.g., 1.0.1 patch or 2.0.0 major), tell me and I can update the files and release notes accordingly.