ZZyVOP·4d agoTop SQL Concepts Every Data Engineer Should KnowA practical guide to the SQL skills behind production data pipelines, from joins and window functions to MERGE, SCD2, and data quality checks.17 min read·blog.zyvop.com
KKPI Partners·Aug 27Recruitment Analytics for Oracle HCM Cloud Starts With Metric ContractsA practical framework for defining candidate tracking and hiring metrics before building dashboards.6 min read·kpipartners.hashnode.dev
SSpecial Needs Care Network·Aug 20Orchid Academy Issaquah Is Two Rooftops: Why (Brand, City) Is the Wrong Unique KeyOrchid Academy Issaquah publishes two academy addresses in the same city with the same hours and age band. A uniqueness constraint on brand plus city merges them. The stable key is the rooftop.3 min read·spcn.hashnode.dev
SSpecial Needs Care Network·Aug 15Service Tags Are Not Provider Types: Modeling Speech Therapy at Special Needs Care NetworkA provider directory needs one primary type per record and many services per record. Conflating the two produces duplicate listings and split ranking signal. Notes from the Special Needs Care Network directory.4 min read·spcn.hashnode.dev
BBecky·Jun 29Designing a Generation Pipeline — A 4-Axis Content Model, Queue-Based Scheduling, 3-Layer AttributionDesign decisions behind making content without a bot signature, publishing without SaaS, and measuring views → clicks → conversions15 min read·beckybuilds.hashnode.dev
JJemish Mavani·Jul 12, 2023Smooth Data Modeling with 'Freezed'With Freezed, you can effortlessly generate concise data classes, eliminating repetitive code and enhancing stability. Plus, Freezed empowers you to handle4 min read·james54.hashnode.dev