InTDS ArchivebyDakota Smith·Jul 25, 2023Hacking MySQL’s JSON_ARRAYAGG Function to Create Dynamic, Multi-Value DimensionsMaking up for one of MySQL’s lesser-known shortcomingsA response icon1A response icon1
InLevel Up CodingbyDakota Smith·Mar 8, 2023Using Python and the Terminal to Simplify Repetitive Data TasksA beginner-friendly guide to getting started with the macOS Terminal to call Python scripts in a few short characters
InLevel Up CodingbyDakota Smith·Sep 2, 2022Why is Python Used in Data Analytics?Short answer: Because it does pretty much everything
InLevel Up CodingbyDakota Smith·Jun 16, 2022How to Break Down a “Hard” SQL Interview QuestionIn which I walk step-by-step through the process of answering a Yelp SQL interview question labeled “Hard” by StrataScratch
InLevel Up CodingbyDakota Smith·Apr 18, 2022SQL Querying for Beginners: INNER and RIGHT JOINsA beginner-friendly explanation of how INNER and RIGHT JOINs work in SQL
InLevel Up CodingbyDakota Smith·Mar 22, 2022SQL Querying for Beginners: LEFT JOINsA beginner-friendly explanation of how LEFT JOINs work in SQL
InThe Writing CooperativebyDakota Smith·Mar 17, 2022How Gilmore Girls Uses Inefficient Storytelling to Tell a Story EffectivelyWriting “rules” often exist for good reason. But it’s also good, every once in a while, to see those rules broken effectively.A response icon3A response icon3