TECHNOLOGY / KNOWLEDGE / PRACTICE

Search results: ai - Page 2

Practical guides to AI, Python, Git, SQL, Web/API, SAP/ERP and mathematical models, with explanations, code examples, sources and limitations. Page 2.

Every word must appear in the article. Use quotes for an exact phrase.

SQL Python RAG SAP API

Search results

25-27 / 27 guides Reset

Data & databases

SQL: WHERE vs HAVING - Difference in Row and Group Filtering

A detailed technical breakdown of the differences between WHERE and HAVING clauses, focusing on execution order, aggregate function compatibility, and performance optimization strategies.

SQL / PostgreSQL / Database / Query Optimization / Data Analysis

Math & models

Compare a time-series forecast with a seasonal baseline

Build a previous-season reference, evaluate it on later observations and distinguish calendar alignment from leakage and missing data.

Time Series / Forecasting / Baseline / Validation

Math & models

Validate a time-series forecast without leaking the future

Use chronological splits and fit preprocessing only on past data.

Python / Time series / Validation