Jay R. MontojoStarting SQL: Bucketing our data with GROUP BYIn this article let’s look at how theGROUP BY keyword works. This key word is a bit confusing in terms of what we would expect it to do…Apr 24, 2022Apr 24, 2022
Jay R. MontojoCode Tutorial: CRUD Restful Node API [Part I]The goal of this guide series is to walk you through creating a simple crud REST API. This guide will focus more on the actual set up of…Apr 19, 2022Apr 19, 2022
Jay R. MontojoStarting SQL: Sorting records with ORDER BYHello! today let’s take a look at the SQL keyword ORDER BY . We’ll first look at a question that we want to solve, a mental model, then…Apr 16, 2022Apr 16, 2022
Jay R. MontojoStarting SQL: LEFT & RIGHT JOINsThis is the last article in this series about joins. This time we will be looking at getting inclusive data from multiple tables, and then…Apr 13, 2022Apr 13, 2022
Jay R. MontojoStarting SQL: FULL OUTER JOINsIn the last article, we broke down what JOINs are and how to read them. This time, let’s look at another JOIN clause called the FULL OUTER…Apr 13, 2022Apr 13, 2022
Jay R. MontojoStarting SQL: Intro to JOINsRelational databases are great for storing data that have strong dependencies upon data in other tables. Some of the most useful SQL…Apr 13, 2022Apr 13, 2022
Jay R. MontojoC̶o̶p̶i̶n̶g̶ ̶W̶i̶t̶h Conquering Imposter SyndromeDear person who is anxiously dreading “(D)iscovery-day”… this article is for you.Dec 13, 2020Dec 13, 2020