For the #SQL & finance nerdery folks, this was an good writeup¹ of fraud-detection using SQL, providing actual queries with technical explanations.
-
For the #SQL & finance nerdery folks, this was an good writeup¹ of fraud-detection using SQL, providing actual queries with technical explanations.
I'll grant, the audience for the post is pretty niche, but if you're an aspiring SQL dev, it has some strong examples using window-functions (including named window-functions² which I don't often see in the wild, since it's only become more available in the last 5 years or so).
⸻
¹ https://analytics.fixelsmith.com/posts/sql-fraud-patterns/ -
For the #SQL & finance nerdery folks, this was an good writeup¹ of fraud-detection using SQL, providing actual queries with technical explanations.
I'll grant, the audience for the post is pretty niche, but if you're an aspiring SQL dev, it has some strong examples using window-functions (including named window-functions² which I don't often see in the wild, since it's only become more available in the last 5 years or so).
⸻
¹ https://analytics.fixelsmith.com/posts/sql-fraud-patterns/@gumnos Fascinating read, thanks!
-
@gumnos Fascinating read, thanks!
@nuintari yeah, it was the sort of thing that, had I been told "make a query that does XYZ" for one of those points, I could have come up with something pretty similar to any of them. But the underlying "these are important signals to monitor" was equally interesting as the technical/SQL aspect. Glad you enjoyed it too!
-
S stefano@mastodon.bsd.cafe shared this topic
