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…3 min read·Apr 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…3 min read·Apr 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…3 min read·Apr 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…3 min read·Apr 13, 2022--1--1
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…4 min read·Apr 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…3 min read·Apr 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.6 min read·Dec 13, 2020----