GitHub

Phase 3 — PostgreSQL & Database Engineering

A collection of SQL exercises, Python database integration projects, and a database-backed REST API developed as part of my AI Engineering Learning Roadmap. This repository documents my progression ...
GitHub

GitHub - paras-the-coder/ai-sql-assistant: Autonomous Text-to-SQL AI assistant that converts natural language into secure SQLite queries with instant plain-English summaries ...

Autonomous Text-to-SQL AI assistant that converts natural language into secure SQLite queries with instant plain-English summaries. Built with LangChain, Groq (Llama-3), and Streamlit, featuring ...
HackerNoon

How to Calculate Net Revenue Retention in SQL Without Fooling Yourself

NRR is easy to inflate by accident. Runnable SQL for net and gross revenue retention, the retention bridge, a monthly trend, ...
blog.csdn

SQL中COALESCE函数全解析：告别NULL空值陷阱

本内容遵循CC 4.0 BY-SA版权协议 本文系统解析SQL标准函数COALESCE，涵盖其设计原理（处理NULL的三值逻辑问题）、短路求值机制、参数类型统一要求；重点介绍多字段优先级取值、与聚合函数配合 ...
blog.csdn

SQL字段为空用另一字段替换：NULL、空串与COALESCE写法全解析

本内容遵循CC 4.0 BY-SA版权协议 做数据开发这些年，我收到最多的临时需求里，有一类几乎每周都会出现：查报表的时候用户名的字段是空的，就显示手机号；统计订单的时候业务编号没填，就回 ...