Brian FemianoinDataDrivenInvestorBuilding a data model for The CircusA step by step case study in relational data modelingSep 22, 20221Sep 22, 20221
Brian FemianoinLevel Up CodingBloom Filters: Visuals for explanation and applied systemsThe bloom filter data structure lets you add elements and check containment, just like a set. They have a guaranteed 0% false negative…Aug 24, 2022Aug 24, 2022
Brian FemianoinLevel Up CodingUntangling nested subselect SQL queries into CTEsIn this guide, I’ll walk through a query involving several layers of nested subselects, and we’ll see how we can refactor the query into…Aug 8, 2022Aug 8, 2022
Brian FemianoinLevel Up CodingPython: Optimized sort over pre-sorted fake satellite telemetry data.Let’s learn a little Python and do so while solving a real-world problem efficiently.Jul 14, 2022Jul 14, 2022
Brian FemianoinLevel Up CodingCalculating time-weighted interest with SQL and the Newton-Raphson methodThis tutorial will use SQLite and Python. All you need to run is Python3 installed locally. By the end you should be able to run the Python…Jun 18, 20221Jun 18, 20221